LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default i want to open large file 300 col, how to split between worksheets

i have large data file i need to load into excel
15000 rows by 300 columns
i know there is limitation on 256 columns, however i would like to know how
to split the colums at will, say 150 in 1st sheet and 150 in 2nd sheet

i know there is a macro for that on ms support, i got it, but it's not user
friendly,
there are no inputs for rows to be split etc...

so the question is: is there a user friendly add on or a macro that i can
install that allows splitting one file by rows into different sheets, for
easy loading into excel ?

thanks!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can not open excel file xls. extensions cjshazen Excel Discussion (Misc queries) 1 February 14th 06 01:17 AM
Trying to open file, may have renamed it sirsoto Excel Discussion (Misc queries) 4 August 12th 05 12:54 PM
How do you open a template at startup? James Kendall Excel Discussion (Misc queries) 7 July 26th 05 07:33 PM
Can Only open files using file ~ open tek4u Excel Discussion (Misc queries) 4 July 11th 05 05:31 PM
Empty Workseek: File still too large (>300k) Anik Excel Discussion (Misc queries) 2 March 16th 05 06:21 PM


All times are GMT +1. The time now is 11:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"