General discussion

Locked

Dynamic link

By demo ·
How do I set up a dynamic link between 2 excel sheets.

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by DKlippert In reply to Dynamic link

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

Collapse -

by DKlippert In reply to Dynamic link

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

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Forums