Hi

I don't know a lot about vba except what I see in macros.

What I want to do is the following...

I have an accounts spreadsheet.

In column d in Januarys sheet I have totals (which are formulas)
I need to copy the entire sheet and paste the values from column d in
January into column b for next month as brought forward values fo and so on.
I can do the copy paste values bit using a macro.

What I want to do that I can't do with a macro is be able to say 'copy the
active sheet and move to end', so that if I am on Aprils sheet I click a
button and it creates a new sheet that I can then manually rename as May. It
contains the brought forward figures from the previous month.

I only need the code for the copy active sheet and move to end bit - can
anyone help?

Thanks

Anita