Hi All,
I have a requirement wherin, I have 4 Worksheets in a single excel file with name as Proj1,Proj2,Proj3 and Proj4 respectively.
I have imported it into Xcelsius.
Row Name and Column Name are same in all 4 Worksheets with different values.
I have created a Combo-Box wherein I can select 1 value at a time.
My requirement is if I select say Proj1 in Combo-Box......data shud be fetched from sheet1..if I select Proj2 in Combo-Box......data shud be fetched from sheet2..and so on...
I am displaying data in form of Charts...
I dont want to consolidate data into one sheet..
Please help...how do I switch between different sheets for selected values in combo-Box..
Or shall I opt for some other UI element other than Combo-Box.
Thanks...