excel programming vba - formulas link workbooks

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel programming vba - Formulas to link workbooks

excel programming vba - Formulas to link workbooks

resolvedResolved · Low Priority · Version Standard

Gerard has attended:
Excel Intermediate course

Formulas to link workbooks

how do I link two workbooks

RE: formulas to link workbooks

Hi Gerard

Thanks for your question.

You can link workbooks in two ways:

1. Have both workbooks open, type = into the cell you wish to link to a cell in the other workbook, click on the cell you wish to link to and press Enter.

2. Copy the cell you wish to create a link to, then click in the cell that is to be linked to the cell you have copied. Go to Edit - Paste Special on the menu, choose Paste Link and OK.

I hope this helps.
Amanda


 

Excel tip:

Hiding and unhiding rows using the keyboard

CTRL + 9 hides your columns and CTRL + SHIFT + ( unhides them although you would need to highlight the row letters either side as per normal

View all Excel hints and tips


Server loaded in 0.09 secs.