I am quite new in VBA and you probably solved several times this thing.

I want to copy in a new sheet, each row based on the number of cell values, along with my header which is in my first row.

So to give you a brief of my data :
I have headers in my first row.
Column A, B, C have string texts
Column D has a number.

I want this number to be the times we copy the rows in the new sheet.

help please?