Cell Content from one worksheet to another without the need to retype

I am using Excel 2010:

I created 2 sheets that are connected. One is a worksheet that I enter alot of data on, the other is my 'final' Client Sheet that I turn into my client and it only contains the info that the client needs, so not ALL of the data in the worksheet cells are transferred.

A friend help me set up the sheets so that when I type data (that will need to show up on my client's final sheet) into specific cells on my 'worksheet', it automatically transfers the data onto the Client Sheet, saving me alot of time.

That is all working great. But on occasion, I do need some data from the Worksheet to appear on the Client Sheet. This doesn't happen alot, so I don't want it to 'transfer automatically' like the basic info. Is there another way besides "copy & paste" to accomplish this?

For instance, isn't there a command to use that if I highlight the Worksheet cell containing the data I need, then click inside the cell on the Client Sheet that I want the data to appear in, it will copy that data into the Client Sheet?

I am not certain what category I should search for help under.

Thanks

dlnewman

darrelnewman7@gmail.com

Continue reading...