View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SuzyQ SuzyQ is offline
external usenet poster
 
Posts: 15
Default Need help w/macros & formatting templates to save time

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