Hello,
I copied a macro that was posted on here that would allow me to click a command button. In Column B, there will be a list of categories each with a sheet of the same name. When you click the command button it will automatically copy and paste each row with that contains the specific category. For instance, for every row that contains the category "Alumni" it will copy the data into the "Alumni" sheet.
My problem is that when I click the button a second time, it re-copies ALL the data, leading to duplicates in each worksheet. I'm going to be constantly updating the master sheet, so I don't want to have to go through each worksheet to delete duplicates every time I click the command button. The code I have is:
Bookmarks