1. Create a macro/VBA to open excel spreadsheets from a zipped file
2. Apply formula (I already know this formula, just need to add to macro)
3. Create a formula to index/match the calculation from step 2 into another spreadsheet.
19 freelancers are bidding on average $28 for this job
Dear Client I can do this task. I have previously carried out a number of projects in excel using vba macro and formulas. Kindly contact me for further details. Roy
I have experience in Excel, VB, VB.net, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Relevant Skills and Experience EXCEL VBA Proposed Milestones $30 USD - exc
Hi.I can start the work right now and can deliver you in a couple of [url removed, login to view] me please Relevant Skills and Experience I have been doing VBA projects only as am well versed in [url removed, login to view] have a look at my profile. Flere
I have 25 years experience in Excel and an extensive technical and programming background. The toughest part is opening a workbook from a zip file, which I have already done and have the code for.