Here is a macro I'm currently running in a workbook to organize and copy things as needed. The basic idea is that I enter data in the sheet Master, then it gets organized first by number, then date (some items were made before we started assigning numbers, but have dates). After that, it goes through column F and, if a row contains term A, the row is copied to sheet A, term B goes to sheet B, etc, and deletes column F. Finally, it goes through and removes duplicates from each sheet. While it doesn't take too long, only about 10 seconds to analyze near 60 lines in Master, is there a way to make it faster and a little less clunky? Forgive me if it is avoidably clunky, I knew basically nothing about macros until yesterday :P
Short outline of code for those who don't want to follow the link:
'Then it closes out
Bookmarks