Automatically copying data into a new worksheet

M

Matthew

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically copy data from one worksheet into another 1
Sharing infor between worksheets based on terms 3
How to update data from linked worksheet back to a master worksheet? 0
How to update a value from a linked worksheet back to the master worksheet? 0
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Macro to copy specific data from master workbook to another workbook 9
Index Match ? 3
Tie additional cells to cell automatically updated 1

Top