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.
...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen.
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.
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.
