lookup, cut, go to named worksheet and paste complete rows
 

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.

lookup, cut, go to named worksheet and paste complete rows
 

a macro and visual basic for applications are synonymous. You can do this
with a macro/VBA.

--
Regards,
Tom Ogilvy

"Terry T" wrote in message
...
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.