Can anyone tell me how to shift-click or whatever the shorcut is to put the
value of one cell in the same workbook in to another cell on a different
sheet in the workbook please? Thank you.

Ctrl + C, right click the cell where you want it and select paste special
and link

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Christopher ATC" <Christopher wrote in
message ...
Can anyone tell me how to shift-click or whatever the shorcut is to put
the
value of one cell in the same workbook in to another cell on a different
sheet in the workbook please? Thank you.

Thank you for responding, but there is another way to do it without having to
right click it is something like double clicking the destination cell then
shift clicking the source. I still need to figure this out!

"Peo Sjoblom" wrote:

Ctrl + C, right click the cell where you want it and select paste special
and link

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"Christopher ATC" <Christopher wrote in
message ...
Can anyone tell me how to shift-click or whatever the shorcut is to put
the
value of one cell in the same workbook in to another cell on a different
sheet in the workbook please? Thank you.

"Christopher ATC" wrote in
message ...

"Peo Sjoblom" wrote:

"Christopher ATC" <Christopher wrote in
message ...
Can anyone tell me how to shift-click or whatever the shorcut is to put
the
value of one cell in the same workbook in to another cell on a
different
sheet in the workbook please? Thank you.

Ctrl + C, right click the cell where you want it and select paste special
and link

Thank you for responding, but there is another way to do it without having
to
right click it is something like double clicking the destination cell then
shift clicking the source. I still need to figure this out!

= in the destination cell, then click in the source?
--
David Biddulph