Discussion Locked

Dynamic link

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How do I set up a dynamic link between 2 excel sheets.

2 replies

by dklippert

Type an = sign and then switch to the other sheet and click on the appropriate cell. It will look like:
=Sheet1!A1/
You can also name the range. Select the cell and type a name in the name box to the left of the Formula bar and give it a name. Use that name in formulas:
=Fred

by dklippert

Type an = sign and then switch to the other sheet and click on the appropriate cell. It will look like:
=Sheet1!A1/
You can also name the range. Select the cell and type a name in the name box to the left of the Formula bar and give it a name. Use that name in formulas:
=Fred

This discussion is closed to new replies.