aravindhan_3
03-03-2016, 02:02 AM
Hi,
I have the data in column A - Country & column B the item sold in that country, I want to name the Range of items in column B with the name col A
eg
Country Item
China Clipboards these 2 should be named as China
China Pens
India Binders These 3 should be names as India
India Pencils
India Pens
Malaysia Binders These 4 should be names as malayisa
Malaysia Clipboards
Malaysia Pencils
Malaysia Pens
background:-
I am trying to create a dashboard based on this, if I select a country, the respective items should be in dropdown list in another cell. if this is was less number of rows, I would have created manually & used indirect function in my data validation. the rows are more than 100000, and the data will keep changing..
can anyone help me with the macro to create names automatically?
cross post: http://www.mrexcel.com/forum/excel-questions/925568-naming-column-b-range-based-col-value.html
Thanks for your help
Regards
Arvind
I have the data in column A - Country & column B the item sold in that country, I want to name the Range of items in column B with the name col A
eg
Country Item
China Clipboards these 2 should be named as China
China Pens
India Binders These 3 should be names as India
India Pencils
India Pens
Malaysia Binders These 4 should be names as malayisa
Malaysia Clipboards
Malaysia Pencils
Malaysia Pens
background:-
I am trying to create a dashboard based on this, if I select a country, the respective items should be in dropdown list in another cell. if this is was less number of rows, I would have created manually & used indirect function in my data validation. the rows are more than 100000, and the data will keep changing..
can anyone help me with the macro to create names automatically?
cross post: http://www.mrexcel.com/forum/excel-questions/925568-naming-column-b-range-based-col-value.html
Thanks for your help
Regards
Arvind