Is it possible to breakdown link to a separate workbook

R

Regan Saveall

I would like to be able to display in a cell the root of the workbooks being
linked to.
And have cells below this, use the roots together with a cell reference to
retrieve data.
EG
a1: 'c:\data\[spreadsheet1]page1'
a2: 'c:\data\[spreadsheet2]page1'

a4: sum of cell b1 in spreadsheets named above

Any help would be much appreciated
 

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.

Ask a Question

Top