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.
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.