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
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
