| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use a macro to create new sheets
I have a workbook with two sheets. The first sheet has a list of about
20 items and a dialog box adjacent to them that enables the user to select the item. The second sheet is a basic form template. What I want to do is create a macro that looks at which dialog boxes are selected and then creates copies of the second sheet for each item selected and have the sheets named according to the item name. Anyone know if this is possible or how to accomplish this? Any help would be greatly appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a macro to create excel line graph with coloured pointers anddata lables | Charts and Charting in Excel | |||
| Macro to create new workbook and sheets | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| Create New Workbook - Name book - 4 Sheets - Name Sheets | Excel Programming | |||
| have Macro automatically delete and create sheets | Excel Programming | |||
Threaded Mode
