input file with more than 250000 lines

G

green1111

I need to work with input file with more than 250,000 lines but Excel
allow me to take in data with less than 65,000 lines only. How to
sslice my data in 5 worksheet so that I can work with my data ? Is
there any work around ? Thanks....
 
N

Niek Otten

This link leads to code from Bernie Deitrick

http://redirx.com/?334z

--
Kind regards,

Niek Otten

|
| I need to work with input file with more than 250,000 lines but Excel
| allow me to take in data with less than 65,000 lines only. How to
| sslice my data in 5 worksheet so that I can work with my data ? Is
| there any work around ? Thanks....
|
|
| --
| green1111
| ------------------------------------------------------------------------
| green1111's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33863
| View this thread: http://www.excelforum.com/showthread.php?threadid=536414
|
 
Top