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).
Customer 1 Product 1
Customer 1 Product 2
Customer 1 Product 3
Customer 1 Product 4