I have a worksheet (call it #1) that lists Tasks. Date, and a couple more columns. I have a 2nd sheet that has a few of #1's tasks, along with more information on each. Sheet #1 works fine with several sort macros. Then I got the bright idea to go to the Date field in #2 and point it back to the Date field in #1 for a given task. Works fine until I sort #1. #2's formula is looking at the specific cell I targeted when I made the formula. The formula does not move with the Task, it continues to point to the cell.
Is there a way to point to the contents of the cell even when it moves around by sorting?
Thanks!
PS Excel 2007
Is there a way to point to the contents of the cell even when it moves around by sorting?
Thanks!
PS Excel 2007