excel programming vba - 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