Hi Everyone,

I have to admit my experience/knowledge with macros in Excel is very limited.

Anyway here is what I have and what I would like to try and do via a Macro:

What I have:
I have an Excel 2010 file that has 1 Column and approx. 9,000 Rows of Data.

What I would like to do:
I'm looking for a macro that will break apart the 9,000 rows into 300 rows per each file.

Example:

Orginial.xls contains Row 1-9,000
Rows 1-300 moved to NewFile1.XLS
Rows 1-300 deleted from Original.xls
Rows 1-300 moved to NewFile2.XLS
Rows 1-300 deleted from Original.xls
Rows 1-300 moved to NewFile3.xls
etc...

After it's all said and done:
Orginial.xls = empty
NewFile1.xls - NewFile30.xls created with 300 rows each.

Hopefully this makes sense

Thanks for your time.