VBA Jobs

4,474 were found based on your criteria

  • Fixed-Price – Est. Budget: $200.00 Posted
    Write a vba automation tool to create three .xml output files. Description has to be easy to understand. Tasks: - configure opendialog box to select sheet to be inserted by using output variables consequently displayed in the first tab - insert all these tabs at the push of a button - prompt box if one of the opendialog boxes contains a data path - create a dropdown box to define a year as a variable - delete rows that contain certain terms in certain column ...
  • Fixed-Price – Est. Budget: $50.00 Posted
    I need a simple macro that automates the filling in of a fuel log in Excel. 1. User copies values from expense form and paste them into Worksheet 'Autofill' A7:F32 2. User then clicks "Run Macro" 3. Select two rows at a time from Worksheet 'Autofill' A7:F32 and process them 4. If nominal code = 62010 then move to step 4 otherwise go back to step 1 5. Find first blank row in Worksheet['Return'] - Rows 15 to 29 ...
  • Hourly – Less than 1 week – 30+ hrs/week – Posted
    We are seeking a excel formula expert to expand on a current formula along with answer questions. This is a 1 day task and time is of the essence.
  • Fixed-Price – Est. Budget: $50.00 Posted
    We are looking for a BI/DW expert with excellent writing and/or training and assessment skills to write us 70 practical test questions for our Jr. BI/DW candidates. This is a multiple choice test that should cover the following: 1. T-SQL Programming 2. QlikView Development & Design 3. VB.NET/C#/VBA 4. Database Modeling/Dimensional Modeling 5. SSRS 6. SSAS 7. Excel, Pivot Tables, Power Pivot, Excel Formulas Test requirements: 1. Comprehensive - must include at least 10 questions ...
  • Fixed-Price – Est. Budget: $80.00 Posted
    Microsoft Access 2007 update has caused some reports not to generate, due to a calendar control that has been deprecated. This needs to be replaced with Access's native Calendar. I have the source ACCDB file and it needs to be compiled using Office 2007 back into ACCDE format. Thank you, Owen
  • Fixed-Price – Est. Budget: $150.00 Posted
    create merge documents from our salesforce org grouping horizontal and vertical concatenate I have 5 documents I want to merge data i have half the requirements created for only 2 of the documents.
  • Fixed-Price – Est. Budget: $50.00 Posted
    This is a quick and high paying job offer. Just need a VBA Macro code that can allow to automatically download the financial statements (cashflow, blalance sheet and income statement) of any company ticker that I enter. Source to download from is morningstar.com and advfn.com (previous 5 years data). Download files can be saved on excel worksheet or .csv file
  • Fixed-Price – Est. Budget: $40.00 Posted
    Create an Excel spreadsheet using the Zillow.com data extraction API (http://www.zillow.com/howto/api/GetDeepSearchResults.htm) to extract property information based on addresses provided by the user. User provides a list of addresses within Excel. By running a macro within this spreadsheet, the spradsheet uses zillow.com to extract the following fields and import them into this spreadsheet: - Estimated home value (Zestimate) - Last date sold (if available) - Last purchase price - Property status (currently for sale or not ...
  • Hourly – Less than 1 month – 10-30 hrs/week – Posted
    I want some help to put in place excel connected to an Interactive brokers account . There will be also some development in VBA . Thank you .