How to split up one spreadsheet into multiple worksheets

G

Gloria Lewis

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

splitting a worksheet into multiple worksheets 1
split worksheet into multiple files by every 25000 row 1
Combining data from multiple worksheets into one 4
SPLITTING DATA INTO NEW WORKSHEETS FROM ONE WORKSHEET 2
Need to merge worksheets - Excel 2003 0
Split cells across multiple columns 1
replace all formulas with values in multiple worksheets 5
Macro Help 6

Top