Open them both, tile them so you can see both, then click into a cell on one
book, type =, then use the mouse to click into a cell on the other book and hit
enter. Save the book and then close the source book, at which point the full
filepath will appear in the workbook.
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.