Excel In Depth - Linking Workbooks: Podcast #1235

If you like this content, please consider visiting the video on YouTube and subscribe to the MrExcel Channel to show your support!
This video has been published on Sep 1, 2010.
Momentarily change the view setting, right-click and drag...Episode #1235 shows a cool way to set up a link between two workbooks simply by dragging.

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen.
maxresdefault.jpg


Transcript of the video:
MrExcel podcast is sponsored by Easy-XL.
Excel in Depth, chapter 16.
Linking Worksheets.
Hey! Welcome back to the MrExcel netcast.
This is one of the coolest tricks, certainly not the way, that most people would set up links between two different workbooks.
Here, I have a final presentation.
I want to get this number from another workbook.
Alright! So, I have both workbooks up, when I wanna press [ Ctrl + tab ].
Go look at the other workbooks.
So, here is '16-Summary Report'.
I want to grab that cell D10, and there's different ways to set up these references.
But, I'm gonna show you a really cool way.
I'm going back here to, the View tab.
Arrange All, Vertical.
It's that way I can see both the cell, that I want to link to and the cell, where I want it to go.
Now, I'm going to right click on the border.
So, I want to avoid the fill handle, but go anywhere along the border, right click.
And I'm going to continue to hold down the right mouse button, while I dragged from this location to this location.
When I let go, brand new box pops up.
I want to choose the entry for link here, and that builds the formula for me with the apostrophes('), the square brackets([ ]), the exclamation point (!), everything in the right spot.
Just an amazingly simple way to go through and set up a link between the two workbooks right drag from one to the other...
Hey I want to thank you for stopping by.
See you next time for another netcast, from MrExcel.
 

Forum statistics

Threads
1,214,911
Messages
6,122,198
Members
449,072
Latest member
DW Draft

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