leeksleeks
Board Regular
- Joined
- Oct 31, 2013
- Messages
- 96
Hi,
I am looking for a macro to delete all duplicates from every worksheet. I have a results based worksheet that copies results into the worksheet with the same name as the home team but it duplicates results from the season, so I have to go into each worksheet and manually select all data and then run the Remove all duplicates function. I would like to be able to run a macro that does this from all worksheets in one go if possible.
Cheers
I am looking for a macro to delete all duplicates from every worksheet. I have a results based worksheet that copies results into the worksheet with the same name as the home team but it duplicates results from the season, so I have to go into each worksheet and manually select all data and then run the Remove all duplicates function. I would like to be able to run a macro that does this from all worksheets in one go if possible.
Cheers
