greetings and good morning all, i'm in the process of trying to create a macro where I have multiple worksheets and would need to have the macro setup where when it runs, it automatically goes to the newest created worksheet name then does it's thing (which is update and revise a few pivot tables). for example, in VBA under the VBAProject window pane, theres 15 sheets, (Sheet1, Sheet2.....Sheet15). if i'm on Sheet1 and want the macro to go straight to the latest/newly created sheet name, sheet 15 in this case. later when I create a new sheet name, sheet 16 then the macro would automatically go there if its in a different sheet name. thanks in advance!
Bookmarks