View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
 
Posts: 2,344
Default Creating a Template

Hi,

templates can't do that. You would need to consider VBA code.


--
Thanks,
Shane Devenshire


"newguy" wrote:

I am wanting to create multiple excel files that all contain the same
information however I want them all to be based on a template so when
I update the template it pushes out the changes to all of the excel
sheets that have been made from it. I guess what I need is a Source
worksheet that all of the other sheets reference. So what is the best
way to accomplish this.