Sorting - Some data in another sheet

[asallwey]

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

 

[Fluff]

Sounds like you want to use VLOOKUP

 

[asallwey]

Ok, tunnel vision didn't let me think of using a function, I was just focused on the Task's row. I think I would have to build in a matching code field in the 2 sheets. Have to give it some thought.

Thanks for getting me thinking again!

 

[Fluff]

You're welcome & thanks for the feedback.