filter loop

[daveyc18]

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

 

[mumps]

It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

 

[Joe4]

Are you using Excel 365 for this (you have both 365 and 2010 listed)?

If so, you can simply use the new FILTER function.
See here for more details and examples on how to use it: FILTER function - Microsoft Support