Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to split up Excel files that are larger then 65,000 rows Options
Can someone please help me!!
I am looking for a code which can split up Excel files that are larger then 65,000 rows. For now I was using text pad and access, but it's taking too long. I need to be able to split up by a project numbers, so that I don't loose any information which was attached to the project. For example: If a file has 10 different projects and the last project started before the 65,000 row and continues, is there anyway for the macro to take out full data for the particular project and put it in a separate file? I hope I made sense PLEASE HELP! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to split up Excel files that are larger then 65,000 rows Options
Maybe you can use this ?
http://www.rondebruin.nl/copy5.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message ups.com... Can someone please help me!! I am looking for a code which can split up Excel files that are larger then 65,000 rows. For now I was using text pad and access, but it's taking too long. I need to be able to split up by a project numbers, so that I don't loose any information which was attached to the project. For example: If a file has 10 different projects and the last project started before the 65,000 row and continues, is there anyway for the macro to take out full data for the particular project and put it in a separate file? I hope I made sense PLEASE HELP! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to split excel file into seperate files and then email | Excel Discussion (Misc queries) | |||
Line up rows to corresponding row of larger master list in excel | Excel Worksheet Functions | |||
options list box - larger text | Excel Worksheet Functions | |||
Can I split up an excel spreadsheet into multiple files by rows? | Excel Discussion (Misc queries) | |||
How do I get a specific list of rows out of a much larger excel s. | Excel Worksheet Functions |