VBA Help

[busman]

In sheet 1, named, “weekly” input cells are ( C6:w11). Totals cells are ( C14:w15 )
Am, trying to copy and save, ( c14:w15) into same cells in sheet 2 named “income”.
Easy ,but I need sheet 2 to fill down to next empty cells ,and then clear input cells C6:w11.


Any help would be appreciated
busman

 

[Sifou]

The following line should be able to help you out, however as I don't know much about your workbook i had to code with the given details, in a static way. also if you run your macro more than once the total will be added as many times as the macro is ran (it's possible to check if the rows already exist by comparing values if they don't change).

Worksheets("weekly").Range("C14:W15").Copy Destination:=Worksheets("income").Range("C1").End(xlDown).Offset(1, 0)

I hope that helped.