Hi I have 11 columns of data and about 22'000 rows. In column A I have a list of email addresses of which there are many duplicates.
What I need to do is when I find the 2nd incidence of the email address I need to move/copy that row of data onto sheet 2. When I find the 3rd incidence I need to move/copy that row to sheet 3 and so on
I did a countif of the email addresses and the maximum number of incidences of one email address is 43
Can anyone help me with the code I need to use to automate this?
I hope this is clear
Cheers
What I need to do is when I find the 2nd incidence of the email address I need to move/copy that row of data onto sheet 2. When I find the 3rd incidence I need to move/copy that row to sheet 3 and so on
I did a countif of the email addresses and the maximum number of incidences of one email address is 43
Can anyone help me with the code I need to use to automate this?
I hope this is clear
Cheers