Hi,
Thought I'd join this forum today to hopefully get some answers to what could be a simple problem that I have been battling with for the last couple of days.
Here is the scenario. I have a worksheet called mixes with about 6 rows and 23 columns with a header row. One unique record per row.
I then created a dynamic range and gave it a name, mixesDynamic. If I add more records the range expands as it should. That part looks great.
Then on another worksheet! the main page I want to add a drop down list to grab the first column from mixesDynamic, which is the mix name. Then when I click on a particular name I need it to populate 23 cells which are not in a single row or column they are in different positions on the page.
I've been pulling my hair out with this one and I've searched the net and watch loads of YouTube vids but can't quite find what I need. So I thought I'd try here.
Many thanks in advance.
Cheers Rob.
Bookmarks