PDA

View Full Version : Solved: Compare two workbooks and count matches



Nosstech
08-05-2008, 05:49 AM
At work, we service multiple regions. We have had a single spreadsheet that contains North America and Latin America. What my bosses have asked for is a count of systems in LA.

I have a list of LA Systems and a list of all Servers.

What I want to do is compare Col B of workbook 1 (LA Systems) with column I of workbook 2 (All Systems) and have a message box display the number of matching systems.

I am learning VBA little by little and this forum has been great! Thanks for any help you can give.