cconnor970
New Member
- Joined
- May 28, 2015
- Messages
- 3
What I am trying to do is use a drop list, and based on the selection, one of 4 named ranges will be inserted into an area on the spreadsheet. I am using a combo box, all is working fine there, but based the selection, I have 4 separate named ranges I want to then fill a space on a sheet (sales quote) with the specific named range tied to the specific selection.
I've tried to find a way to insert a range, no go, tried to have the range change color based on the one cells specific value, nope. Ideas?
I've tried to find a way to insert a range, no go, tried to have the range change color based on the one cells specific value, nope. Ideas?