View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Terry T Terry T is offline
external usenet poster
 
Posts: 1
Default 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.