**SOS**Condense many rows with dropdown for unique attribute/copy data to another sheet when value entered into column "B"

mjaeger1

New Member
Joined
Jul 1, 2018
Messages
9
Hi Everyone,

Please see DropBox Link at very end

Thank you for your help on previous posts. It helped me out of a jam.

I have a worksheet with multiple tabs, separating each product set in a unique tab. I basically put our product catalog into an easily searchable excel document.

Most of the variations on each tab are different color variations of the same product with the same base description.

1) I would like to condense all rows on each with a common description into one row with a drop down box for color selection. Once that selection is made, the other info/columns will be pulled along with it, showing all data in that row for the product selected.

2) Once a selection is made, and a quantity is entered into column C, i would like a button to copy and paste the data into a separate tab called "BOM".

3) a way to choose another product and do it all over again for any product needed


THANK YOU ALL for your help. This has been driving me crazy this entire quarantine :)

DropBox Link

1586183933915.png
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Watch MrExcel Video

Forum statistics

Threads
1,113,890
Messages
5,544,878
Members
410,643
Latest member
sng
Top