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 freelancere byder i gennemsnit $28 på dette 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
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.