kiisaaa
10-24-2016, 05:44 AM
Hi,
I am developing a workbook reporting the main KPI's of our business.
I am going to use the excel reports from the different managers located on different dropbox locations to form this 'master KPI-workbook'. There's several different excel sheets, and even some monthly reports of sales etc in individual workbooks.
The masterbook contains a sheet with a 'presentation' of the KPI's for each month.
Further, does it contain "sales input, research input, department 3 input" and so on.
My plan is to make all the managers copy their reports once a month in a shared folder, where the masterbook is located, so it's easier to pull the requested data from all the reports.
I want to link these individual sheets up to the different excel-reports form the different departments. My sheets needs to pull data from either one, two or even five/ten excel sheets, all depending on which department I am gathering data from.
I am trying to use an extended indirect furmla to pull data from our sales reports,
=INDIRECT.EXT("'["&K1&".xlsx]Sheet1'!f16") - where K1 contains "Results Oktober 2016".
I get the same issue as with the regular indirect forumla, it returns #REF if the workbook is closed.. I have tried other UDFs, but I still get the same issue, and I do not know why..
Any tips on how to easy pull the requested data, without having to have all the workbooks opened at the same time?
:-)
I am developing a workbook reporting the main KPI's of our business.
I am going to use the excel reports from the different managers located on different dropbox locations to form this 'master KPI-workbook'. There's several different excel sheets, and even some monthly reports of sales etc in individual workbooks.
The masterbook contains a sheet with a 'presentation' of the KPI's for each month.
Further, does it contain "sales input, research input, department 3 input" and so on.
My plan is to make all the managers copy their reports once a month in a shared folder, where the masterbook is located, so it's easier to pull the requested data from all the reports.
I want to link these individual sheets up to the different excel-reports form the different departments. My sheets needs to pull data from either one, two or even five/ten excel sheets, all depending on which department I am gathering data from.
I am trying to use an extended indirect furmla to pull data from our sales reports,
=INDIRECT.EXT("'["&K1&".xlsx]Sheet1'!f16") - where K1 contains "Results Oktober 2016".
I get the same issue as with the regular indirect forumla, it returns #REF if the workbook is closed.. I have tried other UDFs, but I still get the same issue, and I do not know why..
Any tips on how to easy pull the requested data, without having to have all the workbooks opened at the same time?
:-)