View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CJ CJ is offline
external usenet poster
 
Posts: 18
Default Create new worksheet from template for each value in range

Can someone help me with this macro please?

Scenario:
Table of Contents Sheet named TOC
Table of Contents range A6:D9
Template Sheet named template

Macro:
1) Create new worksheet from worksheet template for each value in
column A
2) Name the worksheet with the A value from range
3) New worksheet cell D1 equals corresponding D value from range