What do you mean "Using only the first digit of each sheet", that would
give you problems as you cannot have more than one sheet named the same!

bobbi;454183 Wrote:
--
bobbiI have a workbook with 30 worksheets labeled Abook1 to Abook10,
Bbook1
to Bbook10, Cbook1 to Cbook10. The

worksheet name is repeated in the same cell on each sheet.

I would like to save each group of 10 into seperate workbooks named A,
B,
and C (using only the first digit of each

sheet name). Then make sure each workbook has the sheets in numerical
order
(they won't necessarily be

completed in order). Is there a macro that will do all that
automatically?


--
Simon Lloyd

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=125723