Hi!

You don't necessarily need array formulas but it all
depends on what your layout is and what type of data you
want to compile.

You may be able to use simple lookups or, a lot of people
might recommend a pivot table. In any event, you would
need to give more details for a more specific suggestion.

Biff

>-----Original Message-----
>I have a rather large spreadsheet listing salesmen,
>customers, locations etc. I would like to create separate
>worksheets for each salesman listing only data related to
>that salesman...on each worksheet i want to referance the
>master worksheet, how can i do this without having a
large
>group of blank rows??? I think this may be an application
>for array formulas but i need some help.
>
>thanks in advance....
>.
>