Hi Everyone,
I have a master workbook for summary and a folder with multiple workbooks.
In my master workbook. Each cell is currently linked to the workbooks in that folder. Please see below
The files in that folder is growing and I would like the cell formula to be in such a way that it will sum/calculate regardless of what the workbook name is.
Please Login or Register to view this content.
Is that possible? Right now the code works if I have specified the name of the workbook.
Thanks
I have Three Suggestions In this case:-
- You have to link each files reference manually
- Redirect the formula to cells for picking the file names for picking the values. Can be done with the help of Indirect.Ext of Morefunc Addin which will work with closed workbooks too..
- Use VBA to loop through the folder and add all the file references to formula
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Originally Posted by :) Sixthsense :)
Thanks so much for the suggestions. How do I go about doing the second or third suggestion? I would like the cell to calculate/sum the cell of any workbook (regardless of the workbooks name).
Last edited by sk88; 07-30-2013 at 10:32 AM.
I found codes online for vba. Thanks for your help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks