Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Make it more simple or intuitive to do simple things | Charts and Charting in Excel | |||
simple question, hopefully a simple answer! | Excel Programming |