VBA - Identify duplicates and Blanks
Posted on 2014-04-24
I would like to create a VBA script in Excel (2013).
I would like the script to work down a worksheet (called 'PM') from row 4 (in column A) downwards until the end of the list and look for two conditions:
The cell in column C of the same row is blank or;
The value in column C is not duplicated elsewhere in column C at all on this worksheet.
If the condition(s) are met above I would like the row number on which the condition was picked up and quick outline of which issue was identified above to be put on another worksheet called errors!
I know a little about VBA scripts - could someone start me off in the right direction as I have not picked one up in a little while.