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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically copy data from one worksheet into another
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 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 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. |
Reply |
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 |