Hi Wal50

Start here
http://www.rondebruin.nl/copy5.htm

Use the workbook example
http://www.rondebruin.nl/copy5.htm#workbook


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"wal50" wrote in message ...
I have several thousand records in one sheet spread over about 50 branches
(Col. B - the branch codes are in the format aann). For each branch's
records, I need to create a separate workbook named with the branch code.
Thanks in advance
wal50