View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rebecca[_4_] Rebecca[_4_] is offline
external usenet poster
 
Posts: 8
Default Saving collected data?

Hi Everyone,
I am compiling a table/worksheet that collects date related numerical
information from another worksheet. ie:

The table collecting the info is just columns of dates for a year with
adjacent columns for data collection.

The worksheet supplying the info has new information entered every day under
that days date. (the date changes automaticaly & the numerical info is always
entered in the same cell adjacent to the date [a bit like a form]).

I have no problem collecting the info for todays date BUT!!! how can I stop
that info from changing (how can I save it) in the collecting worksheet, when
the date on the supplying worksheet moves on the the next day/date with new
info entered ?

Hope this makes sense to someone.
--
Thanks Becky