VBA to search for a particular piece of data then select specific cell in that row

[jonathan.haynes]

Hi,

I have dates in column A and numbers in column B.

I want to use a macro that will search for a specific date depending on a criteria.

So I need the following:
The VBA code to search for a specific date.. lets use today-2 for this example (23rd October).

FIND TODAY-2 and Select the cell in column B which is in the same row as TODAY-2

Example attached

Cheers!

example.xlsx

[ragulduy]

Please Login or Register  to view this content.