G Guest Dec 6, 2005 #1 Please help. I want to link two different sheets, many cells... like a whole column at once. TEXT!!! Any advice?
Please help. I want to link two different sheets, many cells... like a whole column at once. TEXT!!! Any advice?
D Dave Peterson Dec 6, 2005 #2 Select the range edit|copy select the top left cell of the range to paste edit|paste special|Click paste link
Select the range edit|copy select the top left cell of the range to paste edit|paste special|Click paste link
G Gord Dibben Dec 6, 2005 #3 kristina Select the entire column in Sheet1 and copy. Switch to Sheet2, select A1 and Paste Special>Paste Links>OK>Esc
kristina Select the entire column in Sheet1 and copy. Switch to Sheet2, select A1 and Paste Special>Paste Links>OK>Esc