Q
Questor
Can I define a "cell name" in such a way that when I do a "Sort&Filter"
causing the row containing the cell with a defined name to move up or down,
the "cell ID" for the "defined name" follows that move.
For example:
if … I define cell A14 as "XREF-01" and a "Sort&Filter" causes that cell to
change its position to cell A(14±n) — where "n" represents the number of rows
up or down that row "14" moves
then … the defined name "XREF-01" moves to cell A(14±n).
Thanks
causing the row containing the cell with a defined name to move up or down,
the "cell ID" for the "defined name" follows that move.
For example:
if … I define cell A14 as "XREF-01" and a "Sort&Filter" causes that cell to
change its position to cell A(14±n) — where "n" represents the number of rows
up or down that row "14" moves
then … the defined name "XREF-01" moves to cell A(14±n).
Thanks