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

Vba Jobs

87 were found based on your criteria

show all
show all
only
only
only
show all
only
only
only
only
only
show all
only
only
only

Fixed-Price - Est. Budget: $ 280 Posted
We need someone to take 90 HUGE spreadsheets with approximately 60,000 to 100,000 rows on each spreadsheet (and up to 25 columns of data on each row), and sort and filter that data into approximately 40-45 different categories, as well as clean it up from unwanted data. In order to find the right data you will need to enter on average 5 to 10 keywords, (sometimes more and sometimes less), in the main column to find all the relevant data for that category of keywords. After you have filtered and combined the data from the 90 spreadsheets (90 days of data) into 40-45 much smaller spreadsheets, that are categorized for the relevant keywords, you will need to filter out approximately 50% of the data that is unwanted. You will need to do this for each of the 40-45 spreadsheets and then send them all back to us, (upload via dropbox), filtered, sorted and cleaned up. A couple of important things: 1. We want this done ASAP, so unless you are ready to start working on this straight...

Hourly - Est. Time: More than 6 months, 30+ hrs/week - Posted
TYPICAL ACTIVITIES include 1 - Transformation of address data from Websites to Excel (e.g. scraping) 2 - Deduplicationand Extensive cleaning & formatting of address data in Excel 3. Verification REQUIRED SKILLS - Very experienced in working with MS Excel spreadsheets - Quick in applying Excel Formulas including VLookup and all sort of string formulas - Comprehensive understanding of VBA - Familiar with UTF-8 encoding - English communication - Be responsive, flexible and draw EXTREME attention to detail PLUS - Any of the following skills is a plus - Databases like MySQL and MS Access - Silenium Web Driver - Software Engineering Skills

Hourly - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
I require a VBA code which will look up the files within a directory and create a hyperlink to an appropriate row in my excel spreadsheet. The excel spreadsheet has a column with a Job number, e.g. E3279. In a column to the right of it, I need a hyperlink to an external spreadsheet. The external spreadsheet has the reference Job number within its file name, e.g. CWI001-CA-E3279. Please note: -If needed, a list of the files within the directory can be stored in a hidden sheet. -use the directory file path "C:\Users\Maria\Documents". I can update as required. -Files are added to this folder a few times a week, so the directory list needs to automatically update each time the spreadsheet is opened. -External spread sheets are both .xls or .xlxs I have uploaded an example speadsheet which has the columns of interest highlighted in green and yellow.

Hourly - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
We are in need of a expert in Excel VB/Macros. We would like some automation within a spreadsheet to populate worksheets based on other worksheets.
Skills: Excel VBA

Hourly - Est. Time: Less than 1 month, 10-30 hrs/week - Posted
This is for a construction company. I need to have designed, an excel spreadsheet, a program.... or a webpage, that can be taken with an estimator to a customers home when providing a quotation and allow the estimator to simply punch in the dimensions of the project and have this program/spreadsheet automatically calculate and present everything. I would like this 1 program/spreadsheet to streamline several processes: 1. A quoted price and graphically presentable quote to be generated, able to be printed, signed and used as a contract. The price and items included would autopopulate based on the measurements and add-ons selected 2. allowing the customer or estimator to adjust that price by simply selecting different available add-ons and upgrades (which would vary in price based on the measurements and dimensions input) 3. creating a material list based off of these input dimensions and measurements 4. creating a cost of materials and labour based on dimensions and measurements 5....

Hourly - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
I want an expert in using excel and developing scripts in VBA to enhance the overall functionaility and features of an existing sheet. Please apply only if you: 1- Have previous examples for your work 2- Have a Strong internet connection as we are going to have a frequent Skype calls.

Hourly - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
We have 2 different CSV files each of them have similar column structure. CSV_1 (Suppliers data feed): Column1:Product ID Column2:Product title Column3:Product price Column4:Product shipping fee Column5:Product Image URL This file may have up to 500,000 items (Rows) CSV_2 (our woocommerce store data feed): Column1:Product ID Column2:Product title Column3:Product price Column4:Product shipping fee Column5:Product Image URL This file may have up to 100,000 items (Rows) You have to write a script to search an find same, similar, closest match titles between the both files and for those matched items you must compare the price and calculate the profit and profit margin and output in 3rd file (lets call it output data file) where we can see all matched items with potential profits. You basically only need to look at Column2:Product title Column3:Product price Column4:Product shipping fee to make the calculation. I hope its clear. I will send you sample data if...

Fixed-Price - Est. Budget: $ 20 Posted
I have a spreadsheet with some file names in 1 column. Some cells have more than 1 file name, separated by "/" The job is to separate each file name into its own cell. I'm looking for somebody who's able to code a small VBA script to take care of this job. Note: I do not need the script. I only need the result. This job is urgent and I do need this by today so please apply only if you have the time to do this.

Hourly - Est. Time: Less than 1 month, Less than 10 hrs/week - Posted
The main goal is to develop an Selenium WebDriver macro built in the predefined excel file which would be supplied. The macro would scrape the data from the desired website with dynamic content and put it in the desired sheet in the workbook. The other part of the task would be to develop the simple VB macro which would sort out the source date scraped from the website to the desired sheets in the desired form and format.

Hourly - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
I have an assignment that is due after three hr can anyone help me with it? thanks