How to find a particular cell using macro?

  • Thread starter Thread starter Infinity
  • Start date Start date
I

Infinity

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. :
 
Infinity,

I don't think you need code to do this but more formatting of the
sheet with the Vlookup Code... Have you considered using all 256 dates
(top row) and assigning a HLOOKUP code?
 
The file was done in a particular manner so that the values there ar
being lookup. I cant change the format now, the file is too big.:(

Btw, i need to activate the cell is because i want to copy some value
there.

hope that u can help me out here.

Thanks again..:
 
Actually i manage to find the row for "Cost" but then i cant seem t
figure out how do i go to the particular date and activate the cel
below...


Here's what i did..
For Each c In Range("A:A")
If c.Value = "Cost" Then
c.Cells(1, 1).Select
ActiveCell.EntireRow.Select
End If
Next c

Please help and thanks.:
 
Back
Top