M
ml
I have created 4 individual workbooks (A, B, C, &D) that link to our master
workbook - total of 5. At 4:30 each day, my manager or I will go in to the
master workbook and pull the summary report created in the master workbook.
Sounds easy...but this is the problem. I want to keep a copy of the summary
for that day, in the meanwhile, delete the old data from workbooks A, B, C &
D so that other managers can go in and key new data the next day and at 4:30
each day we'll be able to print a new report without losing old data in the
Master workbook. May export reports to a different workbook? I don't
know...Any suggestions?
workbook - total of 5. At 4:30 each day, my manager or I will go in to the
master workbook and pull the summary report created in the master workbook.
Sounds easy...but this is the problem. I want to keep a copy of the summary
for that day, in the meanwhile, delete the old data from workbooks A, B, C &
D so that other managers can go in and key new data the next day and at 4:30
each day we'll be able to print a new report without losing old data in the
Master workbook. May export reports to a different workbook? I don't
know...Any suggestions?