Warn if duplicate data is present

[pprseller]

Is it possible to adapt this code to determine if data in column 1 and/or column 2 of the active sheet already exists? This takes info from the "order" sheet and exports it to the active sheet. I'd like it to see if any part of the export is present before continuing. For example if the user is exporting "Main Street Saloon" from cell G5 and "Main" or "Steet" or "Saloon" is present in column 1, they get a msgbox that says "this name exists, continue or quit export"? Then the same for data from cell G6 to column 2. I'm not real good at the "With" functions and I do appreciate the help.

Please Login or Register  to view this content.

Thank you, thank you!

[jrdnoland]

What you're asking is a little confusing, perhaps posting a workbook with a before and after worksheet may help.

I think you could do some sort of find on the active sheet before the export and if the find is positive then display your prompt.