Discussion Locked
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.
Trending Software posts
Sort by Trending
Discussion
Useful software Tip or Shortcut
0 helpful
1 reply
1 helpful
1 reply
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
5 replies
0 helpful
20 replies