I need help to create VBA code and excel add-ins for complex spreadsheet model
- or -
Post a project like this- Posted:
- Proposals: 11
- Remote
- #1603055
- Completed
Description
Description of requirements/functionality: I have developed a complex model within an excel spreadsheet and it has become very complicated to navigate and requires a higher level of automation and adaption than I can manage.
I need help to create a navigation system that can be managed through an add-in to the excel ribbon. The menu will also need to work with macros which are at present a combination of workbook-specific and personal.xlsb code.
I am looking for help to modify existing code to perform better/smarter and to develop new VBA code to simplify key tasks
I am also looking for the macros to be wrapped up in an add-in .xlam file or similar so that I can provide the add-in to other users.
Specific technologies required: There is no scope at this stage to migrate to another package, the solution I'm looking for must work within MS Excel.
Extra notes: I appreciate this is not a precise brief. I'm proficient in excel but not in VBA so I have a good idea what I want to achieve but am looking for an expert to make a step change in improvement in the way the model works. There may be further development work if we conclude that a major overhaul or shift to another platform is required - I would expect us to handle that separately. In the first instance, a cleaning up of the macros, current VBA code and creating a prototype add-in (ideally with scope to further customise) would be ideal.
We will need to conclude a Non-Disclosure Agreement as part of this commission
Bryan T.
100% (3)New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Without going into to much detail are you able to tell me more about what the spreadsheet does, how many sheets it has, how much code it currently has etc?
It will enable me to make a more realistic proposal in combination with your needs.
Regards
Tony H
PS - What time frame do you have on this project?Bryan T.14 Jun 2017The model calculates the space requirements for academic departments in a university. It must have about 30 worksheets. The code is a combination of macros (recorded and written) by various contributors. I have developed a prototype ribbon menu in another model but I know that it is not portable (it's only available to me) and I also know that some of the macros are not transferable to other models, they only work on the sheet or the book in which they have been created.
Does this help?
Best,
Bryan