Hello all,
I'm very new to macros in excel. I have a spreadsheet where I am tracking user issues of a software that our office uses. Each issue is assigned to a category. I currently have a macro in the worksheet that will sort the data into tabs based on category. So, "Major Program Change" "Minor Program Change" etc. all have their own tab and there is a tab labeled "All submissions" that has a running log of every issue ever submitted (this is where the sorting macro lives). Each issue is assigned a status (i.e. completed, new, in progress etc.) and the status is maintained in the "All Submissions" tab and pulled to the other tabs when I run the macro. Each tab has a macro that allows me to move the issues up and down to prioritize them. Here's my issue. The macro sorts the data into the tabs just fine and all the data carries over, I am then able to prioritize them and put them in order but if I add any new issues to the the "All submissions" tab, assign their status and then click the button to sort into tabs based on category, it overwrites all the data I have in the tabs already and I have to prioritize from scratch.
So essentially, data that has already been sorted and prioritized I want to remain and I only want new issues that are put into the "All Submissions" tab to be sorted and I want them to be at the bottom and then moved up or down based on priority. I hope what I'm asking makes sense. I've included the current "sorting" macro that I have in the workbook below for your reference. I have also attached the workbook with personal details omitted to give a better visual of what I'm talking about.
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. Also, you should indent your code to make it easier to see the logic structure. --6StringJazzerPlease Login or Register to view this content.
Thanks for the help!
Bookmarks