How do I retain data permanently in one worksheet from changing data from
another referenced worksheet in the same workbook. For example, every month
a particular workbook will be opened and saved as the current-period
worksheet. This work sheet has the past month data in it and will be
replaced with current period data. But I would like to retain the previous
data in another sheet in this workbook without re-typing the data in
manually. An example would be carrying monthly totals for the purpose of
calculating year-to-date totals.

Any suggestions would be appreciated!

Exel User Wrote:
How do I retain data permanently in one worksheet from changing data
from
another referenced worksheet in the same workbook. For example, every
month
a particular workbook will be opened and saved as the current-period
worksheet. This work sheet has the past month data in it and will be
replaced with current period data. But I would like to retain the
previous
data in another sheet in this workbook without re-typing the data in
manually. An example would be carrying monthly totals for the purpose
of
calculating year-to-date totals.

Any suggestions would be appreciated!


Assume the data that you want to keep is on a worksheet named FEB.

Right click on the tab that says FEB, then
select Move or Copy, then
check the Create a Copy box.

Having done that, then go to the worksheet now called FEB (2).

Select the entire worksheet, and do
Edit, Copy, then
Edit, Paste Special, Values.


--
rsenn
------------------------------------------------------------------------
rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050
View this thread: http://www.excelforum.com/showthread...hreadid=519151