Am getting ready to create templates for 2007 in Excel. I need to know if
there is a way to create formatting or a macro to help me do the following:
I have several 2 page worksheets for my clients. The first page lists the
individual doctors within a clinic. I then enter the data for their
patients. The second page (which contains the same information) but is
listed as all inclusive for the clinic has to be copied to the second page.
Is there any way to create a macro that will automatically copy the entered
information from page one to page two without having to use the "copy/paste"
command????????
Any help will be GREATLY appreciated!!!
Thanks a million.
SuzyQ

You can add a button from the control bar or build as a macro and assign a
button, this makes an exact copy of your page and places it as the second
page. Change name "duplicate" to suit.

Private Sub CommandButton1_Click()
ActiveSheet.Copy Befo=Sheets(2)
ActiveSheet.Name = "Duplicate"
End Sub

--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"SuzyQ" wrote:

Am getting ready to create templates for 2007 in Excel. I need to know if
there is a way to create formatting or a macro to help me do the following:
I have several 2 page worksheets for my clients. The first page lists the
individual doctors within a clinic. I then enter the data for their
patients. The second page (which contains the same information) but is
listed as all inclusive for the clinic has to be copied to the second page.
Is there any way to create a macro that will automatically copy the entered
information from page one to page two without having to use the "copy/paste"
command????????
Any help will be GREATLY appreciated!!!
Thanks a million.
SuzyQ