Hello,

First of all, this forum rocks ! Thanks a lot to the community.

I have an issue with a macro I am trying to create. Enclosed is the file I am working on.

- The sheet "WIN" is where I enter my data
- Those data are compiled in the table from line A59 until N59

--> When I click on the button "Add" (in the same sheet), I would like my macro to do 2 things:

1) Copy & paste all the data from A59 until N60 in the sheet "OFFER", just under the line where "-" is. The tricky thing is that I have to create various lines in the sheet "OFFER" with different data, coming always from the sheet "WIN" (cells from A59 to N60). Therefore I want my macro to understand that every time I click the "Add" button, it has to copy / paste the lines in the "OFFER" sheet under the last line containing "-".

2) Duplicate the sheet "WIN" in the same workbook with the name "WIN1", "WIN2", WIN3", etc. each time I click again on "Add"

Thanks a lot for the help !

Offer1.xlsm