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.
