March 3, 2010
You Learn Something New
I've been an acknowledged advanced user of Excel for around 10 years now, and yet I've literally only just learned how to use =INDIRECT() to create dynamic links to external workbooks (generally, I've used manual find and replace or over-complex VBA routines to achieve this in the past)...
http://www.techsupportforum.com/microsoft-support/microsoft-office-support/72872-excel-using-variable-link-external-workbook.html
A whole new world has just opened up in front of me. I like it when that happens.
philoddy.com
Stuff and nonsense
Stuff and nonsense
