F Frank Kabel Feb 10, 2004 #2 Christine said: How do I link sheet 1 with sheet 2? Click to expand... Hi Christine in cell A1 of your sheet 1 enter the equation sign '='. Now activate/select the other worksheet with the mouse and select the cell which should be linked. Hit enter or enter the formula manually ='sheet2'!A2 Frank
Christine said: How do I link sheet 1 with sheet 2? Click to expand... Hi Christine in cell A1 of your sheet 1 enter the equation sign '='. Now activate/select the other worksheet with the mouse and select the cell which should be linked. Hit enter or enter the formula manually ='sheet2'!A2 Frank
G Gord Dibben Feb 10, 2004 #3 Christine In Sheet2 A1 enter =Sheet1!A1 to link A1. OR enter an = sign in A1 of Sheet2 and switch to Sheet1 A1 and hit the ENTER key. OR copy Sheet1 A1, switch to Sheet2 A1 and Paste Special>Link. Gord Dibben Excel MVP
Christine In Sheet2 A1 enter =Sheet1!A1 to link A1. OR enter an = sign in A1 of Sheet2 and switch to Sheet1 A1 and hit the ENTER key. OR copy Sheet1 A1, switch to Sheet2 A1 and Paste Special>Link. Gord Dibben Excel MVP
