AnsweredAssumed Answered

How to automate upload of multiple Excel workbooks?

Question asked by maximelefevre on Feb 14, 2018
Latest reply on Feb 15, 2018 by rjvkuppeveld

Hi,

 

I'm currently developping a budgeting model at a client. That client has decided to only use Board at the HQ for the time being. This means that subsidiaries don't have access to it and still use Excel templates to submit their annual budget.

The client wants to aggregate those excel in Board and compare them to the actuals.

My question is then how to set up a process so the client can "easily" upload data from all those excel files containing each multiple sheets, blank lines, blank columns,...

Exctracting each sheet to CSV would be too complicated and time consuming.

Is something feasible throught the excel add-in?

 

What would you do?

 

Many thanks!

Maxime

Outcomes