| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Splitting a Worksheet into Multiple Sheets
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I capture info from multiple sheets to main worksheet? | Excel Discussion (Misc queries) | |||
| Combine multiple sheets of data into one worksheet | Excel Discussion (Misc queries) | |||
| Multiple text sheets into a master worksheet as you enter data | Excel Worksheet Functions | |||
| Splitting Data into separate sheets | Excel Discussion (Misc queries) | |||
| splitting 1 sheet to multiple sheets | Excel Discussion (Misc queries) | |||
Linear Mode
