| 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 |
| 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 | |||
Threaded Mode
