View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bobzter100 Bobzter100 is offline
external usenet poster
 
Posts: 12
Default Save Worksheet To Master Workbook

Hi
Can I create a macro to save a weekly Worksheet to a Master Workbook? The
Master is held on a Network Drive and the weekly Worksheet has a unique tab
name, e.g each week the new worksheet will be named Week 1, Week 2..etc for
52 weeks of the year so at the end of the year there will be 52 individual
worsheets within the Master Workbook.
Thanks in advance
Bobzter