Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet data linking ???
Hi umm i have a spreadsheet which has 2 worksheets on it.
i want it so that when the data on worksheet "rawdata" get's entered it apears on the second worksheet daily. I know how to do this but here is the hitch the data i want from "rawdata" is a avg formula so it is changing daily but i want to keep the figures that where in it on the day it was entered but not change the data when the next day's data is entered as this will change the data So can you right a macro or something to copy the raw figures for that day into one collum but when i enter the next day's data and the avg changes it will enter that day's data in a seperate collum and keep the previous day's data dont know if this is possible but it would be very handy Thanks Rodney... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking data from one worksheet to another... | Excel Worksheet Functions | |||
linking data from one worksheet to another | Excel Worksheet Functions | |||
Linking worksheet data | Links and Linking in Excel | |||
Linking worksheet data | Excel Worksheet Functions | |||
can I name an excel worksheet tab by linking to worksheet data? | Excel Worksheet Functions |