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

Vba Jobs

125 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
Fixed-Price - Intermediate ($$) - Est. Budget: $75 - Posted
First, please see the attached file. It is comprised of the following tabs: 1) Sheet 1 2) ENG_Freq 3) RUS_Freq 4) TUR_Freq 5) Master Vocab Tab #5, Master Vocab tab includes a list of around 2,000 words in English, Russian and Turkish. Tab #1, Sheet 1, has a shorter list of a little more than 600 words, only in English. Your first tab is to look at the Master Vocab tab and populate the Russian and Kabardian columns in Sheet 1. You must keep the word order (first column) in the Sheet 1 tab. Once this is done, all of the words in columns C, D and E (Russian, Turkish and Kabardian) will be populated and appear to the right of their English translations. That is Part 1. In Part 2, once Sheet 1 is fully populated, I then need you to populate the frequency ranking of each word in each language. So for example, in Sheet 1, the first word is "long". In the ENG_Freq sheet, "long" has a frequency ranking of 255. So in Sheet 1, keeping "long" where it is, in column H, called ENG_Rank, the value would be 255. In contrast, the Russian translation (which I have already populated manually) has a ranking of 400, and the Turkish translation has a ranking of 195. (There is no Kabardian frequency table to lookup.) I am sure that there is an easy way to do this in Excel that wouldn't take very long, but I don't know how to do it. I need you to accomplish this task and then return the list for me.
Skills: Excel VBA Microsoft Excel
Fixed-Price - Entry Level ($) - Est. Budget: $1,100 - Posted
The Project The basic outline is that they will need a program that can generate cards containing a matrix of colors & letters (similar to bingo cards) and output these "cards" to a printer. An example is attached. Program / Software that: Allows for the creation and printing of the random cards The admin / creation section of the program would include: Ability to change the Letters in the top column Ability to change the Colors that will show up (it will always be 8 colors) Ability to define the number of the horizontal columns Ability to Add a Title to the top of the page, and text info at the bottom of the page Ability to select which "perm" to be printed. We will need 3 different "perms" of 1000 different card faces each. (3000 total different card faces) Each card face will have a unique serial number (0001-3000) Ability to put two card faces on a single page. This can be done in Excel. The way this game is played: A caller speaks a letter and a color to a group of players. The players will "dab" with a marker on the sheet as the caller reads the letter and color. Once a player fills an entire horizontal row they win. For example, the caller would call F-Yellow, and the player would dab a marker on all the Yellow squares in the F row. The caller would continue calling Letter/Colors until a player filled all the spaces in a horizontal row. Once the player fills an entire horizontal row, filling one in each letter column in the same horizontal row, they win the game. When there are 8 horizontal columns, a player can get a horizontal row or a diagonal as a win.
Skills: Excel VBA
Fixed-Price - Entry Level ($) - Est. Budget: $5 - Posted
There is no defined budget at this time. Please make a bid and I will choose the best one. I have an Excel file containing three tabs each with a single column of data. Let's call the tabs 1a, 2a, 3a. Starting with the first row in 1a, look for duplicates in tab 1a and also 2a and 2c. In other words, the search for duplicates will include all three tabs. Continue in sequence through each row of data in 1a, 2a and 3a. Any duplicates found in tab 1a place in new tab 1b. Any non-duplicates found in 1a place in new tab 1c. Do the same for 2a and 3a. The end result will be 9 tabs. Need work finished by tomorrow (Saturday) at the latest.
Skills: Excel VBA Microsoft Excel
Fixed-Price - Expert ($$$) - Est. Budget: $20 - Posted
I want to update a few formulas (subtraction) and then I want modify a sum formula for a few rows (LES Representatives...in the bottom section of the report) with a condition statement. ***must be proficient in VBA, condition statements, and nested formulas
Skills: VBA
Fixed-Price - Entry Level ($) - Est. Budget: $30 - Posted
There are two existing word templates (Word 2007) for default letters. At the headline, our company logo (image) and the address, contact information (textboxes) are visible and a background image are there. At the moment if we generate a PDF, all elements are visible, to have all information inside the PDF. If we are printing documents out, we are "removing" the images, because our paper (in real world) also have the background image and the logo printed. -> Goal of this job is, to add a possibility (e.g. Button) to turn on/off a defined amount of images and textboxes. Please have a look into the PDF. You will see our letter-template. The areas with green-backround must be switched on/off and the red-backgrounded elements must be switched on/off separately (to the green ones)
Skills: VBA Microsoft Office
Hourly - Intermediate ($$) - Est. Time: Less than 1 month, Less than 10 hrs/week - Posted
I am currently looking for 3 expert and experienced freelance tutor only who can teach MS Excel like how to create Macros,professionally how to use in office and all to my USA/UK/Australia based students. How you teach online - Experience in Online field - At what time you can take class - Payment method - can you send me your excel syllabus that you teaches to your student along with course price - Need best price Email id/skype id -
  • Number of freelancers needed: 3
Skills: Excel VBA Microsoft Excel Microsoft Excel PowerPivot VBA
Fixed-Price - Intermediate ($$) - Est. Budget: $300 - Posted
If you are good in: 1) Data Analysis 2) Programming in VBA 3) Strong understanding & application of Excel formula 4) Familiar with basic accounting (cost & revenue) 5) Organizing data 6) Strong in logical thinking Then, you’re on the right track! ... We are looking for people who: • wants to explore their own talents • wants to be recognized for their work • have skills and not fully utilized • are driven out to make money • wants to acquire more knowledge • are workaholic • are not afraid to fail • are eager to upgrade your skill • are looking for full career advancement Skills required: ACCOUNTING & FINANCIAL ANALYSIS We are also looking for other skills like: • Data Analytics • Microsoft Excel VBA • Microsoft Excel PowerPivot
Skills: Excel VBA Accounting Data Analytics Microsoft Excel PowerPivot
Hourly - Intermediate ($$) - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
This project is to figure out why I am getting errors when running a validation script (VBA) in an Excel spreadsheet. When applying, please: * Describe your previous experience with Excel and VBA * Tell me when you can start and finish this project ... When applying, please: * Describe your previous experience with Excel and VBA * Tell me when you can start and finish this project
Skills: Excel VBA Microsoft Excel VBA
Hourly - Entry Level ($) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
I have a PDF document that has a bunch of tables on it. The tables are not consistent, some can have more columns than the other.I need it extracted into an excel sheet preferably csv. Example: column 1 Column 2 column 3 John Doe (818)555-5555 john@email.com column1 Column 2 Column 3 Column 4 Jane Doe (818)444-4444 123 West Blvd. Las Vegas, NV Jane@email .com i would need them appended to each other so the final format should be: Column 1 Column2 column 3 Column 4 John Doe (818)555-5555 john@email.com N/A Jane Doe (818)444-4444 Jane@email .com 123 West Blvd. Las Vegas, NV We will speak more about the project and I can screen share with you to show you the PDf if need be.
Skills: Excel VBA Adobe PDF Data Entry Microsoft Excel
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