Forum Discussion
Drop Down Menu inserts Tables
I am in sales and I have a standard one page letter on one sheet or an excel document to send to clients. I created tables for each possible combination of sale that I do. Is there a way to use a drop down menu to select one of the tables from sheet 2? Do I name each table somehow?
bprice89 Assuming (and hoping) you have Excel365 or 2021, I created a mock-up based on your description. Perhaps it will help you on your way. If not, please share a file (anonymised) via Onedrive or similar and paste the link to access the file here.
See attached.
bprice89 Assuming (and hoping) you have Excel365 or 2021, I created a mock-up based on your description. Perhaps it will help you on your way. If not, please share a file (anonymised) via Onedrive or similar and paste the link to access the file here.
See attached.
- That is exactly what I want to do
