BigBill7
02-09-2021, 09:26 AM
Hello My Name is Billy I am currently working on a Macro for my company. I am relatively new to Macros and only really understand the basics. I am trying to make a simple Macro to filter down a set of data and then take that set of data and put it in a separate tab which I then rename the tab.
:banghead:
I have created the Macro by recording my-self doing all the actions and got the Macro to work. However I need to create some lines of code that will be able to make a variable list of what the new tab names may be once created initially created so the Macro doesn't only look for one tab name (EXP: in my macro "Sheet1", may be created as "Sheet2", "Sheet3"ext)
I have inserted a copy of the data I am only filtering column N so I took out all other data, The Macro should work on this file I tested before uploading, but I need some extra code that I'm not sure how to create yet.
If the initial tab is not named "Master" or subsequent tabs are not named "Sheet1", "Sheet2", "Sheet3", "Sheet4" in that order I get a debug error
My expected outcome would be what this macro achieves if nothing is off which is 3 separate tabs "0 to 100", "101 to 1000", "1001 to 3000" which the info from column N in it (See capture1 and 2 for what it should look like)
Thanks to anyone that can help!
:banghead:
I have created the Macro by recording my-self doing all the actions and got the Macro to work. However I need to create some lines of code that will be able to make a variable list of what the new tab names may be once created initially created so the Macro doesn't only look for one tab name (EXP: in my macro "Sheet1", may be created as "Sheet2", "Sheet3"ext)
I have inserted a copy of the data I am only filtering column N so I took out all other data, The Macro should work on this file I tested before uploading, but I need some extra code that I'm not sure how to create yet.
If the initial tab is not named "Master" or subsequent tabs are not named "Sheet1", "Sheet2", "Sheet3", "Sheet4" in that order I get a debug error
My expected outcome would be what this macro achieves if nothing is off which is 3 separate tabs "0 to 100", "101 to 1000", "1001 to 3000" which the info from column N in it (See capture1 and 2 for what it should look like)
Thanks to anyone that can help!