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
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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
