Hi,

I need help creating a VBA/Macro, that will take a list of job titles and combine them with a list of countries to create multiple unique entries. e.g. Job title - Cleaner, countries GBR, USA, GER, FRA and the unique ID's will become CleanerGBR, CleanerUSA, CleanerGER, CleanerFRA. my challenge is I have c1000 job titles, and 32 countries - do the list will have c32000 unique ID's.

can anyone help?

thanks.