How do I get rid of #REF error, imported Data changes

[Guest]

importing Quickbooks data in sheet 1 of Workbook changes size resulting in
cell reference errors in Output sheet 2. is there a way around having to
change cell references on sheet 2 when imported data is refreshed (ie
inserts or deletes rows on Input sheet 1)?

 

[Guest]

Need a little more information on your question. I'm guessing that you could
either use one of the LOOKUP formulas (VLOOKUP) on Sheet2 to lookup the
appropriate value in sheet1 based on some field heading.

Or perhaps using the INDIRECT formula would work. This will only work
however, if a field value is ALWAYS in a particular cell (ex. net sales is
always in cell A3).

Hope this is a start.

Bill Horton

 

[Guest]

Thanks for your reply Bill, INDIRECT will not work because after input
refresh, the desired field value has moved. If Quickbooks exports a value
other than "0" in a previously unreferenced cell, it moves all data fields
down an extra row making previous cell references (before refresh) incorrect.
I am trying to avoid manual updating of cell references on the output sheet
when input field data moves. Thanks any suggestions?