Multi-combo-boxes--->single value component

[Former Member]

Hi Friends

I am having a requirement like below

say I have two teams

   1)TEAM-A
    ----------
    player-1
    player-2

   2)TEAM-B
  ------------
   player-1
   player-2
-------------

and I have to capture total runs scored by each of the player in
both the teams A and B

I have taken 2 combo boxes for two teams i.e TEAM-A,TEAM-B
I have taken 1 value box for runs scored...

if i select Team--A players i am getting data in value box
if i select Team--B player hw shd i use the same value compoent
and display data

Thx
babu

[Former Member · Accepted solution]

Hii Bose ,

Use Two Combo Box and use Insertion Type as  " Labels " and Set Destination of Both

Combo Box as same i.e cell A1 hence if you select Combox 1 value as Player 1 then value

displayed is " Player 1 " and then if after that you select Player 2 in Combo Box 2 then previous value will be overlapped or overwritten by latest one and now it will display " Player 2 " .

Hope this will be helpful .

Regards

Jeetan

[Former Member]

Hi Jeetan It's pulling data based on dynamic selection as sugegsted.Thank you

Rupali/Ram-Thank for your inputs too as I cud have implemeted yours if data format is similat to yours

--Any how many many thanks for your time.& suggestions.friends

--------

bose

[Former Member]

Hi,

I have filtered  Team(Combobox1) and  filter Players(Combobox2).  

Team A having Player-1, Player-2,   Team B having Player-3 , Player – 4.

Please find the Mapping with Comboboxes and Labels:-

Combobox1:-

Combobox2:-  For   PLAYERS Filtering and Mapping in the Excel Sheet

Label (Team Total Score) :- It shows sum of the score by each team.

Label 3( Individual Player Total Score):-

FINAL OUTPUT (TEAM A TOTAL):-

OUTPUT(TEAM B TOTAL ):-

[former_member190855]

Hi

Do you need to filter by team or by player? If by player, this is what you need to do.

Sample data

ComboBox1 - Team filter mapping

ComboBox2 - Player Filter mapping

Value mapped to player's destination cell

Doe this help?

Runali

[juan_escalante]

Babu,

          Maybe you have to check the insert positions of the combo boxes, if the value box is dependet of both combo boxes the last insert is the one it will show.

Best Regards,

Juan