Skip to Content
0
Former Member
Mar 25, 2009 at 10:54 AM

Combo-Box selection : Data from different sheets !!

30 Views

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...