Hi -
I am trying to create a sales pipeline. I will have one "master" worksheet
that will have all information on potentail clients, as well as actual
clients. In the master worksheet every company that will be listed will have
a status depending where they are in the sales pipeline as shown below

NAME STATUS SALES REP
ABC New Smith
DEF New Jones
GHI Prospect Smith
JKL Suspect Gow

My question: If I had a worksheet that was titled NEW and one that was
titled Prospect etc., is there a way that everytime a NEW client was entered
in the Master worksheet it would automatically copy all the information into
the NEW worksheet?

Thanks very much for reading. Any help would be greatly appreciated.

A macro could do this for you. You might want to post your request in
the microsoft.*public.*excel.*programming newsgroup, this is just a
general Excel group.


HTH,
JP

On Apr 4, 11:11*am, Matthew <Matt...@discussions.microsoft.com> wrote:
> Hi -
> I am trying to create a sales pipeline. *I will have one "master" worksheet
> that will have all information on potentail clients, as well as actual
> clients. *In the master worksheet every company that will be listed willhave
> a status depending where they are in the sales pipeline as shown below
>
> NAME * * * * * * * * STATUS * * * * * * * * * * * SALES REP
> ABC * * * * * * * * * *New * * * * * * ** * * * * * * Smith
> DEF * * * * * * * * * *New * * * * * * ** * * * * * * *Jones
> GHI * * * * * * * * * * Prospect * * * * * * * * * * * Smith
> JKL * * * * * * * * * * Suspect * * * * * * * * * * * * Gow
>
> My question: If I had a worksheet that was titled NEW and one that was
> titled Prospect etc., is there a way that everytime a NEW client was entered
> in the Master worksheet it would automatically copy all the information into
> the NEW worksheet?
>
> Thanks very much for reading. *Any help would be greatly appreciated.