I am looking for help from exports.
In attached sample sheet, F3 is the result cell. When "select" button next to the cell is activated I want this result value copied to selection list cell E7 (paste special).
Continuing with next result F3, and "selected" I need this new result copied to next column on selection list E8 and so on. How do I do this?
Next task is to remove any selected items (that were copied from various results) when "remove" button is activated and below items should move up to fill the blank cell.
F G
<1> choose--> Category A
<2> choose--> Size S
<3> result--> Model A-S select button
Selected Model (from f3 result. whenver G3 is selected new result copied to below list)
<7> Cell E7 (f3 copy here) remove button
<8> Cell E8 (f3 copy here) remove button
<9> Cell E9 (f3 copy here)
<10> Cell E10 (f3 copy here)
Looking forward to experts guide.
Thank you in advance.
Bookmarks