Dynamic Row / Column change on List Box / Combo

**vt1** · 05-23-2013, 02:16 AM

Hi,

I need to prepare interactive prototype based on attached.
i.e. based on list box value, Column heading and row will change dynamically.

Please can you advice if this achievable?

Thanks

**:) Sixthsense :)** · 05-23-2013, 02:20 AM

Unable to understand your requirement

can you please describe it with expected output for better understanding?

**vt1** · 05-23-2013, 02:26 AM

See attached modified and advice.

**:) Sixthsense :)** · 05-23-2013, 02:36 AM

Refer the below links for detailed instructions:-

http://www.contextures.com/xlDataVal01.html
http://www.contextures.com/xlDataVal02.html
http://www.contextures.com/xlDataVal13.html

**vt1** · 05-23-2013, 05:33 AM

Thanks for response, I can handle the columns dynamically with list value however I need to create additional row at bottom for selection of A1 or A2. Is it possible?

Please comment

**:) Sixthsense :)** · 05-23-2013, 05:44 AM

Please refer the attached file for details.

**vt1** · 05-23-2013, 05:52 AM

Thanks Sixthsense, I am trying to achieve additional row in table and not in list box.

Scenario 1 - User has selected All from List box then it will display 3 rows in the table.
Scenario 2 - User has selected A1 from List box then it will display 4 rows in the table. (previous 3 rows from ALL and additional row applicable for A1 only)
Scenario 3 - User has selected A2 from List box then it will display 4 rows in the table. (previous 3 rows from ALL and additional row applicable for A2 only)

Please comment.