Comlicated - maintain data

D

dmeconi

I need to get data from a work book (1) to another (2) which is no problem.
The problem is, I have to hold that data by the date and when the date
changes in the same cell, on the same workbook (1), the data is recorded
under the next date in the next cell in workbook 2.

In other words, workbook 1 is being saved as the same file name daily.
Workbook 2 must save the data for each day.

Any assistance would be appreciated.
 
P

Paul Corrado

Have you considered having workbook 2 be the source of the data for workbook
1? In this scenario, workbook 1 would have a formula that pulls the latest
data that you enter in workbook 2.
 
D

dmeconi

No, I had not. I will have to try to figure that out. I imagine I can have it
pull it once daily and take it down a row each day.........?
 
Top