I want to find a way to sort 1 spreadsheet into 2 spreadsheets based upon what is contained in the category column. If it contains 'cat' I want all those lines to go into the first spreadsheet. If it contains " " (nothing ) I want it to go onto the second spreadsheet. How would one go about doing that? Thanks guys.