cell reference changing

[Guest]

Good Morning.
I have some formulas that reference cells on another sheet-
(=CONCATENATE(HVAC!$B$6,HVAC!$H$6))
These results are then summaries and charted.
But, when a user inserts a row within the form (which is sometimes necessary),
the cell reference shifts down one number, so the new row is not included in
my summary.
Can I prevent this from happening?
Thanks.

 

[Frank Kabel]

Hi
try
=INDIRECT("HVAC!$B$6") & INDIRECT("HVAC!$H$6")

 

[Guest]

Thank You.

Hi
try
=INDIRECT("HVAC!$B$6") & INDIRECT("HVAC!$H$6")