I have a large macro that calls about 8 macros. I have it that way because I had to create it one step at a time and I am not good enough to do it in one go. It is ugly, but it works. My only issue really is that now my PERSONAL.XLSB has 8 macros listed in it that really belong to one. So by doing it this way my PERSONAL.XLSB has doubled its list length and makes it harder to find the correct macro.
Most of the macros are just creating separate pivot tables, but due to the number of items that are excluded, the macro is long. Due to the length, I will have to do more than one post with the code i guess. I will also attached the macro.
Basically, all I am looking for is to make this one large macro, or at least appear under PERSONAL.XLSB as one, but I doubt simply removing the SUB/END SUB would accomplish that lol
Bookmarks