Thread: Lookup problems
View Single Post
  #1   Report Post  
thecuzin
 
Posts: n/a
Default Lookup problems

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?