How do I effeciently share text from two different sheets?

K

kristina

Please help. I want to link two different sheets, many cells... like a whole
column at once. TEXT!!! Any advice?
 
D

Dave Peterson

Select the range
edit|copy
select the top left cell of the range to paste
edit|paste special|Click paste link
 
G

Gord Dibben

kristina

Select the entire column in Sheet1 and copy.

Switch to Sheet2, select A1 and Paste Special>Paste Links>OK>Esc
 
Top