Forum Discussion
Use data from one Workbook for calculations in another Workbook.
Hello, I created a new Workbook by cutting and copying a worksheet from the main Workbook, so the two workbooks have some cross communications in formulas. I saved the new Workbook on the Desktop hop...
Detlef_Lewin wrote:Frank,
some functions - like INDIRECT() or COUNTIF() - only work when the source workbook is open.
Thank you, infortunately I used both :-)
I shall fix the problem from anothe side.
As a comment. In general INDIRECT works with absolute path, COUNTIF could be changed on SUMPRODUCT which also works with absolute path (COUNTIF not), etc.
Another story is what in real life you have to use this absolute path as parameter defining it manually or based on some rules, e.g. parent folder for current subfolder.
SergeiBaklan wrote:COUNTIF could be changed on SUMPRODUCT which also works with absolute path (COUNTIF not), etc.
Thank you. I shall try to replace Countif by Sumproduct.
Yes, I try to creat a parant folder to work with subfolders.