Thread: Exact reference
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Court
 
Posts: n/a
Default Exact reference

Hey~

I am trying to make an output sheet from a separate calculation sheet. I am
pulling certain values from the calculation sheet and putting them on the
output sheet. The problem is that when I add a row or cut and copy
information on the calculation sheet, it doesn't change on my output sheet.
If it does change it says #REF. Is there anything I can do so that I can
just enter the formulas 1 time into the output sheet and not have to worry
about problems when I add rows in the calculations sheet?