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

Vba Jobs

142 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 - 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
Hourly - Intermediate ($$) - Est. Time: Less than 1 month, 10-30 hrs/week - Posted
I need someone to create a very robust and complex excel spreadsheet. This will require macros and vlookups. This solution will be used to pull data from a raw dump and run it against my open inventory. I am looking for some who is advanced in excel and can help me come up with a creative solution. Must speak fluent english.
Skills: Excel VBA Data mining Microsoft Excel
Fixed-Price - Intermediate ($$) - Est. Budget: $100 - Posted
B2B Lead Generation for Online Web solutions You will bring expertise in gathering ***HIGH Quality*** leads in the b2b market. You will intermediate knowledge of Excel in order to sort data into categories. In return for your talent, we offer you an ongoing monthly contract to work alongside our sales team. If you have 2+ years experience in generating leads online, please apply and we will carefully examine your application.
Skills: Excel VBA B2B Marketing Internet Marketing Lead generation
Fixed-Price - Intermediate ($$) - Est. Budget: $100 - Posted
I have an excel spreadsheet with multiple sheets. The spreadsheet has macros and formulas. I need to be able to have multiple users be able to open up such a spreadsheet and still be able to run the same macros. It also has to print nice and neat onto a regular sheet of paper and legal size paper (depends on the sheet). Here is a link to the spreadsheet: https://www.dropbox.com/s/qtpd3yrql5bimbt/SALE_DAILY_REPORT.xlsm?dl=0 The problem now is that the users may not have the right version of Excel or they may open without enabling macros, etc. and this causes issues. The idea is if there is a solution like Zoho Docs that will be tweaked to allow this spreadsheet to be used. Attached is the spreadsheet. The main thing are the first 3 colored tabs. Users should be able to just input rows of information. The other sheets in the workbook are used as reference. I need someone to be able to convert this spreadsheet, not write a custom database program. Thanks p.s. budget is just a number. Provide me a quote
Skills: Excel VBA Microsoft Excel Spreadsheets Zoho CRM
Hourly - Intermediate ($$) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
I have data, I need automation. I am primarily looking to automate and simplify input, lookup, reporting and dashboards across multiple levels of data (company, employee and products). This would include dashboard creation if possible. - User forms for data input - User forms for data lookup - Multi criteria data lookup and report creation (e.g. widgets sold by company and salesperson) - Dashboards I am running Microsoft Office 365. All of what I have is currently in Excel.
Skills: Excel VBA Data Analytics Microsoft Excel MS Office 365
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