Workbooks

[Sandy 441]

General: I keep quarterly data on Workbook "A". It has 6
spreadsheets. The data for the quarter is summarized in
one of these spreadsheets - Qtrly Report. This report is
then sent to another Workbook "B" which has room for 4
quarters.

Situation: At end of the first quarter I would like to
use Workbook "A" again to enter the data for the second
and subsequent quarters. I woul have to clear the data by
deleting all entries to make room for the next quarter.

Problem: If I delete the data for the first quarter, it
also delets the data for that quarter in Book "B".

Question: How can I prevent the problem?

Thanks for your help. I'm using Excel 2002.

Sandy

 

[Don Guillett]

I assume you are using formulas to populate workbook B. If so, just change
to values using copy/paste values or write a macro to do it for you.