I can't suss out your configuration of workbooks and sheets.

You have two workbooks, one called MASTER with two sheets......Sheet -1 and
Master?

The other workbook is named ?? and contains another sheet named Master and
one named Sheet -A?

Somewhere in there you will have to break some links so the values for JAN
data do not update.


Gord

On Tue, 10 Mar 2009 13:28:01 -0700, ub wrote:

Hi Gord
Thanks for the reply
But I have the January data is in the Master Sheet and my formula's are in
the Sheet -A. So the SHEET -A formuls links to MASTER workbook Sheet -1. The
master workbook has another sheet called Master that gets updated every month.
SO basically in the master workbook , data in the sheet 1 gets calculated
from the master sheet in the same workbook and then the SHEET-A links to the
sheet1 of the master workbook.
SO if I update my master, it updates the SHEET1 calculation, that effects
the linked sheet-A


"Gord Dibben" wrote:

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