Hi Kaushik03,
Yes i mean instead of range I would like to have visible just A1 & A3 rest to be hidded, When another value is selected (ES for example) to have A2 & A4 visible and the rest hidded.
Perfect, works great. One more question :) if I want to apply this to certain cells what do I use instead of Range? If I want to display just A3 and A5 ?
HI, Many thanks for your reply and welcome words.
However, as you can imagine for noobs its not working :)
So G1 is a drop-down list with 3 values (blank,GB,ES).
Cells A1 ="1",A2="2"...A5="5". Whenever G1 = GB cells A1,A2 & A3 to remain visible and A4 &A5 to be hiddedn.
When G1 is = to ES...
Hi guyz,
I need help with the following :
I am creating an excel template and I want to develope the excel customer for each country. For example if the user select coutry GB i would like some cells to be visible such as (A1, A2, A3). If the country selected is ES then I would like to have...