show /hide sheets based on listbox selection

[anat]

Hi,

In my application we have implemented total 5 sheets like SheetA,SheetB,SheetC,SheetD,SheetE.

one dim column contain data like (ListBox data )

SheetA

SheetB

SheetC

SheetD

SheetE

my requirement is:

1)in list box if i select SheetA then SheetA tab should be enable.

2)suppose  if i select SheetA and SheetB  then SheetA tab  and SheetB tab should be enable.

3)if i select all values in list box all tabs should be enable.

Regards

..........

[alexandros17 · Accepted solution]

Here is my example

[aveeeeeee7en]

Alessandro Sir Awesome Solution.

[vardhancse]

Hi

In sheet properties-General<tab>->Show Sheet:

We can give the field value and condition

[anat]

@Alessandro Saccone ,

superb Solution.

[#6]

Hi Sasi,

Kindly help me resolve the following query using the SCD solution

Well, I have the following Inline table

LOAD * INLINE

[

    Product, ProdName, Price, Updated

    123, Watch, 150$, 1/1/2015

    134, Fruit, 30$, 1/1/2015

    145, Ring, 3000$, 3/1/2015

    123, Watch, 125$, 5/1/2015

    123, Watch, 119$, 5/5/2015

    134, Fruit , 50$, 5/5/2015

    145, Ring, 2500$, 5/12/2015

    234, Pen, 12$, 5/17/2015

    312, Jeans, 50$, 6/9/2015

];

Using the above input table, I need to get the below reults

Product	ProdName	Price	Updated	From	To Date
123	Watch	150$	1/1/2015	1/1/2015	4/30/2015
123	Watch	125$	5/1/2015	5/1/2015	5/42015
123	Watch	119$	5/5/2015	5/5/2015	6/18/2015

Help me implementing the same.

Thanks in advance

[anat]

123

Watch

119$

5/5/2015

5/5/2015

6/18/2015

here what is the logic for 6/18/2015? how u r populating this record(6/18/2015)?

[#8]

6/18/2015 is nothing but Today's Date

[anat]

@ruchi rathi : may be this link will help you

Creating a Date Interval from a Single Date