Drop Down Menu inserts Tables

Copper Contributor

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?

2 Replies
best response confirmed by Hans Vogelaar (MVP)

@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. 

Screenshot 2023-09-01 at 07.29.34.png




See attached.

That is exactly what I want to do