Macro adding 4 extra rows for each value of a specific table

Dears,

I am not very skilled in designing VBA macro's and I hope you could help me,

I have put you a draft of what I am looking for in attached,

I was looking for a macro, copying independantly all Product references from sheet "SKU list" A5:A91 and also all description B5:B91,
And pasting it into sheet "overview a part from A3,

For each copy paste I would like the macro to provide for each reference a total of 5 rows with the texts contained in sheet SKU list G4:G8, and copy it in sheet overview in column C,

I have put you an example in attached with some comment, hope it will be clearer,

I also would like that the macro just have an effect/impact on the 3 first columns, and that it is dynamic according to the #references I could have in Sku list sheet in column A/B

Thanks so much in advance for your help guys ..

Regards,

Hi Dougman,

Thank you for your help on this and your quick answer,

When i am trying to thrigger the macro, i am receiving the following error : "Compile errror : Expected end sub"

Here-below the code I pasted :

Please Login or Register  to view this content.

Thanks in advance for your help,

Regards,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Thanks!