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?

of the dropdown is from Data validation using the list option, then you can
use the change event for the workbook. I the change event, test if the cell
that triggered the change (target) is the cell with the dropdown. If so,
use the value of that cell to copy the sheet to the appropriate location.

http://www.cpearson.com/excel/events.htm for an overview of events if not
familiar (Chip Pearson's page)

--
Regards,
Tom Ogilvy


wrote in message
ups.com...
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?