Hi and help,

I import a csv file and using macros run multiple changes and format it into a spreadsheet.

in column b on spreadsheet labeled "loadlist" , I would like a pop up box if any duplicate values appear and if possible if the word "TBA" appears.

I could run a seperate macro for this or add it onto the exisitng one.

regards

Campbell