Macro/Code to duplicate a range of formatted cells based on data

[nico67]

Hi,

I need help to figure out the following:

In the attached example, first tab contains a range of formatted cells which I need to fill with the data from the second tab.

It will be perfect when adding a row of data in sheet 2 a new box with the formatted cells gets populated down in sheet 1.

My sample shows 2 lines of rows already populated but not the 3rd. I would like to avoid copy and paste the formatted cells as I don't know how many rows of data sheet 2 will contain.

Is it possible to do that, if yes could you please help me?

Thanks very much!