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

"mrhcpa" wrote:

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)?