Is it possible to reference the data in a cell and not the cell address?
Example: I have a reference in sheet 2 to a cell in sheet 1. If I sort the data in sheet 1, and the data moves to a different cell, my reference in sheet 2 now displays the wrong data.
Is it possible for me to sort the data in sheet 1 and have my reference follow the data to the new location?
Bookmarks