View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mrhcpa mrhcpa is offline
external usenet poster
 
Posts: 2
Default How do I get rid of #REF error, imported Data changes

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