Hi all,
I have a master list of market returns based on certain "modes" of the market (numbered 1-14). I would like to create a macro to filter a column to a certain mode in my main data sheet, create a new sheet, and then paste the results into the new sheet. I'm hoping I can then loop through all 14 modes. I am very new to creating macros so I am hoping for a little guidance.
I'm able to do one mode but I have no idea how to loop it through consecutive numbers. Any ideas?
Thanks,
Will
Please post any code you may have tried, along with a sample workbook. This will drastically speed up the time needed to create a solution
never stop learning. or milk
the paperclip icon does not work to attach files - instead, under the reply, click "go advanced" and then upload a file from there
Thanks so much for the reply. I'm sure it is going to be difficult to read the code following. Also if I'm too far away I don't mind a response that says so and I'll just stick to the tedious way.
snip.JPG
Last edited by will5will; 07-16-2018 at 05:46 PM. Reason: fixed
Are these ending regions going to be changing? What are the consistent columns you're copying?
Ending regions are always the same. Will be consistently copying columns I J K L M into the new created worksheet for all 14 modes.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks