how can I link cells on sheet 1 to sheet 2 within the same workbook? Lp
G Gary''s Student Jan 7, 2006 #2 Copy the cells on sheet 1 and paste/special on sheet 2 with link set
B bpeltzer Jan 7, 2006 #3 In sheet1, in the cell that should be linked, type = then click to the source cell in sheet2. The result will be a formula like =Sheet2!A1. (You could also just type the formula).
In sheet1, in the cell that should be linked, type = then click to the source cell in sheet2. The result will be a formula like =Sheet2!A1. (You could also just type the formula).
