Copy Paste named ranges based on dropdown list

[krish182]

Hi,

I have a report to be populated based on selection from dropdown list. I have created named ranges in the Directory sheet and report sheet is to be populated based on selection.

Kindly help.Have created named ranges through macro,(but not in this workbook )but unable to use the ranges to populate automatically based on dropdown list selection .
Attached sheet,
Thanks in advance

Mod Edit: crosspost: https://www.ozgrid.com/forum/index....py-paste-named-ranges-based-on-dropdown-list/

 

[krish182]

I meant to say that Column A(for which its written dynamic range---not named though in the sheet) has currently values P,Q,R,S,T and may go further ahead also to U,V etc.,Means its number of values will vary .So the named ranges that will be copied below that should calculate last used row and then paste the ranges(AA1234 or BB 1234 or CC1234 etc).
If C is detected named ranges CC and for D its DD(already named) should be called and pasted from C18 (tentatively).Just calling them based in dropdown result is what I need.

Have put comments in the Report sheet.


Thanks for the reply and your time,



Cross Post: https://www.excelforum.com/excel-pr...anges-based-on-dropdown-list.html#post5314456

 

[Marc L]

Krish182, as you commited wild cross-posting, you must post a link for each thread created on others forums​

according to forums rules :​

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

 

[krish182]

Krish182, as you commited wild cross-posting, you must post a link for each thread created on others forums​

according to forums rules :​

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

Posted the links. Apologies.

 

[krish182]

Query has been solved at : https://www.ozgrid.com/forum/index....py-paste-named-ranges-based-on-dropdown-list/ .
Thanks

 

[vletm]

krish182
Your given link works ... if and if and if ... eg for me, it won't work smoothly
Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.