Updating links of Excel files (60) without having to open them (VBA solution?)
- or -
Post a project like this$200
- Posted:
- Proposals: 15
- Remote
- #525359
- Expired
VBA/SQL/Python Developer (Excel/Access/Python) - Automation, Reporting, Data Science
London
112677177369251965300596351470421463553231599681621271693044693167698710
Description
Experience Level: Expert
Got a finance model that I inherited with 60 files that feeds into one file. Data flow is:
Operating Assumptions==>per restaurant/year performance (each file per year/unit with ten units and six years)==>Consolidated Financial Model. All works fine, however I need to open all 60 (very heavy) files if I want run scenarios. Any way to fix this? VBA? Could give you access via Dropbox if needed. Only for parties who are familiar with the problem (countif, sumif, rank) and are confident to fix this swiftly. Thanks, Urban
Operating Assumptions==>per restaurant/year performance (each file per year/unit with ten units and six years)==>Consolidated Financial Model. All works fine, however I need to open all 60 (very heavy) files if I want run scenarios. Any way to fix this? VBA? Could give you access via Dropbox if needed. Only for parties who are familiar with the problem (countif, sumif, rank) and are confident to fix this swiftly. Thanks, Urban
Urban S.
100% (3)Projects Completed
3
Freelancers worked with
3
Projects awarded
15%
Last project
17 Nov 2022
Switzerland
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies