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

[Terry T]

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.

 

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

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.

 

[Terry T]

Could someone please help me with the code to do this?

 

[Dave Peterson]

You may want to look at Debra Dalgleish's sample workbooks:
http://www.contextures.com/excelfiles.html

Look for:

Update Sheets from Master -- uses an Advanced Filter to send data from
Master sheet to individual worksheets -- creates a list of unique items,
creates a sheet for each item, then replaces old data with current.
AdvFilterCity.xls 46 kb

and

Create New Sheets from Filtered List -- uses an Advanced Filter to create
separate sheet of orders for each sales rep visible in a filtered list; macro
automates the filter. AdvFilterRepFiltered.xls 35 kb