Macro to split up Excel files that are larger then 65,000 rows

Z

ZhenyaVirina

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!
 
J

Jean-Guy Marcil

[email protected] was telling us:
[email protected] nous racontait que :
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!
Click to expand...

This is a Word group. You should be posting in an Excel group.

--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
[email protected]
Word MVP site: http://www.word.mvps.org
 
Top