View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David David is offline
external usenet poster
 
Posts: 17
Default adding sheets based on input

I have a template sheet that I want to take and build a
workbook with. I want to ask the user how many sheets they
want to make. Each sheet is for a different company.
Sometimes there are 12 companies and sometimes it is 16 or
anything in between. I want the user to identify this.
Then I want the template sheet to make this many copies of
it. Then I want it to ask them what they want to name the
sheets. Any help would be great. Email me with any
questions.

Thanks,
David