Save this Search
     

All JobsExcel Macro

 (25 results)  
Sort by:
  • Posted Date
Results for 'Excel Macro'
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: 3h, 56m ago  |  Ends: 14d, 20h  |   7 Proposals
Requirements o Proficient knowledge of Excel including: creating and formatting spreadsheets, pivot tables, macros and circular formulas, as well as sorting and filtering data o Proficient knowledge of Internet Engines including: ability to research a question or general topic and ability to create a Word document report to summarize findings o A basic understand of importing and exporting to and from Excel into other applications o Ability to handle conflicting priorities and demands o Ability to work at a specific location o Versatile availability
Category: Software Application       

K****015
 [?]
Sign in to view client's details.
| K****015
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: 16h, 19m ago  |  Ends: 2d, 7h  |   19 Proposals
I have 2 macros that I need to fix. for the first one I need to extract only certain cells for several Excel books to create a new workbook. for the second one I need to format several Excel workbooks with coordinates and save the file as .dat, also I would like it to make an .xml file at the same time.
Category: Data Analysis       
Skills: Excel VBA       

s****357
 [?]
Sign in to view client's details.
| s****357
|    United States
Fixed Price: Less than $500   |  Posted: 17h, 21m ago  |  Ends: 14d, 6h  |   4 Proposals
Need to build a portfolio monitor for stocks et c. that retrieves info from various web sites. Stocks listed are held but need to be monitored daily
Category: Database Administration       
Skills: .NET Compact Framework, Excel VBA       

m****138
 [?]
Sign in to view client's details.
| m****138
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Aug 03, 2015  |  Ends: 13d, 13h  |   7 Proposals
Seeking high caliber MS Excel specialist. On a project basis, I'm looking for somebody to transform existing workbooks into applications for business rather than merely a data repository. Experience should be demonstrated in user interfaces VBA macros, pivot tables, interactive reports, and the like. Strong preference will be given to individuals/companies who also have demonstrated experience in statistical analysis. Must be local to Denver, CO/Front Range area and willing to sign an upfront NDA.
Category: Data Analysis       
Preferred Location: United States

b****ley
 [?]
Sign in to view client's details.
| b****ley
|    United States
Hourly Rate: Not Sure   |  Duration: 1-2 weeks  |  Posted: Aug 03, 2015  |  Ends: 13d, 5h  |   11 Proposals
We need your help with debugging an Excel Macro. The Macro works fine on Windows versions of Excel, and on the Excel 2011 for Mac version. Since upgrading to Excel 2016 for Mac, there is a syntax error:   [obscured]  /l/AGNrXAxeLpNC4LB7mvZ6kyOr_rfjYThrBCs Are you able to help?
Category: Other IT & Programming       
Skills: Microsoft Excel, VBA, Excel VBA       

l****tte
 [?]
Sign in to view client's details.
| l****tte
|    Switzerland
Fixed Price: Less than $500   |  Posted: Aug 02, 2015  |  Ends: 11d, 20h  |   6 Proposals
We have a requirement to call R scripts using VBA macros. We are looking for expert to do small assignment for us. Right person can start today itself. We are also open to take your existing executable script.
Category: Data Analysis       
Skills: Excel VBA, R statistics       

N****ics
 [?]
Sign in to view client's details.
| N****ics
|    India
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 29, 2015  |  Ends: 8d, 6h  |   11 Proposals
Using hyperlinks in column A, pull two specific data points from each webpage. The approximate number of webpages would be 350-500. The webpages are identical format, just with different data points. Ideally, the Macro would establish a loop so that after pulling the two data points from the first row, automatically move on to the next row to perform the same task. It is not necessary for the webpage to remain open. Separately, using property addresses in two columns (address, state) pull in information provided by the API information provided by   [obscured]   They provided an API ID where the the API information desired is identified and associated with the account. Able to provide API ID once needed. It is possible no results are available as the information is not enough to search - this is expected. Examples of the two requests are included in the excel workbook attached. One tab has the data for the Macro Loop and the other has the property information for the Zillow...
Category: Data Entry       

s****ga6
 [?]
Sign in to view client's details.
| s****ga6
|    United States
Fixed Price: Less than $500   |  Posted: Jul 29, 2015  |  Ends: 8d, 5h  |   5 Proposals
Seeking to find an individual to complete and / or enhance the existing Excel Automated Stock Trading System. Here is a link to the file already purchased and in my possession:   [obscured]  -edu.com/StockCourse.htm The individual for this project should be well versed in financial mathematics, technical analysis, algorithms and back-testing valuations for pricing options. Such as the most common method of using the Black-Scholes Option Pricing Formula. I would like to open a discussion on if 'the Greeks' should be added and also if 'implied volatility' should be added as well. Prior to diving into the project, I want to make sure that all areas are being touched upon. Must be familiar with: - Building Indicator Formulas (short term and long term positions) - Building the Directory and File Structure / Spreadsheet Structure - Visual Basic - Macro Code - Back-testing Please provide your background, education and a realistic cost on how you are able to add value to this proj...
Category: Investment Analysis       
Skills: Algorithms, Technical Analysis, back-testing       

d****710
 [?]
Sign in to view client's details.
| d****710
|    United States
Hourly Rate: $20 - $30 / hr   |  Duration: 1-2 weeks  |  Posted: Jul 28, 2015  |  Ends: 7d, 6h  |   35 Proposals
This is a short project to build out some macros to enhance some files I'm working on. I will provide you with the files and we can discuss on skype to give you insight into what I'm looking for exactly.
Category: Data Analysis       

M****gis
 [?]
Sign in to view client's details.
| M****gis
|    United States
Hourly Rate: $20 - $30 / hr   |  Duration: 1-2 weeks  |  Posted: Jul 28, 2015  |  Ends: 7d, 6h  |   7 Proposals
This is a short project to build out some macros to enhance some files I'm working on. I will provide you with the files and we can discuss on skype to give you insight into what I'm looking for exactly.
Category: Data Analysis       

M****gis
 [?]
Sign in to view client's details.
| M****gis
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 27, 2015  |  Ends: 6d, 6h  |   11 Proposals
I am looking to use quickbooks to help manage ordering inventory. We have a system worked out for this, but it is mainly a manual process. We have 1000s of skus so the more automation the better. goal: To make ordering product as quick and easy as possible based on inventory minimums and case minimums for order. process: would like to auto-generate a report on certain dates. This report should show which products are at their minimum for inventory, then auto-generate an invoice that we can approve and send to our vendor. We also need to account for minimum case quantities. example: pull a report for a product with 400 sku numbers. minimum quantities ranging from 10-40 pieces each sku. if a product reaches its minimum (e.g. 15 pieces) then it will put this product on the report that it is below min threshold. We can then generate an invoice automatically. This would account for the fact that this product comes with ordering in quantities of 20 at a time. We should also account ...
Category: Data Analysis       

m****esi
 [?]
Sign in to view client's details.
| m****esi
|    United States
Fixed Price: $75 or less   |  Posted: Jul 23, 2015  |  Ends: 2d, 15h  |   14 Proposals
I receive a weekly report, which is a list of fuel charges. I need to format and summarize the report. I have attached a workbook with 2 sheets in the workbook. Sheet 1 is the raw data and sheet 2 is the summary report I need created with VBA. I need to loop through each line of data and classify the charge. I want to copy certain columns of the raw data on sheet 1 to the summary table on sheet two starting on line 17. For each tail number in the list I need to add this tail number to the summary area in green on sheet 2 starting with column B, row 4. Then the next tail number would go in column C, row 4 and so on. Next, I need to determine if the cost is a fuel cost or an ad hoc cost. Each line can only be either fuel or an ad hoc cost and the line amount in column S of sheet 1, the raw data sheet, will be the cell transferred to either column H or column I of sheet 2. If column P of the raw data sheet states USG then this is a fuel charge and the amount listed in column S ne...
Category: Software Application       
Skills: Visual Basic       

c****254
 [?]
Sign in to view client's details.
| c****254
|    United States
Fixed Price: Less than $500   |  Posted: Jul 23, 2015  |  Ends: 2d, 2h  |   8 Proposals
It's a simple task. You need to develop a macro which should copy each and every URL in a particular column and paste it in the browser and then copies the first image from the browser and paste it in the excel sheet. In the attached sheet, I have copied the image from the website and pasted it back in the excel. I need this to be automated so that I can repeat the exercise for thoussands of URLs. Thanks! Dipesh
Category: Web Programming       
Skills: MySQL Administration, HTML, PHP       

T****WAT
 [?]
Sign in to view client's details.
| T****WAT
|    India
Fixed Price: Less than $500   |  Posted: Jul 22, 2015  |  Ends: 1d, 16h  |   21 Proposals
I have an XPA ledger with account balances (Open in Microsoft Access to see the ledger database) I want to be able to run a macro in Excel VBA which Opens and reads the database and exports data from the 'Balances' table to an excel sheet (like the attached Output File, except formatting is not necessary) See example Database and Excel Output attached.
Category: Data Engineering       
Skills: Database, Excel VBA       

T****on2
 [?]
Sign in to view client's details.
| T****on2
|    Australia
Fixed Price: $50 - $250   |  Posted: Jul 22, 2015  |  Ends: 1d, 13h  |   10 Proposals
I will need someone to write a macro that will enable to those task: - Go in to   [obscured]  /NYCServWeb/NYCSERVMain - Select search - Scrap data from excel Spread sheet: *plate # *State *Select all type then press search. If no result found macro should register no result under a new exel spread sheet a front of the plate. If result shown scrap all data available into the column of the extract spreadsheet i can over the detail and show what i need.. I need something that works well.   [obscured]  /user/api/newrecaptcha
Category: Software Application       
Skills: C, .NET Framework, Python, IMacros       

d****eur
 [?]
Sign in to view client's details.
| d****eur *
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 22, 2015  |  Ends: 1d, 7h  |   9 Proposals
Hi, We are looking for an experienced MS Excel 2013 Technician for a short project. The successful candidate must have excellent knowledge of VBA and Macro programming. The project has to do with the following: - Design of the Excel Sheet Background - Set Up Email Reminders according to dates entered in the Excel Sheet - Exportation of data and Importation in another workbook via i-Cloud - Set Up LookUp functions - Set Up Hyperlinks connected to an iCloud Database of pdf files - Insertion of Save Button Only quotes where sample of relevant experience will be considered.
Category: Other IT & Programming       
Skills: HTML, PHP, VBA, Excel VBA, Excel Macro       

G****s89
 [?]
Sign in to view client's details.
| G****s89
|    Greece
Hourly Rate: $20 - $30 / hr   |  Duration: Not Sure  |  Posted: Jul 21, 2015  |  Ends: 14h, 58m  |   12 Proposals
Firstly, above all, you must be available to speak on the phone during US business hours (Skype OK) and perform multiple revisions within the same business day, adhere to deadlines, and/or remain on a live call for an extended period of time to complete a project on the spot. Small ecommerce business with 100K+ skus seeks long-term relationship with excel guru who will become familiar with data scheme and perform the following: 1. Create a mostly automated multiple-step monthly process to execute regular pricing updates into a consolidated eCommerce-ready format... -use data from multiple supplier excel sheets in different formats -create sku numbers that are composites of supplier sku's and mfr part numbers -use business rules that will select best supplier based on price of same item with similar sku -analyze pricing increases and supplier preference based on different suppliers data -identify new items from existing vendors and reformat to create properly formatted product cata...
Category: Database Administration       

b****unt
 [?]
Sign in to view client's details.
| b****unt
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 21, 2015  |  Ends: 11h, 37m  |   4 Proposals
Macro should be doing some auto filtering options based on several different columns of data and display all the wanted data nice and clean Only if you have significant experience with "Smartsheet" and API programmatic access to Smartsheet features and data using common open and widely accepted standards, including REST for access, JSON format for the data, and OAuth for Authentication and Authorization. Please let me know if your interested in this Task
Category: Other IT & Programming       

p****roa
 [?]
Sign in to view client's details.
| p****roa
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 21, 2015  |  Ends: 8h, 11m  |   37 Proposals
Hello! I work for a bakery (We Take The Cake). We ship our cakes all over the U.S. We are using a new system to process our orders (Nexternal). We export the orders into an Excel spread sheet, but it is too messy for ShipStation (the tool we use to print shipping labels). I've attached the file. There are 3 spread sheets in it. The sheet called "Line Items" has most of the info that we need for ShipStation. We just need to get the Billing First and Billing Last names from the Orders sheet onto the Line item sheet. This is complex because you'll notice that there aren't enough billing names to match up with the orders on the line items page. This is because the same person may order multiple items, and the Line Items file breaks it down by order, where the Orders file breaks it down by orders that may contain multiple items. We also need to delete the rows that say "sales tax" and "shipping method..." under the Items column. All dollar signs need to b...
Category: Other IT & Programming       
Skills: Excel VBA       

j****ake
 [?]
Sign in to view client's details.
| j****ake
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jul 21, 2015  |  Ends: 5h, 18m  |   33 Proposals
I have a report (csv file) that will be created every morning. I need to take that exported file and create a new file with our formatting. This should be a simple task where the client opens the csv file hits process and has the new file ready for import (quick books) We will provide a sample export and a sample of the file we want created.
Category: Other IT & Programming       
Skills: Microsoft Excel       

y****net
 [?]
Sign in to view client's details.
| y****net
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Jun 05, 2015  |  Ends: 28d, 22h  |   6 Proposals
Hi We are looking for Excel trainer. Do you provide Excel and Macro training in Singapore. Thanks Alfred
Category: Other IT & Programming       
Skills: HTML, PHP, VBA       
Preferred Location: Singapore

t****ech
 [?]
Sign in to view client's details.
| t****ech *
|    Singapore
Symbol Key
Payment method not yet verified
Payment verified
Purchased $1-$500
Purchased $500-$5,000
Purchased more than $5,000
You have already submitted a
proposal to this job