Help - I'm sure it must be simple
 

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

Help - I'm sure it must be simple
 

ActiveSheet.Copy after:=Worksheets(Worksheets.Count)
ActiveSheet.Name = "May"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anita" wrote in message
...
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

Help - I'm sure it must be simple
 

Thanks.

How do you 'say' - select the active sheet?

"Bob Phillips" wrote:

ActiveSheet.Copy after:=Worksheets(Worksheets.Count)
ActiveSheet.Name = "May"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anita" wrote in message
...
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

Help - I'm sure it must be simple
 

You don't, it is already selected, otherwise it isn't the active sheet.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anita" wrote in message
...
Thanks.

How do you 'say' - select the active sheet?

"Bob Phillips" wrote:

ActiveSheet.Copy after:=Worksheets(Worksheets.Count)
ActiveSheet.Name = "May"

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anita" wrote in message
...
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