Macro extracting data from different sheets within a workbook [Closed]

Report
Posts
1
Registration date
Tuesday April 15, 2014
Status
Member
Last seen
April 15, 2014
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
I need help creating a macro to copy data from multiple sheets within a workbook into one master sheet. I have tried several times and remain unsuccessful.

The workbook has 2 tabs set up with data between columns "A" and "L".

The first tab contains changing customer profile information, data ranges starting from rows 3 down to 250 plus lines, while data in columns A and C thru L will change, column "B" containing the customer identifying number.

The second tab contains a list of products, data in columns "A thru D" starting at rows, 2 thru 82, which at this time data remains stationary.

Is it possible to have a macro that automatically paste 81 products from the "second tab" containing data in columns A thru D to coincide with each customer number listed on "first tab" identified in column "B" all on one "Summary" tab?

The summary tab should list all 81 products changing at each customer number listed on the first tab (data starting and ranging from lines 3 to 250).

Goal:
A B
Customer 1 Product 1
Customer 1 Product 2
Customer 1 Product 3
Customer 1 Product 4

And so on for all 81 products

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
post a small extract of data and THEN explain
you can also send the file thorugy speedysahre.com