Master Sheet?

  • Thread starter Thread starter cw14226
  • Start date Start date
C

cw14226

What's the best way to create a Master Sheet with Names and information
that can be duplicated to other sheets? The main problem I have is when
I add new names to the list. Any suggestions?
 
Two ways I use are:
(a) Type your information in a "Master_List.xls" and call it using code
to copy the information into a new workbook.
(b) Create a "Master_Template.xls", then call this, add your other
information, and do SaveAs.

Either way, you can update only one "master" file, and use it to create
updates at leisure. (Note: file names were arbitrary, and do not designate
any special Excel functions that I know of.)

HTH
Ed
 
Back
Top