MossyPants
New Member
- Joined
- May 21, 2022
- Messages
- 23
- Office Version
- 365
- Platform
- Windows
Hi all, just starting out with VBA and I'm having trouble piecing this one together.
I have a worksheet called "chooser" that contains 4 drop-down lists in cells A1-A4. The drop-down lists contain numbers 0-10.
I would like to duplicate some hidden worksheets (named "apples", "oranges", etc) based on the selection in the drop-down list in "chooser".
For example, if user selects "3" from drop-down list in A1, I would like to duplicate hidden worksheet called "apples" 3 times and name them "apples1","apples 2", and "apples3".
If user selects "1" from drop-down list in A2, I would like to duplicate worksheet called "oranges" and name it "oranges2".
Hope this question is clear. Any help is greatly appreciated!
I have a worksheet called "chooser" that contains 4 drop-down lists in cells A1-A4. The drop-down lists contain numbers 0-10.
I would like to duplicate some hidden worksheets (named "apples", "oranges", etc) based on the selection in the drop-down list in "chooser".
For example, if user selects "3" from drop-down list in A1, I would like to duplicate hidden worksheet called "apples" 3 times and name them "apples1","apples 2", and "apples3".
If user selects "1" from drop-down list in A2, I would like to duplicate worksheet called "oranges" and name it "oranges2".
Hope this question is clear. Any help is greatly appreciated!