Create new sheet and update new sheet

[rcorona106]

I have a workbook with 2 sheets. One is my data sheet and the other is
financial type looking sheet that shows monthly activity. I'm trying to
write a macro that will create a copy of the monthly activity sheet and will
update the information on the second monthly activity sheet once I update the
information on the data sheet. But I need the second monthly activity sheet
to keep the ending balances from the first monthly activity sheet. I got the
macro to create the sheets but am having trouble getting it to go back to the
second monthly activity sheet when I go update the information on the data
sheet. How do I go about doing this? Any help is greatly appreciated.
Thanks.

 

[rcorona106]

Excel.

Hi rcorona,

Are you looking for help with Excel or Access? Sheets are in Excel unless
you mean table.

Bonnie
http://www.dataplus-svc.com

 

[Steve Schapel]

Rcorona,

The focus of this newsgroup is Macros in Accxess, the database program.
You will have a better chance of getting good help if you repost to an
Excel related forum.

 

[rcorona106]

I didn't realize it was in the Access forum.

Thanks.