Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
..........
Here is my example
Here is my example
Alessandro Sir Awesome Solution.
Hi
In sheet properties-General<tab>->Show Sheet:
We can give the field value and condition
superb Solution.
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
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)?
6/18/2015 is nothing but Today's Date
@ruchi rathi : may be this link will help you