Macro extracting data from different sheets within a workbook

Closed
ESal Posts 1 Registration date Tuesday April 15, 2014 Status Member Last seen April 15, 2014 - Apr 15, 2014 at 03:19 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Apr 16, 2014 at 01:28 AM
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
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Apr 16, 2014 at 01:28 AM
post a small extract of data and THEN explain
you can also send the file thorugy speedysahre.com
0