Find string in Column A then verify Date in Column B

Hello,

I have searched for the answer to this question for hours and cannot seem to find what I need. I am looking for what seems so simple, I am searching for a string in Column A and simply want to verify the date in Column B.

Here is what I am using for code to search:

Please Login or Register  to view this content.

I have no clue how to add looking at ColumnB to check for the date once the string has been found in Column A.


I posted a similar question here:
http://www.excelforum.com/excel-prog...html?p=3009815

Try something like this (based on your original question)...

Please Login or Register  to view this content.

AlphaFrog

Thanks VERY much for the help, I can't thank you enough for your time. I think this is PERFECT for what I need. One question about this code.... What will tell me exactly when the 6 month marker from today has been reached? Such as 6 months and 1 day.

I should clarify that... How to tell 6 months & 1 day ago.

DateAdd("m", -6, Date)

Date is today's date.
The DateAdd function subtracts six months from today's date.
That calculated date is compared to the Historical Record date.

Good point. This will return the last match in the column.

Set Found = Sheets("Historical Record").Range("A:A").Find(strFind, , , xlWhole, , xlPrevious, False)

Here's a primer on the .Find method.

I gave this a try and the msgbox did not trigger. I used a PMC104 at the top with a date of 2/1/2012 and then a PMC104 about 8 lines down with 7/1/2012.

It worked for me.

Please Login or Register  to view this content.

Thanks, I think I got it..... I have no idea what I did wrong, but it's working now. Thanks for your help! Greatly appreciated.