LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Creating Workbook Sheets from Dropdown Menu

I need to create a workbook with 30 sheets. At the top of each sheet
there will be a dropdown box with 4 choices representing an existing
excel spreadsheet. Based on the user's selection in the dropdown box,
the existing sheet needs to be copied onto the new workbook sheet.

This new sheet will then be completed and saved in the new workbook
file without updating the fields in the master sheets.

How can I do this?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
select From dropdown and return another dropdown menu RE4379 Excel Discussion (Misc queries) 2 March 11th 10 03:09 PM
filter dropdown menu so 2nd drop menu is customized menugal Excel Worksheet Functions 1 September 4th 07 05:25 PM
how do i populate a dropdown menu from another tab in my workbook Shaun Excel Discussion (Misc queries) 2 November 16th 06 10:38 PM
Creating Menu to open workbook kwatch Excel Worksheet Functions 1 April 14th 05 06:54 PM
Create a menu of sheets in a shared workbook RichieRich Excel Programming 3 March 16th 05 09:30 PM


All times are GMT +1. The time now is 02:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"