array formulas

Perhaps this previous post might give you s
ome possibilities to explore further: http://tinyurl.com/5ejr2
(the key column in your case would be the salesmen names)
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"johnT" <anonymous@discussions.microsoft.com> wrote in message
news:194301c53269$73231100$a401280a@phx.gbl...
> 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....

Hi Max,

I wish I had seen that before I re-invented the wheel :-)

Regards

Bob


"Max" <demechanik@yahoo.com> wrote in message
news:u4zAk0rMFHA.568@TK2MSFTNGP09.phx.gbl...
> Perhaps this previous post might give you s
> ome possibilities to explore further: http://tinyurl.com/5ejr2
> (the key column in your case would be the salesmen names)
> --
> Rgds
> Max
> xl 97
> ---
> GMT+8, 1° 22' N 103° 45' E
> xdemechanik <at>yahoo<dot>com
> ----
> "johnT" <anonymous@discussions.microsoft.com> wrote in message
> news:194301c53269$73231100$a401280a@phx.gbl...
> > 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....
>
>

> I wish I had seen that before I re-invented the wheel :-)
LOL! Thought you should be relaxing a little on a Sunday ?
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----