I know how to do that part of it, but I was wondering (hoping) that there was
a way to automate the process so that it will cut and seperate on its own.
Somebody told me that there was a way to do this, but... ya. Anybody?
-Arden

Earl Kiosterud wrote:
Arden,

If you're doing this manually, to select 500 rows, press F5 (Goto). Type
1:500. Enter. Now you could cut this selection (Edit - Cut), paste to a
different worksheet in a different workbook, or however you want to save
this first group of rows.
--
Earl Kiosterud
www.smokeylake.com

Hi -
I am having a difficult time accomplishing this (in theory only, it
[quoted text clipped - 12 lines]
for this project. Thanks in advance.
-Arden