Advanced Drop Down Menu formatting

[mxdclt]

I will preempt this thread with the knowledge that this may not be possible but I thought I would ask and see.

I would like to have a drop down menu and based upon which selection you choose a large area of the worksheet will change formats depending on which selection you choose.

For example: If you choose #1 then the area below it will have four line items to total up costs. Or you could choose #2 to have one line item summary cost. Or you could choose #3 and have 15 lines for in depth cost breakdowns.

If anyone has any suggestions on how to do this or even a direction to start in I would really appreciate it.
Thanks.

[Leith Ross]

Hello mxdclt ,

Welcome to the Forum!

To provide you with accurate suggestions and possible solutions, you should post the workbook and include before and after examples of the data.

To Attach a File:

1. Scroll down to the window below your post Additional Options
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[mxdclt]

Thanks for the advice, once I get all the formatting complete for what I need I will upload it. Thanks again for the help.