I am looking for some code which will allow me to evaluate every record in worksheet 1 to determine whether each has an exact match of the value in Column A with Column A of any record in worksheet 2. If there is a match, return a true/false determined by whether the date listed in column B of worksheet 2 is after the date in Column B AND before the date in Column C of worksheet 1. Example attached.
You can do it with a formula
Formula:
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks