hi, i need some help writing a macro that cuts and pastes some rows into
a new sheet and saves it accordingly to a cell name.

e.g.

Repeating
Vendor ID
Number 1
total: $15

Repeating
Vendor ID
Number 2
total $20



so "Repeating" is the marker and i need it to take that certain chunk
and save it as the "Vendor ID" name so the first one would be named
"Number 1.xls"

thanks for the help!


--
MonkeyMe
------------------------------------------------------------------------
MonkeyMe's Profile: http://www.excelforum.com/member.php...o&userid=23526
View this thread: http://www.excelforum.com/showthread...hreadid=378527