Thread: create 50 copies of a worksheet in the same file
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default create 50 copies of a worksheet in the same file
In a sheet named: List,
enter (or paste over) the reference list of 50 sheetnames in A1 down

The 50 copies will be created (from left to right) in the order that the
names are listed in A1 down. So just sort the list in A1:A50 in the desired
order before running the sub.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
Reply With QuoteReply With Quote