Hi everyone,

Hope you are well!

I am hoping to find some help for my VBA Macro to help me save time!
In my excel, I have a list of clients nb and a list of products.
I must link my clients nb with my products. So that for each products I have a client nb attributed to it into a new column.

Client list is in column A: from Line 10 up to last non empty row.
Product list: from range C10 to I10 (number of lines up to last non empty row)

Here are the instructions for my macro:
USER TASK: 1. paste in column A clients unique nb (from line 10 to ...)
2. paste in column C to I unique data for each products (from line 10 to...)

MACRO:
3. copy the full range of products from C:I,
4. past it range L10 to R
5. add in column S the unique client nb
6. repeat the same until last unique client nb reached.

I hope it's clear, hope you can help!

Thanks a lot,

Kindest,
Florian