Inserting a new Worksheet Using Macros

[Birdy92]

What I have is a worksheet where its name is never the same. IE, the original sheet is named A.

What I know how to do is make sheet A copy itself and make sheet B (I know it would be A(2) but I can rename it to B).

Now, using the same macro, from sheet B I am looking for sheet B to copy itself and make sheet C (or B(2) that can be renamed to sheet C).

I hope this is not clear as mud, any help you can give would be very helpful.

Bill

 

[Juan Pablo González]

How is the macro originally called ? and when is that copying supposed to happen ?

 

[Birdy92]

What I have now is in this form:

Sheets("2003 Sales").Select
Sheets("2003 Sales").Copy After:=Sheet(1)

What I am doing is renaming Sheet(1) to January Sales

What I would like, if it can be done, is at the end of Feburary run a macro that would create a Feburary Sales sheet(from the previous month sheet, in this case Jan), and do the same for the rest of the year, but using the same exact marco to create every new sheet.

The reason for running the macro is that all of the sales figures are updated via a pivot table and not inputed by hand, and I am also trying to keep a running tally for the year, but shows the YTD info for that period (ie. it copies/paste values Grand Total (2003+Jan) onto another line and adds Feb to to give a new Grand Total...March would be Grand Total (2003+Jan+Feb) to a new line plus March Sales for a new Grand total, so on and so forth).

Now, I hope that I haven't made too much mud

Bill

 

[Birdy92]

Looking thru the boards I found something that is very close to what I am looking to do. What was posted by TommyGun was this:

Sub CopyValues()
ActiveSheet.Copy
ActiveSheet.UsedRange = Active Sheet.UsedRange.Value
End Sub

The one thing that I want to do is instead of this going into a new book I want it to stay in the same book that I am working in as a new sheet.

Please tell me there is a way to make this happen

Bill