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! |
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! |
All times are GMT +1. The time now is 01:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com