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