I have formulas that references cells in other workbooks and I would like to add two or more of these cells without simply adding the cell reference ie I do not want =A1+A2 but ='[Workbook1.xlsx]Sheet1'!A1+'[Workbook1.xlsx]Sheet2'!A1. Also, I cannot add the cells in Workbook1 before I reference them in the workbook I am currently working with. Is there a simple way to do this?
Hi and welcome to the forum
You can do this with the indirect() function, but the other workbook/s has to be open. Or you could install the Morefunc add-in, and then the indirect() will work on closed W/B's
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks