Is there a way to write a macro that will create new worksheets based on data in a particular cell? Here is my issue specifically: On a "master" worksheet, I have a drop-down menu within a cell that allows the user to select a number from 1-20. After selecting the number 6 (for example), I would like 6 new worksheets to be created, identical to another, separate worksheet. I can try to get more specific, but does anyone have any ideas on how to go about this with the information provided? Disclaimer: I'm new to macros. Thanks to whoever can help.
Bookmarks