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

Vba Jobs

93 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 month, Less than 10 hrs/week - Posted
We are looking for someone to code a document assembly application. Our documents are currently written in Word, with data drawn from an Excel spreadsheet and other text drawn from other Word documents. The task is to build a Word template using XML that will automate the process of assembling text, data (from Excel) and images into a final document. The tool would then convert the document into a pdf, attach it to a customized email (in Outlook), and mail it. There would be provisions along the way for some on-the-fly customization, along with saving and editing the document. For an explanation of the type of application we want to build and the skills required, please see: https://msdn.microsoft.com/en-us/library/office/ff433638(v=office.14).aspx. We propose to start the project with a template for job proposals.
Hourly - Est. Time: More than 6 months, 10-30 hrs/week - Posted
Are You The Worlds Greatest Excel Expert and Google Analytics Specialist? ***You must have previous experience doing reporting reconciliation for Google Analytics, Google Adsense, and Facebook. Job Duties Include But Are Not Limited To: Pulling Reports From Google Analytics, Yahoo, and Facebook Reconciling These Reports To Show ROI For Ad Campaigns Automating This Entire Process With The Use Of Macros Or Whatever You Recommend Organizing Custom Reports In Google Analytics. Google Adsense, and Facebook This is a part time position now with the ability to quickly turn into full time position quickly if performance warrants it. ***MUST be available to work weekends from the hours of 6AM to 11AM PST Thursday - Sunday for a total of 20 hours per week.*** When applying for this position please tell me your favorite movie and copy and paste the following statement if you agree to the terms it mentions: Yes I am available to work 6AM - 11AM Thursday - Sunday for a total...
Hourly - Est. Time: More than 6 months, 10-30 hrs/week - Posted
Are You The Worlds Greatest Excel Expert and Google Analytics Specialist? ***You must have previous experience doing reporting reconciliation for Google Analytics, Google Adsense, and Facebook. Job Duties Include But Are Not Limited To: Pulling Reports From Google Analytics, Yahoo, and Facebook Reconciling These Reports To Show ROI For Ad Campaigns Automating This Entire Process With The Use Of Macros Or Whatever You Recommend Organizing Custom Reports In Google Analytics. Google Adsense, and Facebook This is a part time position now with the ability to quickly turn into full time position quickly if performance warrants it. ***MUST be available to work weekends from the hours of 6AM to 11AM PST Thursday - Sunday for a total of 20 hours per week.*** When applying for this position please tell me your favorite movie and copy and paste the following statement if you agree to the terms it mentions: Yes I am available to work 6AM - 11AM Thursday - Sunday for a total...
Fixed-Price - Est. Budget: $ 20 Posted
I have an Excel file that stores multiple values for a field as comma separated values within a cell. I need to have the data normalized such that the single sheet containing all the data gets broken out in to several sheets (i.e. tables) that contain make the data relational. Specifically, one column contains multiple categories and one column contains multiple emails. I need this such that we give ids to businesses and ids to unique categories, add a join table to show the relationship between tables and categories. Then, I need another table that has one row per email per business. I've attached a sample of how the data will look. Essentially the first sheet is what I'll give you, and the format of the output will be like the next four sheets. There will be approximately 500,000 rows in total, so obviously this needs to be done programmatically. Thanks.
Hourly - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
I need raw data to be transposed into dynamically created and named sheets within one workbook based on unique values in one particular column (column O in the raw data tab) . By unique, I mean if there is more than one of the same value, the multiples should be transposed into one sheet; not multiple sheets. The tabs of the sheets will need to be renamed based on the unique value. Within each sheet, rows can be infidelity long depending on the raw data. Every other row should be highlighted (white, background 1, darker 15%) The number of sheets also depends on the data, but will always be under 35. Vlookup function or similar formula will be used as well to calculate a few fields. The columns should span automatically to adjust based on data string sizes. Upon printing, the 3 sections (A:H, J:V and X:AE) need to print on separate sheets of paper and need to each be one page wide by how ever many long is needed. Tabs in the sheet attached: Raw data: this is where we...
Skills: Excel VBA
Hourly - Est. Time: 1 to 3 months, Less than 10 hrs/week - Posted
Need to take an existing Microsoft Access program (Wastewater) and add new features
Skills: VBA
Hourly - Est. Time: 1 to 3 months, 30+ hrs/week - Posted
We need an Excel VBA Macro developer to migrate a set of Excel macros from one data source to another data source. We have a set of macros built over a specific data source. This data source is changing and the new data will come in with different formats and layouts. This job had been posted before but the client had issues getting the specs ready. This is now done for the first workbook and this is their highest priority now. This project will start immediately (aug 10) or as close to this date as possible. We need to: 1. determining the current behavior of existing macros 2. rework or rewrite these existing macros to produce the same output from a new data source 3. Meet on a regular basis to ensure and track how requirements are being met. The client with whom you are working will want to be able to video and screen share during these meetings as the new data formats are being corrected. Would prefer someone who is available during Pacific Time during work...
Skills: VBA
Fixed-Price - Est. Budget: $ 50 Posted
Hi everyone, I want a php application that's able to retreive dimension & weight data from internet sources. These sources are XXXXX and the manufacturer website or pdf catalog depending of the product. The dimension are expressed in mm and the weight in gramme, if it's not the case you've got to convert them. There are over thousand products and I provide name, ean & mpn for each one of them in an excel file. So for each source, I want the information found. If there are more than 1 product, you have to concatenate ean & mpn, like ean_mpn, to reduce the result number. For verification purpose, I also want the source link. I also provide a vba script already been used in part for that case, so you free to inspire yourself.