Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Keep a static record of data
Dear reader,
I have a data set that refreshes to an Excel spreadsheet. I want to be able to track changes of this data set from one week to another. In order to do this, I need to have a static record of the data on a weekly basis. Is there a way to automatically paste special the value of a dataset according to a date? (I know this task is easily accomplished in Access. Don't ask me why I'm doing it in Excel...) Thanks for your help, Pablo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace static data by dynamic data without loosing all the formul | Excel Worksheet Functions | |||
Pivot charts - data disappear after selecting or data are static | Excel Worksheet Functions | |||
Use a static set of data for input into a macro | Excel Discussion (Misc queries) | |||
Copying data as static as source data changes | Excel Worksheet Functions | |||
static data consolidation | Excel Worksheet Functions |