Retaining last months info when new month entered

  • Thread starter Thread starter Weatherall Ian D.
  • Start date Start date
W

Weatherall Ian D.

Hello I have a worksheet sent to us every month, this data is copied to
another workbook we use. The workbook has 13 sheets i for each month and 1
for data entry. I cant copy like for like as the cell references are
different.
The cells for any particuarly month checks the month number, eg update the
cell if the month matches the month on the data entry sheet eg.

=IF(Data_Entry!E3=9,Data_Entry!D33,"0")

where data_entry!e3 = the current month and data_entry!d33 is the source for
that particular cell

Everything is fine, but I need to retain the data in the earlier months,
when I increase data_entry!e3 by 1 the previous months data is cleared from
the worksheet.

I hope I have explained things clearly enough.

Thanks in advance
 
select the cells in the previous month, do Edit=>Copy, then
Edit=>Pastespecial => Values. this will overwrite the formulas with the
values they display. do this before you change the value in Data_Entry!E3.
 
Back
Top