I have raw data imported from an accounting program on sheet one. I need to lookup all rows containing "Territory A" in column one. Copy all those rows to sheet 2 to create a table. Then to lookup all rows containing "Territory B" in column one and to copy all those rows to sheet 3 to create a table. And on and on. the number of rows will vary. Then I need to be able to find the end of each table and create a sum/totals row. Would a macro do this? Or do I need Visual Basic or something? Any insight or information is appreciated.