PDA

View Full Version : Iterate 2 dropdown lists and move to all the new tabs to new workbook



zhengzhi8806
01-24-2018, 08:34 AM
21445

I have been trying to do the macro and codes for past 2 days. No luck. Appriciated if anyone can help me. :crying:

The basic task is on "Exclusive PN" tab, cell B3 and B4 is 2 dropdown list.

1. choose the first in the first choice dropdown and first choice in the second dropdown list
2. move and copy the tab to a new workbook
3. copy and paste the whole tab
4. rename the tab as first choice in the first dropdown + first choice in the second dropdown list

repeat the above process
1. stay with the first choice in the first dropdown list and choose the second choice in the second dropdown list
2. move and copy the tab to the same workbook as the above process
3.copy and paste the whole tab
4. rename the tab as first choice in the first dropdown + second choice in the second dropdown list

repeat the same process as all the dropdown choices are chosen. in total i should get 9 tabs for the new workbook.

Thanks everyone!