I have some experience with JS and Python, but am still relatively new along my VBA journey. I have written a few successful scripts so far, but am really struggling with this.

​

Here is a simplified example of my problem:

​

I need it so that each of my sheets has a unique value for column C. However, I don't want to delete extras, I want to keep them, copy/paste them over to a new sheet and then hopefully be able to run the macro again, in that sheet, until I have a number of sheets, each with only unique values in column C.

​

So:

​

Sheet 1
 ----------- ------------------------ --------- 
| Name (A)  |         Email  (B)     |Animal(C)|
 ----------- ------------------------ --------- 
| Lauretta  | [email protected]  | Pig     |
| Kanisha   | [email protected]   | Pig     |
| Katelynn  | [email protected]  | Pig     |
| Irwin     | [email protected]| Cat     |
| Renea     | [email protected]| Cat     |
| Antonette | [email protected] | Cat     |
| Leigh     | [email protected]| Donkey  |
| Eloy      | [email protected]| Horse   |
| Jamika    | [email protected]| Horse   |
| Kristian  | [email protected]  | Horse   |
| Elaina    | [email protected]| Spider  |
| Catherina | [email protected] | Spider  |
| Ellamae   | [email protected]   | Spider  |
 ----------- ------------------------ --------- 

would look something like this:

​

Sheet 1

 ----------- ------------------------ --------- 
| Name (A)  |         Email  (B)     |Animal(C)|
 ----------- ------------------------ --------- 
| Lauretta  | [email protected]  | Pig     |
| Irwin     | [email protected]| Cat     |
| Leigh     | [email protected]| Donkey  |
| Eloy      | [email protected]| Horse   |
| Elaina    | [email protected]| Spider  |
 ----------- ------------------------ --------- 

Sheet 2
 ----------- ------------------------ --------- 
| Name (A)  |         Email  (B)     |Animal(C)|
 ----------- ------------------------ --------- 
| Kanisha   | [email protected]   | Pig     |
| Katelynn  | [email protected]  | Pig     |
| Renea     | [email protected]| Cat     |
| Antonette | [email protected] | Cat     |
| Jamika    | [email protected]| Horse   |
| Kristian  | [email protected]  | Horse   |
| Catherina | [email protected] | Spider  |
| Ellamae   | [email protected]   | Spider  |
 ----------- ------------------------ --------- 

at which point I could hopefully then run the same macro on `Sheet 2`, thus generating:

​

Sheet 2
 ----------- ------------------------ --------- 
| Name (A)  |         Email  (B)     |Animal(C)|
 ----------- ------------------------ --------- 
| Kanisha   | [email protected]   | Pig     |
| Renea     | [email protected]| Cat     |
| Jamika    | [email protected]| Horse   |
| Catherina | [email protected] | Spider  |
 ----------- ------------------------ --------- 

Sheet 3
 ----------- ------------------------ --------- 
| Name (A)  |         Email  (B)     |Animal(C)|
 ----------- ------------------------ --------- 
| Katelynn  | [email protected]  | Pig     |
| Antonette | [email protected] | Cat     |
| Kristian  | [email protected]  | Horse   |
| Ellamae   | [email protected]   | Spider  |
 ----------- ------------------------ --------- 

Hopefully this makes sense. I have spent weeks on it, experimenting with various chimeric abominations I harvested from various places, which don't work :( I really have been trying though! I can post my terrible non-functioning attempts if you like, but they are really nonsensical at this point.

​

Any help at all would be very much appreciated! :)