I have a table of data being populated by vlookup. I would like to be able to change the data in the table based upon some user selector/drop down. I have several named ranges I would like to be able to use here. The named ranges are variable length, and can change contents. I have already built out handling that complexity and having the dynamic named ranges using Offset.
I'd like to be able to make the chart dynamic. I.e user could select List1 from a dropdown perhaps, and the first column of table would be populated by those named fields. then vlookup would handle the rest. I have seen where I can highlight a range and control-shift-enter and apply it as an array, but cant figure out to do automatically once the selection is made. thanks much for your time!
I'd like to be able to make the chart dynamic. I.e user could select List1 from a dropdown perhaps, and the first column of table would be populated by those named fields. then vlookup would handle the rest. I have seen where I can highlight a range and control-shift-enter and apply it as an array, but cant figure out to do automatically once the selection is made. thanks much for your time!