Ok, let me explain. I have a worksheet it consist of the following

Column A Column B Column C .....
2-Aug-06

Units 1-Aug-06 2-Aug-06 ..... list goes on
Unit-A
Unit-B

Cost 1-Aug-06 2-Aug-06 ..... list goes on
Unit-A
Unit-B

Sales 1-Aug-06 2-Aug-06 ..... list goes on
Unit-A
Unit-B

Let's say today is the 2-Aug-06 in cell "A1" (this is a referring t
another worksheet). Now i want to activate the cell under "Cost" fo
"Unit-B" for that particular date, which is cell "C9".

Can anybody help me write a macro to find and activate this cell?


Thanks in advance. :

--
Infinit
-----------------------------------------------------------------------
Infinity's Profile: http://www.excelforum.com/member.php...fo&userid=3272
View this thread: http://www.excelforum.com/showthread.php?threadid=57363