|Wow, that's lot of work you did.|
Thanks so much.
As for the details, I need the date, like mar 17.
Basically, each workbook contains a month. Along the bottom are tabs that have each day of the month.(Thanks to Bryan and ASAP Utilites.)
So if an invoice (315747) is in a column called Contract # on mar 17, I need to see that that date contains that contract number.
Once I have that I can navigate to the proper workbook.
BTW, I just tried that and it worked great on the test book.
If I could do that across the workbooks, one for each month, I'd be all set.
And since I would like to learn VBA, where would I start to learn how to do this so I don't have bug someone for the basics?