Reference cell between worksheets
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?
Probably easier to see your problem if you post a sample workbook showing the issue.
(zipped xl2003 file would be best)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1