Copy data from one sheet to a master sheet [Closed]

Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,
I have a worksheet, sheet1 where I enter the product code and it gives me the Bill of Materials for this product.

I would now like to copy the entire Bill of Materials and add it to another worksheet sheet2. When I enter a new product code in the first worksheet, sheet1, I would like the new Bill of Materials to be copied to the next available row in sheet2.

Can you please help as I have a long list of product codes for which copy paste scenario takes a long time

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
792
post a small extract of sheet1

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!