Lock in data by a date

D

dmeconi

Help please...How can I lock in data collected by date in one file which
comes from another file where the date is changing daily.

For example, file one has date and data I record in file two. The next day,
file one's date changes and has new data. I need day 1's data under day 1,
and day 2's data under day 2 etc. The file name of file one does not change
but the daily data I need to record will.

Any assistance would be greatlly appreciated.
 
J

Jim Rech

Although your post doesn't say it I'm guessing that file 2 has formulas that
reference file 1 and therefore the values of the formulas change when the
referenced ranges change. If that's right I can only suggest that you do a
Copy/Edit, Paste Special, Values of the formulas in file 2 to a "holding
area" in file 2 each day. The holding area will retain a permanent database
of the results of the formulas and grow each day as you copy new values to
the end of it.

--
Jim Rech
Excel MVP
| Help please...How can I lock in data collected by date in one file which
| comes from another file where the date is changing daily.
|
| For example, file one has date and data I record in file two. The next
day,
| file one's date changes and has new data. I need day 1's data under day 1,
| and day 2's data under day 2 etc. The file name of file one does not
change
| but the daily data I need to record will.
|
| Any assistance would be greatlly appreciated.
 
Top