View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bluelagoon_HP bluelagoon_HP is offline
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!