Hi,
I have an excel sheet with 20 plus sheets filled by people from different parts of the world. Users enter their respective names and countries on 19 out of the 20 sheets.
The last sheet will contain all records from users of the same country.
I'm trying to write a macro which will compare cell "C3" of the each of the first 19 sheets ("C3" is a validation list of all countries), with cell "D6" of the last sheet.
If C3 = D6, then all non empty cells between starting from B9:M9 will be copied from sheets (1-19) to sheet 20. The macro will look for the next empty row on sheet 20 and paste matching records to avoid overwriting previous matches.
The problem is that the macro is only copying from one sheet, and keeps on looping... Please help!
Thanks in advance!
Please see code below:
Bookmarks