In Excel how do I put variables in links to other workbooks?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to insert a variable in a link to another workbook? Is there
some way automatically manipulate the link with say the date for example. Ex.
In March the data in this cell would be read from a cell in workbook 3 and in
April it would read data from workbook 4.

Thanks
 
It sounds as though you can use TODAY() and INDIRECT but we need to know
what the workbooks are called
 
I think INDIRECT may work, if it works like indirect addressing. I was just
using the date as an example.

Thanks
 
You must log in or register to reply here.

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

Similar Threads

Link changes in destination workbook 4
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
trouble with closed workbook 2
XL2000 Links Between Workbooks 2
Linking a workbook to worksheets 1
Excel 2007 - Linking workbooks 1
Copy cells in Excel 1
Finding cells that contain references to other workbooks 2

Back
Top