Excel macros for finding out recurring values in a column

This is what I need to do:
for worksheet.column= p13 value=’Blocked’

On activating worksheet
1.check the status cloumn in each worksheet in the file.
2.if status value is blocked, give count
3.check if value is present in defect column where the value of status is blocked.
4.then check the count of values in defect cloumn.

should be same as status column with value as blocked, if not throw error, data missing in defect column.

5. if yes, then count for each value in defect column
6. check if value is repeated in that column, if yes return
value of count and the value itself.

7.if no check next