Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas Changing
MS OS: 2000, Excel: 2000
Sheet 2 has data on it supplied by a MS Query. Sheet1 is looking at each cell in Sheet2 and displays the exact same data. Example Cell a2 on Sheet1 is: =IF('Report Capacity Violations'!$A$2="","",VALUE(CONCATENATE(MID('Repo rt Capacity Violations'!$A$2,5,2),"/",RIGHT('Report Capacity Violations'!$A$2,2),"/",LEFT('Report Capacity Violations'!$A$2,4)))) I do it this way so that I can properly format the data and use the formulas I have on Sheet1 with the data on Sheet2. Sheet2 is Report Capacity Violations in the above formula. The problem is for some reasons the formulas change and try to reference the incorrect cells. In the above formula the sheet never changes but the cells change. I even changed its referencing to absolute using $A$2 instead of A2. I go down 30 rows with the formulas. Sometimes rows 1 through 5 are OK then the next value is $A$12 and so on. Please help. Thanks in advanced. -- Richard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stopping formulas from changing when sorted | Excel Worksheet Functions | |||
Changing Multiple Formulas | Excel Discussion (Misc queries) | |||
Automatic Changing of Formulas | Excel Discussion (Misc queries) | |||
Changing values but not formulas | Excel Worksheet Functions | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |