Forum Discussion
Drop Down List
Below is a list of items and prices that I would like to fill one cell on a different page.
We will call page 1 "Cart" and Page 2 "Product"
So on Cart cell A1 there is a drop down box that when i click it shows a list of items in chart below but i want it to show the price as well. I already have a table saved in name manager but i will change it if needed.
The end result i am looking for is for the drop down in "Cart" cell A1 to say "Amazon Echo $99.00" all in one cell.
Thanks
| Item | Price | |
| Amazon Echo | $99.00 | |
| Amazon Echo Dot | $49.99 | |
| CO Detector | $70.00 | |
| Deadbolt or Handle Door Lock | $159.99 | |
| Door/Window Contact | $35.00 | |
| Doorbell | $35.00 | |
| Doorbell Camera | $229.99 | |
| Element Thermostat | $149.99 | |
| Flood/Freeze/Heat Sensor | $70.00 | |
| Garage Door Controller | $99.99 |
1 Reply
- You could insert an ActiveX dropdown which uses a two-column range of cells as its listsource.
