Maybe this will help
http://www.rondebruin.nl/copy5.htm

--

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


"IMS Lori" wrote in message ...
I am in the process of copying and pasting information from one single
worksheet, into sheets in another workbook and decided there has to be an
easier way to do this. It's basically a list of all of our company's jobs.
They are grouped by company name, and what I'm doing is making a worksheet
for each company all in one workbook. I'm selecting all the jobs and their
information and copying/pasting in the other workbook.

Does anyone know if there's a way to make this process quicker/easier/more
efficient?