Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically copy data from one worksheet into another
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy data into another worksheet and have it update automatically? | Excel Discussion (Misc queries) | |||
Automatically copy data from one worksheet to another | Excel Worksheet Functions | |||
Copy data automatically onto a separate worksheet | Excel Discussion (Misc queries) | |||
Copy data into another worksheet and have it update automatically? | Excel Discussion (Misc queries) | |||
automatically copy data from one worksheet to another | Excel Worksheet Functions |