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...