View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
IMS Lori IMS Lori is offline
external usenet poster
 
Posts: 10
Default Splitting a Worksheet into Multiple Sheets

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?