Forum Discussion
Make Excel use a text string as a formula
I've been trying various ways to quickly generate some data I require that involves dynamically linking various workbooks. This question is based on my latest idea. Is there a way to tell Excel to...
Try making a cell where you add up the strings to the final string you want it to be and then use the =INDIRECT function on that cell.
trdebruin Thanks Tim. This works but it requires the referenced workbook to be open. As most instances of this will reference 12 separate books (monthly reporting) this isn't practical.
The best solution I've come up with to date is to save hyperlinks to the separate books to enable them to be quickly opened with just 12 clicks, but it's not a great work around.