Populate list from single click, add to list from additional clicks.

Alright, this may be difficult, I'm not sure but I need some help. One sheet 1 I have product. On sheet 2 I would like to be able to populate components from products on list.


So it would work like this.

click [pog machine] on page one

page two lists components

1 pog
1 rog
1 nog

click [rog machine] on page one

page two adds components

1 pog
2 rog
2 nogs
1 flog


Is this possible with excel? I've been trying to figure it out for a while and I'm at a loss.

This can be done with Button Macros on the Developer tab.

pogmachine.xlsm