MilesLogan
asked on
How to separate one Excel file into multiple files.
Hi EE
I have an Excel file with 100,000 line items with two columns .
Does anyone know how I can separate that into 10 files with 10,000 line items each ?
I have an Excel file with 100,000 line items with two columns .
Does anyone know how I can separate that into 10 files with 10,000 line items each ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Subodh thank you so much !! exactly what I was looking for ..
You're welcome! Glad it worked as desired.
e.g. 0000-1000.xls 1001-2000.xls 2001-3000 ..... etc.
Then edit the 10 files one by one, deleting the relevant 9,000 lines in each file.