Thanks for reading this...
I am working on a macro that:
-Copies to another sheet the values that do not occur 31 times in a particular column.
-Deletes all of the original values (and corresponding rows) for those values that got copied.
-Repeat the above for one more sheet of data
So basically, if the values in col B don't occur 31 times each, copy that value to another sheet and then delete its row from the original sheet.
See example:
Copy and delete example.xlsx
I tried using two different macros, one for creating the list of values that don't occur 31 times, and one for deleting the rows. Neither are working.
Any suggestions?
Bookmarks