Welcome Sharath.
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like
Thanks Ashish,
This is exactly what I wanted!
Regards,
Sharath
On Thu, Nov 13, 2014 at 7:26 PM, Ashish Kumar
wrote:
> Hi Sharath,
>
> PFA..!
>
>
> Change your data in A1. If you select Global in A1 then drop down list
> will show in B1 and If you select Local in A1 then drop down list will
Hi Sharath,
PFA..!
Change your data in A1. If you select Global in A1 then drop down list will
show in B1 and If you select Local in A1 then drop down list will be
deleted in B1. you are able to write anything in B1
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
Hi Ashish,
I am sorry I was not clear in my email.
Let me clarify.
Cell A1 has a drop down list ("Global", "Local")
If someone selects "Global", Cell B1 should show a drop-down list which is
coming through a named range. I have that assigned.
But, if the user selects "Local", the Cell B1 shoul
