Linking Worksheets

A

agnerc

New Member
Joined
Jun 18, 2018
Messages
13
Is there a way to link worksheets together, to where I modify one and the other updates?

Thank you,
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Sort by date Sort by votes
Hello,

Yes, just have both workbooks open, then in one workbook type = and then click on the cell you wish it link to in the 2nd workbook...
 
Upvote 0
Gallen,

I want to make a copy of a worksheet and link both of them together, not just individual cells.
 
Upvote 0
You must log in or register to reply here.

Similar threads

willow1985
  • Solved
Linking 2 identical tables in the same workbook so when one updates the other updates
2
Replies
18
Views
407
mumps
mumps
M
  • Question Question
Updating Excel Links during an ACTIVE Powerpoint Presentation
Replies
0
Views
83
mikeb7500
M
D
  • Question Question
linking a cell to a worksheet
Replies
7
Views
91
Fluff
Fluff
T
  • Question Question
Linked cells when transferring worksheets between workbooks
Replies
5
Views
229
Alex Blakenburg
A
J
  • Question Question
Need VBA code to get the list of top 10 recent files from Sharepoint link on the excel ribbon as macros in excel ribbon.
Replies
0
Views
87
Julia Kurakula
J

Forum statistics

Threads
1,224,818
Messages
6,181,150
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top