Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Value to remain constant
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Value to remain constant
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Value to remain constant
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Value to remain constant
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Value to remain constant
Hi Gord
I am sorry , if I am not able to explain properly. To make it simple. If I have a workbook with 2 sheets. Sheet1 and Master(sheet2). Sheet1 does all the calculation based on months and gets the data from Master sheet The problem that I face is that my Master sheets gets updated every month. So for example, I have the data calculated in my sheet 1 for the month of Jan and now when my Master sheet gets updated in Feb, my Jan data also gets changed because Master has new results. I want to keep the JAN data in Sheet1 as if, even if I update my Master. The Formula that I have in Sheet 1 is like : Countif(a2:a34="P", b2:b34)*Countif(c2:c34 = "JAN", b2:b34) "Gord Dibben" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Value used in a Paste Link to remain constant during a sort | Excel Discussion (Misc queries) | |||
Cell reference value to remain constant in a sort using Paste Link | Excel Discussion (Misc queries) | |||
How to make a cell address remain constant when copying a formula | Excel Worksheet Functions | |||
remain constant in a copy & paste | New Users to Excel | |||
data source remain constant | Charts and Charting in Excel |