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

Vba Jobs

91 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

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

Fixed-Price - Est. Budget: $ 10 Posted
See SEARCH COMANY tab data. How I got this data is a long story the bottom line is that there are duplicates I need removed. Many on the sheet are duplicates some are not duplicates. Only remove duplicates. However you will see a pattern where... There will be duplicate... one row will have all field information with a data.com URL the other will have just a Company and City... REMOVE the COMPANY and CITY row (all other field blank) and NOT the duplicate with the data.com url with populated fields see attached screen shot

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

Hourly - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
The client is an international manufacturer of thermal oil heaters and steam generators, used in the process engineering industry. There is a requirement for the construction of a forecasting model to accurately predict the net mass and value of imports for a list of specified commodities. Import data for the specified commodities has already been consolidated and represented in the form of charts and graphs, being further displayed by country of origin, during the period of 2010 - 2014. The candidate will build a forecasting model using a statistical forecasting model such as SAS, SPSS or similar. Additionally, there is also a requirement to match trader files with the raw import data, in an effort to try and identify who the major importers of the mentioned commodities are, and if possible to identify where the importer is importing the goods from. This should provide useful information as to who the potential customers are in the region, and who the major competitors are.

Fixed-Price - Est. Budget: $ 500 Posted
We have recently done a survey with 85 people, and we have their data in an Excel sheet (85 rows). Each person took 5 photos of their childs lunchbox, and we would like to create a little application which reveals all of the photos relevant if certain filters are selected in Excel (max 5 filters). Ie if we only want to look at the photos from mums in a certain age range, at a certain income level, and whose child is a boy, we should be able to apply the necessary filters, and all photos will appear from any of the 85 respondents who match that criteria. The solution might be Excel based, or another interface. Each image is around 100kb in size and we are looking for a fairly attractive interface. Thanks, Chris
Skills: Excel VBA