I have a spreadsheet with lots of data and what we normally do now i
take that data (based upon the value in column H(which is our Vendo
ID)), cut and paste each row that matches which vendor we're lookin
for into new seperate files and save it. It is very tedious work. I'
curious if it is possible to do this in a macro in which one would hav
it so that it takes the data based upon the values in column H an
makes seperate files for each different value with the data from eac
corresponding row. I hope that makes sense

--
DK
-----------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...fo&userid=1451
View this thread: http://www.excelforum.com/showthread.php?threadid=39247