Excel Vba Jobs

196 were found based on your criteria {{ paging.total|number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("0")|number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("1")|number:0}})
Hourly - Intermediate ($$) - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
One of the shipping providers my company uses hosts a web service to issue shipping quotes in SOAP format. I have coded some scraping utilities for a Google API and another which parse XML, but I am having trouble with this one. I need to be able to specify parameters in Excel cells, get shipping quotes in XML, parse the data, and populate cells in Excel with the data. I expect this to take no more than 2 hours of an expert's time since I can do most of the coding and debugging with an expert's help.
Skills: Excel VBA API Development Data scraping Microsoft Excel
Hourly - Entry Level ($) - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
Our free lancer will need to: -- complete a non-disclosure -- De-duplicate and clean up a mess! If I have one email with 4 names, a riddle needs to be solved, sometimes the answer is easy and obvious and sometimes there is a challenge. -- Our new data into a new excel file that separates first and last names, and we will need them to keep people in the correct list :)
Skills: Excel VBA Data Entry Spreadsheets
Hourly - Entry Level ($) - Est. Time: Less than 1 week, Less than 10 hrs/week - Posted
I have endless data and various master templates...I would like someone to make a program or xml or macro that would enable me to simply take the excel file that I want to upload and map the column names to the template that is necessary for the upload. Let's start with an easy option. Attached, I have a .csv that has two tabs...the program I use requires the column names to be what is listed on the template....the first tab is what I want to import. So I would like a macro or a XML or a program or whatever to do this... This is an easy one...I have much more complicated ones...but want someone who is really good and fast who can make this. I can even define what fields go where...maybe this is a query? Not sure...maybe I am making this more complicated then it needs to be :) I use many products that are awesome...like google apps fusion sheets etc....I would like to start small with someone and grow over time with a really robust user friendly system...
Skills: Excel VBA BigQuery Google Apps IMacros
Fixed-Price - Expert ($$$) - Est. Budget: $27 - Posted
I am looking for an expert in the domain of Data analytics using Excel. Good knowledge of using Analysis ToolPak for excel. Experience with broad suite of statistical methods, including logistic regression, factor analysis, clustering techniques, design of experiment, and others I am also looking for someone who will be available on Friday 28th from 5pm EST -8 pm EST
Skills: Excel VBA Microsoft Excel
Hourly - Intermediate ($$) - Est. Time: Less than 1 week, 10-30 hrs/week - Posted
I have excel sheets I produce that populate the same information over many rows. I am running Excel for Mac 2011 version 14.5.9 For the format layout - I would like to paste the data into the macro sheet and have a "Run" button to process the macro. I need a macro written that can do the following: 1. Remove Duplicate Data within a range 2. Extract a category ID most used within a range 3. Reformat the data into a structure I need. I have attached a sample csv file with the data. Column A - is the range (Range is based on the same number or value, not the entire column) Column C - Extract Category ID most used within Range of Column A Column D & E - Remove Duplicates within Range of Column A Column D - Number duplicate values 1,2,3,4,5 etc... Results Column Example (This can be in a separate worksheet if needed) Column H - Re-paste the Value of Column A Column I - Paste Most used CategoryID Column J - Merge into one cell separated by colons : and space bars |
Skills: Excel VBA IMacros Microsoft Excel
Fixed-Price - Intermediate ($$) - Est. Budget: $35 - Posted
My job is really elementary for anyone who knows signal processing. It is within one week job. I have carried out some measurements using Carlson radio (CPE) for SNR, Traffic and Errors per second. I want to calculate the BER, draw a CDF and CCDF graphs using the data read off the CPE. For any one interested, I can always be asked questions for clarity. The graph of all the seven locations is expected for DL, UL of SNR, Traffic and Errors. (BER = Bit Error Rate, CPE = Customer Premese Equipment, SNR = Signal-to-Noise Ratio, CCDF = Complementary Cumulative Distribution Function, DL = Downlink while UL = Uplink) Use my data to plot a CCDF graph using Excel/matlab.
Skills: Excel VBA Graphic design Internet research Microsoft Excel