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

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

 

[Jean-Guy Marcil]

(e-mail address removed) was telling us:
(e-mail address removed) 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!

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

--

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org