Create a new sheet from an existing sheet

[rcorona106]

I have a workbook with 2 sheets. One is my data sheet that holds the current
month's activity. The other ("monthly") sheet pulls the information from the
data sheet and shows the data in an income statement type format. I am
writing one macro that will:

1. make a copy of the monthly sheet (this newly created sheet will be
referred to as the second monthly sheet)
2. go back to the first monthly sheet and remove the formulas retrieving
the data from the data sheet

After I update the data in the data sheet, a new macro will go to the second
monthly sheet and display the current month's data in one column and in
another column add the current month's data to the ending balance of the
first monthly sheet.

I have step 1 of the first macro working but am stuck when I try to make it
go back to the first monthly sheet. I think I can figure out the rest or at
least I'm hoping so. All help is greatly appreciated. Thanks.

 

[Skinman]

To make an exact copy of your monthly sheet, select format, organize sheets,
move or copy sheets, and at the bottom of the dialog box check create copy
and where you want it.
rRename it and it will give you all the same macros and names that your
first sheet had. To run a macro on another sheet you have to refer to the
sheet by name or position.
After your Sub statement() in your module Enter :-
Sheets("Monthly").Select Or whatever the sheet is called
Hope this is of some help.
Skinman

 

[rcorona106]

Thanks for the info but I still have the same problem. I don't want to have
to go into the macro every month and change the worksheet name. Although I
would only have 2 monthly sheets after the first time I run the macro, I will
be running the macro for every month there after so I will have a big number
of monthly sheets but need the macro to refer to the most recent monthly
sheet. Does that make sense?