Retaining data permanently from periodic changing data in workshe.

[Exel User]

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!

 

[rsenn]

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.