I have a spreadsheet that contains a report of which department has an item entered. what I want to accomplish is to move the individual 'department' data to thier own sheets. I have one case where I will have 4 different departments combind on one sheet, the remaining will occupy thier own sheets. How can i create a macro that will look down this column containing the department names and move thier data over to a new sheet, all within the same workbook? Thanks