Hi,

I am looking to copy a range of data and paste it using a button into another range over with one gap between but I also want it to increment week number by 1 each time.
How would I do this with VBA code?

I have the button set up as

Sub AddWeek(control As IRibbonControl)


Book1.xlsm