i have a data set where column H ("inventory") has various inventory numbers stored as text (001, 009, 010, 037, etc.) ...tab is called "data"
i have an advanced filter set up in tab "filters":
"inventory"
037
047
084
i also have three separate tabs named 037, 047, 084
trying to make a macro where it'll loop through the advanced filter setup and copy and paste the data to their respective tabs
e.g.,
loop advanced filter --> first one is 037 --> filter column H ("inventory") in the "data" tab for 037 --> then copy and paste to tab 037
next one is 047 --> filter column H ("inventory") in the "data" tab for 047 --> then copy and paste to tab 047
next one is 084 --> filter column H ("inventory") in the "data" tab for 084 --> then copy and paste to tab 0484
i have an advanced filter set up in tab "filters":
"inventory"
037
047
084
i also have three separate tabs named 037, 047, 084
trying to make a macro where it'll loop through the advanced filter setup and copy and paste the data to their respective tabs
e.g.,
loop advanced filter --> first one is 037 --> filter column H ("inventory") in the "data" tab for 037 --> then copy and paste to tab 037
next one is 047 --> filter column H ("inventory") in the "data" tab for 047 --> then copy and paste to tab 047
next one is 084 --> filter column H ("inventory") in the "data" tab for 084 --> then copy and paste to tab 0484