| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to split up one spreadsheet into multiple worksheets
I have a list of over 11,000 rows in Excel that are UPS tracking numbers.
Since I can only submit 100 rows at a time into the UPS tracking system, how can I split this worksheet up into multiple worksheets of 100 rows each. I know I can just cut and paste them manually, but that's too time consuming. Help, please. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to split up one spreadsheet into multiple worksheets
Never mind, I found the answer. For the benefit of others try this:
http://www.ozgrid.com/forum/showthread.php?t=82788 It worked perfectly. "Gloria Lewis" wrote: I have a list of over 11,000 rows in Excel that are UPS tracking numbers. Since I can only submit 100 rows at a time into the UPS tracking system, how can I split this worksheet up into multiple worksheets of 100 rows each. I know I can just cut and paste them manually, but that's too time consuming. Help, please. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Separate/Split all the worksheets in a workbook into different fil | Excel Discussion (Misc queries) | |||
| How do I print a spreadsheet with multiple worksheets? | Excel Discussion (Misc queries) | |||
| How do you populate one spreadsheet from multiple worksheets in a. | Excel Worksheet Functions | |||
| Can I split up an excel spreadsheet into multiple files by rows? | Excel Discussion (Misc queries) | |||
| split results to multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
