Data Validation - List of invalid data needed

Hi there,

I have 12 massive sheets that I import into a access db once a month, the sheets have data validation on certain columns, but with 20000+ lines on each sheet and 40 odd columns of data looking for red circles has become a rather tiresome pastime... usually there are only 10 or so errors, but without knowing the number of errors or where they are its a slow dull process...

Is there anyone out there who could help me create a macro that would create a new sheet within the workbook that will list the cell references of the invalid data? or any other ideas to help would be great! I'm running xl 2007 and fairly familiar with recording and editing the odd macro.

TIA

You can try this:

Please Login or Register  to view this content.

Might want to try with a smaller set of data first though.