Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can not open excel file xls. extensions | Excel Discussion (Misc queries) | |||
Trying to open file, may have renamed it | Excel Discussion (Misc queries) | |||
How do you open a template at startup? | Excel Discussion (Misc queries) | |||
Can Only open files using file ~ open | Excel Discussion (Misc queries) | |||
Empty Workseek: File still too large (>300k) | Excel Discussion (Misc queries) |