Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have 2 sheets in a workbook. The one sheet has a ODBC query in it and the
range of data can grow and shrink based on the data query. The second sheet has formulas looking to the first sheet for formating reasons. If I refresh sheet 1 with the ODBC query on it and the sheet grows (more records) the formulas in sheet 2 change. (ie cell A100 was "='JC INFO'!F1369" but after refresh changes to "='JC INFO'!F1400"). I do not want the formulas to change in the second sheet - how can I do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lookup Lookup Lookup | Excel Worksheet Functions | |||
Lookup Function Problem | Excel Discussion (Misc queries) | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
lookup problems | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |