If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking worksheets
How do I link sheet 1 with sheet 2?
|
#2
|
|||
|
|||
Linking worksheets
Christine wrote:
How do I link sheet 1 with sheet 2? 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 |
#3
|
|||
|
|||
Linking worksheets
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 SpecialLink. Gord Dibben Excel MVP On Tue, 10 Feb 2004 09:00:19 -0800, "Christine" wrote: How do I link sheet 1 with sheet 2? |
Thread Tools | |
Display Modes | |
|
|