Filter Data with formulas

[Peanut]

I am trying to filter a database based on certain criteria without using the
autofilter function. I have a master data sheet that lists all my customers
and the types of businesses they are. From that master tab, I would like
separated tab for each type of business. Is there a formula I can use to
look up from this master sheet and sort based on the criteria without using
the autofilter button? The problem with using that is I would have to copy
all the data multiple times, creating a much larger spreadsheet than what it
needs to be.

Any help would be appreciated.

Thank you,
Peanut

 

[Max]

Here's one non-array formulas set-up which can deliver the required
functionalities ..

Take this sample construct from my archives:
http://www.savefile.com/files/430142
AutoCopy Lines to Resp Sht Non Array.xls
(Full details inside, nicely rendered. Easy to adapt ..)

Data is continuously entered in a master ("parent") sheet, with lines neatly
auto-copied to each individual ("child") sheet based on the values within a
key col.

In the sample, the key col in the master sheet is the "State" col, which may
contain eg: NY, CA, NV, SD, AZ, etc. All lines with "NY" in the key col will
be auto-copied to the sheet named: NY, and appear neatly bunched at the top,
w/o any intervening blank lines. Ditto for lines with "CA", "NV", etc which
will be copied into their respective sheets.

Propagation of the "child" sheet is as simple as making a copy of the
initial one, then renaming it accordingly as the next key col value. Eg we
first formulate one child sheet for "NY", dress it up nicely, then just make
copies of the "NY" sheet, and rename these as: CA, NV, SD, etc.

In your case, the key col would be your "Business Type" col, eg: BizTyp1,
BizTyp2, etc