Hi
if you have many rows of data I wouldn't use a formula approach (too slow).
Maybe try the following addin:
http://www.rondebruin.nl/easyfilter.htm

--
Regards
Frank Kabel
Frankfurt, Germany

Sean Larkin wrote:
I have a workbook, and the master sheet has data in many columns and
rows. Column B is the type field, and every row has been given a type
of either, Direct, National, or Dealer. The master sheet will be
updated regularly (weekly or monthly). I want to minimize the work
required to update the workbook, so the ideal solution is for just
the master sheet to be updated manually, and the rest of the sheets
update themselves accordingly.

I want to have 3 additional sheets, one for each type. I'd like each
sheet to automatically list rows of their corresponding type from the
master sheet.

For example, the Direct sheet will show all rows from the master
sheet that have the type, Direct.

Master sheet:
midwest Direct 12000 500 0 500 12500
northeast National 315 1354 0 454 55521
southwest Dealer 14540 200 2 11250 111250
midwest National 13245 321 0 312 748678
midwest Direct 23546 324 0 123 67898
northeast Direct 315 1354 0 454 55521
northeast Direct 343 2678 0 433 234234
northeast National 315 1354 0 454 24234
southwest National 4342 200 2 33423 234423
southwest Dealer 3424 200 2 45664 67898

-----------


Direct Sheet should be:
midwest Direct 12000 500 0 500 12500
midwest Direct 23546 324 0 123 67898
northeast Direct 315 1354 0 454 55521
northeast Direct 343 2678 0 433 234234


------

This example is very minimal, compared to the actual amount of data
on the master sheet. I have been looking up information of Lookups,
Index/Match and Advanced Filtering, but I just can't make it happen.

Does anyone have any ideas?

Thanks.

-Sean