Marvinexcel
New Member
- Joined
- Oct 14, 2016
- Messages
- 16
Good Day Excel MVPs and Experts.
Please advise.
I want to automatically populate in any order the results in Table 1 based on data inputs table.
I also want to have a button to click for the results in table 1 to "repopulate" again and again.
Can anybody help me?
Thanks in advance.
[TABLE="class: outer_border, width: 416"]
<colgroup><col><col span="3"><col><col></colgroup><tbody>[TR]
[TD="colspan: 6, align: center"]DATA INPUTS:[/TD]
[/TR]
[TR]
[TD]apple[/TD]
[TD]2[/TD]
[TD]pear[/TD]
[TD]2[/TD]
[TD]orange[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]turnips[/TD]
[TD]2[/TD]
[TD]grapes[/TD]
[TD]1[/TD]
[TD]berry[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]papaya[/TD]
[TD]1[/TD]
[TD]avocado[/TD]
[TD]1[/TD]
[TD]pomegranate[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]lemon[/TD]
[TD]1[/TD]
[TD]mango[/TD]
[TD]2[/TD]
[TD]kiwi[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]pineapple[/TD]
[TD]3[/TD]
[TD]starapple[/TD]
[TD]2[/TD]
[TD]soursop[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: outer_border, width: 454"]
<colgroup><col><col span="2"><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD="colspan: 6, align: center"]Table 1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]apple[/TD]
[TD]pear[/TD]
[TD]apple[/TD]
[TD] [/TD]
[TD]pear[/TD]
[TD]orange[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD]turnips[/TD]
[TD]turnips[/TD]
[TD]grapes[/TD]
[TD]berry[/TD]
[TD]berry[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD]papaya[/TD]
[TD] [/TD]
[TD]avocado[/TD]
[TD] [/TD]
[TD]pomegranate[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]kiwi[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]mango[/TD]
[TD]mango[/TD]
[TD]lemon[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]pineapple[/TD]
[TD]pineapple[/TD]
[TD]soursop[/TD]
[TD]pineapple[/TD]
[TD]starapple[/TD]
[TD]starapple[/TD]
[/TR]
</tbody>[/TABLE]
Please advise.
I want to automatically populate in any order the results in Table 1 based on data inputs table.
I also want to have a button to click for the results in table 1 to "repopulate" again and again.
Can anybody help me?
Thanks in advance.
[TABLE="class: outer_border, width: 416"]
<colgroup><col><col span="3"><col><col></colgroup><tbody>[TR]
[TD="colspan: 6, align: center"]DATA INPUTS:[/TD]
[/TR]
[TR]
[TD]apple[/TD]
[TD]2[/TD]
[TD]pear[/TD]
[TD]2[/TD]
[TD]orange[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]turnips[/TD]
[TD]2[/TD]
[TD]grapes[/TD]
[TD]1[/TD]
[TD]berry[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]papaya[/TD]
[TD]1[/TD]
[TD]avocado[/TD]
[TD]1[/TD]
[TD]pomegranate[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]lemon[/TD]
[TD]1[/TD]
[TD]mango[/TD]
[TD]2[/TD]
[TD]kiwi[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]pineapple[/TD]
[TD]3[/TD]
[TD]starapple[/TD]
[TD]2[/TD]
[TD]soursop[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: outer_border, width: 454"]
<colgroup><col><col span="2"><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD="colspan: 6, align: center"]Table 1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]apple[/TD]
[TD]pear[/TD]
[TD]apple[/TD]
[TD] [/TD]
[TD]pear[/TD]
[TD]orange[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD] [/TD]
[TD]turnips[/TD]
[TD]turnips[/TD]
[TD]grapes[/TD]
[TD]berry[/TD]
[TD]berry[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD] [/TD]
[TD]papaya[/TD]
[TD] [/TD]
[TD]avocado[/TD]
[TD] [/TD]
[TD]pomegranate[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]kiwi[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]mango[/TD]
[TD]mango[/TD]
[TD]lemon[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]pineapple[/TD]
[TD]pineapple[/TD]
[TD]soursop[/TD]
[TD]pineapple[/TD]
[TD]starapple[/TD]
[TD]starapple[/TD]
[/TR]
</tbody>[/TABLE]