cell reference changing when row inserted

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have formulas on a 2nd worksheet referencing cells on the original (HVAC).
(i.e. =CONCATENATE(HVAC!$B$6,HVAC!$H$6)). These results are then
automatically summaried and graphed on an additional sheet.
When a user inserts a new row into middle of the HVAC sheet (which is
sometimes necessary), the cell reference on the summary page changes (shifts
down one number) so the new row is not counted
=CONCATENATE(HVAC!$B$7,HVAC!$H$7).
Can I prevent this from happening?
I would greatly appreciate any help on this one.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cell reference changing 2
Relative worksheet reference clarified 4
Updating a reference ROW 2
Duplicate "Drag" feature 2
Linking different cells from one sheet to another in same workbook 2
modify all formula references in multiple cells 3
Calculating inserted rows or colums from another sheet 1
Deleting a row - followup question 3

Back
Top