Rahul14181
New Member
- Joined
- Jul 24, 2017
- Messages
- 6
Hello Everyone,
I need some urgent help regards to the subjected query: "Select Named Range , depend on Cell Value"
I have a searchable drop down at A1 and there is a button.
I have given name to specific range as below:
B5:C30 - Rahul
E5:D30 - Arvind
F5:G30 - Kumar
In drop down we have three name, (Rahul/Arvind/Kumar)... I want when A1 is Rahul and i click on button then B5:C30 get selected and vise versa for arvind and kumar too..
Please help
I need some urgent help regards to the subjected query: "Select Named Range , depend on Cell Value"
I have a searchable drop down at A1 and there is a button.
I have given name to specific range as below:
B5:C30 - Rahul
E5:D30 - Arvind
F5:G30 - Kumar
In drop down we have three name, (Rahul/Arvind/Kumar)... I want when A1 is Rahul and i click on button then B5:C30 get selected and vise versa for arvind and kumar too..
Please help