Select the cell or cells where you want to create the external reference.
Type = (equal sign).
Switch to the source workbook, and then click the worksheet that contains the cells that you want to link.
Press F3, select the name that you want to link to.
press Enter.
Let me know if this works.
Regards,
Jerry
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.