I am looking for an Excel expert who can create a VBA/Macro or AddIn that calculates ROI based on a current format.
Ideally within any spreadsheet/workbook I will be able to click a button, define the "cost" and "revenue" cells and it calculate the ROI and insert it into the cell.
I believe that VBA would be the best way for this, but an Add In may also work.
You can find the Calculate, with comments here: https://www.dropbox.com/s/fx35khyxig8q8fj/ROI%20Calc.xls
I already have some quotes for this work,so have a rough idea of what it will cost and how long it will take here in the UK.
I would expect this to be created and tested fairly quickly.
I would need full instructions on how to work it and install it, also I need to be shown how to edit the code to allow for margin/cost of product increases.