I have an excel spreadsheet with 8 sheets in it. On each sheet are company names, addresses, phone numbers, and some emails. Each sheet represents 1 country and in total there are about 30,000 records.
What I'd like done is all the sheets consolidated into one. Then I would like all of the duplicate email addresses removed (but not with the corresponding records).
In each sheet, an extra column with the country will need added so when theyre consolidated there's a country column. Right now all the sheets dont appear in the same format order - some are name, address emai, and others are email, name, telephone and so on.
If you dont know how to write and run macros, this isn't for you. I dont know how to do it but I know there's a macro you can run to eliminate all duplicate emails for example. So this job should only take 3 hours maximum for someone with genuine expert knowledge in excel.
So please dont apply unless you have this knowledge.