Linking workbooks data via INDIRECT
I am a newbie in this forum and I'd like to say Hi to everyone.
I have a weekly sales register that I wish to link to an annual monthly register. My problem is that the data doesn't appear on the monthly register when the source weekly workbooks are not open. I used 'indirect' function.
Please help me, thanks!
INDIRECT doesn't work on closed workbooks. You've discovered that. If this is a MUST, then you'll have to install more functionality into your Excel program. Only people with the same installed ADD-IN will be able to use your sheet.
The ADD-IN is called MoreFunc...read all about it here:
http://www.ashishmathur.com/tag/morefunc/
See step #4 of that page for instructions on downloading and installing
Go into TOOLS > ADDINS and activate MoreFunc.
Now you have many, many new functions available to you. Any place you used INDIRECT, now use INDIRECT.EXT instead and it will work on closed workbooks.
Last edited by JBeaucaire; 05-25-2013 at 10:06 AM. Reason: Updated MOREFUNC link
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
morefunc.xll can be embedded directly into the workbook of interest thereby negating the need to install the add-in on multiple clients.
(I *believe* there are issues embedding the add-in in XL2007)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks