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