You've landed at the right place. oDesk is now Upwork. Learn about the new platform.

Vba Jobs

146 were found based on your criteria {{ paging.total | number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("hourly") | number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("fixed") | number:0}})
show all
only
only
only
show all
only
only
only
only
only
show all
only
only
only
Looking for the Team App?
Download the New Upwork Team App
Hourly - Expert ($$$) - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
I need you to convert an existing Excel spreadsheet into a new Excel Spreadsheet template. The new template should be modernized and clean and also unprotected. Attached is the old spreadsheet template. In your application please create the first 5 rows/columns of the new spreadsheet and send it to me for my review.
Skills: Excel VBA Financial modeling Microsoft Excel Spreadsheets
Fixed-Price - Intermediate ($$) - Est. Budget: $10 - Posted
I have a ppt template to report the update on 22 projects, which I maintain in an excel sheet. I need to create a macro which creates a ppt from all the information from the excel sheet.
Skills: Excel VBA
Fixed-Price - Entry Level ($) - Est. Budget: $10 - Posted
Need a EXCEL Guru to help me fix rota creation issues I'm having. Need: Someone to analysis my current setup and implement rules so it makes my life easier! Key Skills: * Someone who is good with the Excel =) Job: Easy one for someone in the know! Should take an hour, maybe two MAX Who would take this job? Someone looking for a quick job. Note: This is a trial, if successful there is a LOAD more work coming your way GET IN TOUCH.
Skills: Excel VBA Microsoft Excel
Hourly - Intermediate ($$) - Est. Time: Less than 1 month, Less than 10 hrs/week - Posted
I want to more easily analyze data in either google sheets or excel. The purpose of this project will be to write a program that presents data points that help me to find and evaluate predictable ranges of oscillation and the frequency of that oscillation over time. This is what the program must do: 1) Analyze 1095 columns (3 years of daily numbers) across approximately 7200 individual rows of numbers. 2) Numbers will range in value from 1.00 to 999.99 3) For each individual row of values I need the program to calculate: (a) Round down each number to the nearest .50. For example, 52.77 should be rounded down to 52.50. For example 61.20 should be rounded down to 61.00 (a) the median value of the row (b) the low mode beneath the median in that row (c) the high mode above the median in that row (d) (c) minus (b) (e) the number of times the low mode climbed to the high mode in that row (f) the number of times the high mode declined to the low mode in that row (g the sum of (d)+(e) 4) After the calculations listed in point (3), I will need to be able to sort the data by any columns I wish. Some challenges to consider for points (e) and (f): If for example the values delineated by "," below were adjacent cells in a row, notice that the values that occur in-between the low and high mode do not climb or decline in a linear way, and also sometimes values repeat. The program you write will need to be smart enough to ignore adjacent occurrences of either mode and ignore the data points in-between the low mode and high mode values when determining the number or times the low mode climbed to the high mode, and the high mode declined to the low mode. For example, among the values below if the low mode is 2.00 and the high mode is 8.00 1.50,2.00,2.00,3.50,1.00,4.00,8.50,8.00,7.50,8.00,9.00,6.00,2.50,2.00,1.00,5.00,4.00,8.00 In the above instance: The number of times the low mode climbed to the high mode the program should return the value "2" The number of times the high mode declined to the low mode the program should return the value "1"
Skills: VBA JavaScript Python
Fixed-Price - Expert ($$$) - Est. Budget: $200 - Posted
Prepare an excel file of 20,000 records for upload into database. Combine lists into a master file. Overlay data between duplicate records to create one complete record and remove duplicates. Overlay data from separate excel files onto master file including customer id, sales person name, city, state and zip code, assign salesperson id # to salesperson name, and campaign descriptions from other excel docs. Separate area code from phone column to a separate column and convert any formulas to raw data.
Skills: Excel VBA
Fixed-Price - Intermediate ($$) - Est. Budget: $15 - Posted
I have an excel spreadsheet with a few errors in it that needs to be fixed asap! I literally don't have the time to look at it. Thank you in advance! The instructions are as follows: · Users have been calling stating that last week retail and unit sales for stores 2221, 2222 and 2223 have not been populating. Also the calculation for the custom time period retail sales doesn’t seem to be working for store 1260. Could you please investigate if there is an issue and fix it? Please reply back to this email and attach the “fixed/corrected” spreadsheet. · Also, please provide me with a written detail as to the issues you’ve found within the spreadsheet. · Please look at the spreadsheet in its entirety as there may be additional issues that are not addressed in the instructions.
Skills: Excel VBA Data scraping Microsoft Excel Retail Merchandising
Looking for the Team App?
Download the New Upwork Team App
Fixed Price Budget - ${{ job.amount.amount | number:0 }} to ${{ job.maxAmount.amount | number:0 }} Fixed-Price - Est. Budget: ${{ job.amount.amount | number:0 }} Open to Suggestion Hourly - Est. Time: {{ [job.duration, job.engagement].join(', ') }} - Posted
Skills: {{ skill.prettyName }}
Looking for the Team App?
Download the New Upwork Team App