Jun 06 2022 02:59 AM
Hi,
i would like to know how delete a row without loose the references about this row.
I give you an example, if i have a formula with some cell of row 64, and i want delete it, i would like that excel understand to update the reference with the new row below.
Thank you so much
Jun 06 2022 03:03 AM
SolutionYou can use the INDIRECT function for this:
=INDIRECT("E64")
will always refer to cell E64, even if you delete row 64, or insert or delete rows above it.
Jun 06 2022 03:23 AM
Jun 06 2022 03:48 AM
What do your formulas currently look like? Simply =cell_reference or more complicated?
And which cell references should be changed? Only those that refer to row 64, or all references, or something in between?
Jun 06 2022 06:45 AM
Jun 06 2022 06:50 AM
The argument of INDIRECT must be a string:
=IF(INDIRECT("'TEMPLATE_data entry'!E$10")<>"",INDIRECT("'TEMPLATE_data entry'!E$10"),"")
Jun 06 2022 07:15 AM
Jun 06 2022 07:35 AM
Jun 06 2022 03:03 AM
SolutionYou can use the INDIRECT function for this:
=INDIRECT("E64")
will always refer to cell E64, even if you delete row 64, or insert or delete rows above it.