asked on

Excel: Dynamically changing drop down items AND data for the items.

Experts:

I asked a previous question. Was answered completely... this is a followup. You may want to refer to below, and the solution.

https://www.experts-exchange.com/questions/28008108/Excel-Dynamically-changing-list-boxes.html

Additional question:

I would now like to have the data in columns g thru k also move when the dropdown item list changes.

Please see attached Excel file for example of what I need. Please see code behind the "data" tab for what is working currently... Code was very kindly provided by ssaqibh!

thanks in advance.

Rick D Norris
DropDownExample---New.xls

ASKER CERTIFIED SOLUTION

Saqib Husain

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Saqib Husain

This will work if there are no gaps in the data

and

the heights of all columns are the same

Rick Norris

ASKER

ssaqibh:

‘Dwarfs standing on the shoulders of giants see farther ahead than the giants.’ Pascal

I am a dwarf, but with your help, my software project has been enhanced well beyond what I was capable

My example did not take into account the very HIGH probability of "gaps".... concerning heights...... Not sure if I understand???

Because the constraint you mentioned in your solution would not work in what I want as an end product, I am posting another follow-up question. I have included an example that is a sampling of data that is representative of what I will be importing into my software.

https://www.experts-exchange.com/questions/28009826/Excel-Dynamically-changing-column-data.html

You continued participation is very much appreciated.

Thanks again,
Rick Norris