The existing Excel Spread sheet has an input data sheet and a calculation sheet to calculate a single total cost depending on five variables. The variables are independent of each other and can be individually optimised to minimise the cost calculation.
This has been optimised by using the solver tool but requires a VBA macro replacement to adjust the five variable cells (4 digits positive numbers) to minimise the value calculated in the cost cell.
The project requires a VBA macro to be written activated by a key stroke. No changes to the spread sheet is required. Once a Freelancer has been chosen, the Excel 2010 spread sheet will be sent for the macro to be added and stating the location of the five variable cells and the cost cell.
To be completed by 19 Nov 2012
26 freelancers are bidding on average $45 for this job
Hi, I am sure I can make the application works as you could imagine. I am a "all the time" 5 stars awarded freelancer and have never failed even for a single project. Feel free to check my profile page.
Hi, I am excellent in VBA and Excel automation tasks. I understand your requirements and can help you with you project. Let me know. I can send you some quick samples for your reference. Thanks, Yogendra