Hi All,
Hope you can help
In worksheet A I have a master list ie 26 rows, col A has a unique product code which is variable on amount of rows.
In worksheet B I have hundreds of rows of data, variable amount or rows for each unique product code in Col A.
What I wish to do is copy row 1 from WS A (first product code in to a new worksheet and then below it copy all rows from WS B and the loop through this process for all other product codes in WS A.
Hope this is clear, I have never done looping and my code otherwise is going to be huge!
Many thanks appreciate your help and time
Hope you can help
In worksheet A I have a master list ie 26 rows, col A has a unique product code which is variable on amount of rows.
In worksheet B I have hundreds of rows of data, variable amount or rows for each unique product code in Col A.
What I wish to do is copy row 1 from WS A (first product code in to a new worksheet and then below it copy all rows from WS B and the loop through this process for all other product codes in WS A.
Hope this is clear, I have never done looping and my code otherwise is going to be huge!
Many thanks appreciate your help and time
