At the end of January copy and Paste SpecialValues


Gord Dibben MS Excel MVP

On Tue, 10 Mar 2009 11:54:06 -0700, ub wrote:

Hi
I have a sheet -A in which the data comes from the Master sheet through
linked cell.
My sheet A has multiple rows based on the months like JAN FEB etc.
For the month of JAN (SHEET A) the data comes from the MASTER after doing
calculations.
The problem I have is that every month the MASTER sheets gets updated So if
I have value in SHEET A in row JAN and now my MASTER gets updated in FEB, my
FEB data populates correct, but my JAN data is not correct because it is now
being calculated with new MASTER sheet.
What can I do to keep the values in row JAN intact, when refernce MASTER
sheet is updated.
I am willing to write VBA code also