You will need to create a Macro/Visual Basic program that must be executable from the command line (the goal is to be executable from a Python script) and that would take as an argument a directory containing a hierarchy of simple Excel files that should be processed to create one simple Excel Report. It does not involve manipulating or changing the data, but just formatting it, adding text, etc.
More specifically, the program should assemble the Excel files into one Excel file, splitting the data into Tabs and adding some descriptive texts, converting dates into the proper Excel Date Format that can be filtered upon and changing some colors/doing some formating related stuff).
Further and precise details will be given upon starting the project.
14 freelancers are bidding on average €36 for this job
Hello, I'd be glad to create a python script that assembles the excel files instead of doing it with macros then calling it from python . Looking forward to chat with you soon for more details. Best regards,