-
Solved: Compare two workbooks and count matches
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules