Hi Adams

See the workbook example on this page
http://www.rondebruin.nl/copy5.htm

--

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




"Adams SC" wrote in message ...
I have several columns of data on a worksheet. I want to use the data in
Columan A to create a new workbook, named the same and copy all the for the
those items.

__________ Information from ESET Smart Security, version of virus signature database 3969 (20090327) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 3969 (20090327) __________

The message was checked by ESET Smart Security.

http://www.eset.com