Save this Search
     

All JobsVBA

 (57 results)  
Sort by:
  • Posted Date
Results for 'VBA'
Hourly Rate: $15 - $20 / hr   |  Duration: Not Sure  |  Posted: 7h, 31m ago  |  Ends: 14d, 15h  |   13 Proposals
Hello, We need help coding some macros into an Excel document that will be used to launch marketing campaigns. The bulk of the work will entail developing tables that change based on what a user chooses as an option in a drop down menu. Please inquire if you'd like more info, I estimate 2-3 hours of coding with a due date of EOD 3/1/15. Thanks!
Category: Other IT & Programming       
Skills: Microsoft Excel, VBA       

j****180
 [?]
Sign in to view client's details.
| j****180
|    United States
Fixed Price: Not Sure   |  Posted: 13h, 48m ago  |  Ends: 14d, 9h  |   3 Proposals
Title: Sr SharePoint Developer Duration: 6 Months Location: Jersey City, NJ Job Description: ? Assisting the business with tactical demands including the creation or maintenance of user tools ? The migration of existing user tools into a better control environment leveraging Sharepoint ? The creation and maintenance of that better control environment Required Qualifications: ? Sharepoint and Sharepoint Designer ? Advanced Excel ? Access ? SQL ? VBA ? At least one general purpose language (e.g. JavaScript or Python) Skills & Experience ? 5-7 years of experience as a SharePoint Developer ? Experience with C# ? Experience with JavaScript ? Relational Database experience (Oracle, SQL) ? High sense of urgency ? 2+ years in a RAD capacity preferred. Will consider new Grads.
Category: Other IT & Programming       

c****MIT
 [?]
Sign in to view client's details.
| c****MIT
|    India
Fixed Price: About $20   |  Posted: 18h, 48m ago  |  Ends: 14d, 4h  |   0 Proposals
need to edit excel macro and change the code to below foremate ? In candidate name the info given after the (-) hyphen is the last name ? Candidate code -- after first 2 digits the following 4 digits in form number is the candidate code. ? Only in candidate objective anywhere after full stop use double space (^^) (not in the end) ? After comma (,) put double space (^^) wherever it appears except. 1. AOE 2. Work experience 3. Institution last attended 4. Operating systems 5. Achievements 6.qualification 7. Percentage 8. Strengths ? Leave no space before & after hyphen (-) in any condition ? Leave space before & after (:) in any condition ? Add text formatting in the following fields. (these are compulsory). 1. Candidate code <B>info<B> 2. Candidate name <R>info<R> ...
Category: Other IT & Programming       
Skills: Microsoft Excel, VBA, excel vb, macro       

s****ons
 [?]
Sign in to view client's details.
| s****ons
|    India
Fixed Price: Not Sure   |  Posted: 18h, 52m ago  |  Ends: 14d, 4h  |   3 Proposals
I want a working function code to copy paste in a personal excell VBA program. The function must access the web services of the web site brickset.com and get some data. Input data: SetNumber Returned data: theme, subtheme, pieces, minifigs, ... still to be concreted. Probably returned via an object.
Category: Software Application       
Skills: VBA, xml Web Services       

D****l73
 [?]
Sign in to view client's details.
| D****l73
|    Spain
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Feb 26, 2015  |  Ends: 13d, 22h  |   5 Proposals
We are looking for VBA Developer who are very strong and can independently work on C# , ASP .NET and MS SQL Server. Resource should be able to start within 1 to 2 weeks at max Apart from technical competencies the resources should be very good in communication skill as they have to work independently with end customers. PFA JD
Category: Web Programming       

l****ham
 [?]
Sign in to view client's details.
| l****ham
|    India
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Feb 25, 2015  |  Ends: 13d, 16h  |   15 Proposals
We are a small real estate firm with clients seeking new business sites. We need an Excel/Access application that takes two data arrays of street addresses in the United States, geocodes each address, and then calculates distances between each address. Each data array could consist of up to 2000 street address Job Description: We're looking for a talented Application Developer to create native applications for our business. Your responsibilities: - Review business requirements and perform a technical analysis of requirements - Create development strategies, structure and architecture for our applications - Write clean, modular, robust code to implement the desired requirements - Research current and developing technologies and integrate into applications as necessary - Write documentation or resources for the application if required - Understand and adhere to all customer or client policies and procedures Your qualifications: - A work style that is extremely detail ori...
Category: Software Application       

J****ver
 [?]
Sign in to view client's details.
| J****ver
|    United States
Fixed Price: Not Sure   |  Posted: Feb 25, 2015  |  Ends: 13d, 8h  |   6 Proposals
We have a WordPerfect document that has 4 user scripts for our group department for group contracts. We would like to update this to a Microsoft Word template. the four scripts work as follows: Script one - Advances the Date. Script two - Copies the hotel rate line. Scrip three - Amortizes the rate based upon a passenger count range. Script four - strips the pages for all rates and numbers entered. There is a document attached that outlines in detail how the group department creates a quote on WordPerfect.
Category: Other IT & Programming       
Skills: VBA, Microsoft Word       

F****URS
 [?]
Sign in to view client's details.
| F****URS
|    United States
Hourly Rate: Less than $10 / hr   |  Duration: 1-2 weeks  |  Posted: Feb 25, 2015  |  Ends: 13d, 8h  |   15 Proposals
I am looking for an expert in Macro scriptor to parse different xml files to produce a report in excel. Experience of Macros is must.
Category: Other IT & Programming       

N****mal
 [?]
Sign in to view client's details.
| N****mal
|    India
Hourly Rate: $30 - $40 / hr   |  Duration: Not Sure  |  Posted: Feb 25, 2015  |  Ends: 13d, 2h  |   19 Proposals
Create Vba Function to interface with third party Api using nested loops for existing database tables and queries
Category: Database Development       
Skills: VBA       
Preferred Location: United Kingdom

c****jd1
 [?]
Sign in to view client's details.
| c****jd1
|    Sweden
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Feb 25, 2015  |  Ends: 12d, 19h  |   22 Proposals
Help is needed to finalise some functionality and automations on 2 workbooks. 1) The 1st Workbook is a stage gates checklist for helping us manage development projects. It is 80% built but needs some expert help finalising. * Help needed to implement conditional formatting. Where parent tasks show traffic light status dependant upon status of child tasks. * Help needed automating the showing of overdue days of tasks. * Help needed with VBA where tasks on the sheet are visible or disappear dependant upon the selection made on a drop down menu at the top of the sheet (project type). 2) Our 2nd Workbook is a master dashboard that we wish to have active links to and summarize the status of multiple versions of the above stage gate checklists (we envisage approx. 30-40 active stage gate checklists that need to be linked to. *This dashboard sheet is approx. 70% built already but has none of the automation and active links that we want. *We wish this master dashboard to update at the push of...
Category: Technical Support       
Skills: Microsoft Excel       

A****_JL
 [?]
Sign in to view client's details.
| A****_JL
|    Australia
Fixed Price: Less than $500   |  Posted: Feb 24, 2015  |  Ends: 15h, 11m  |   17 Proposals
I have a single Excel file that contains several custom user forms, and a lot of VBA and some formula calculations. Most of the forms involve several option buttons, checkboxes, combo boxes and text boxes, and follow certain business rules (if this checkbox is marked, then these checkboxes are not, if this selection is made from a combo box, then these controls are active/inactive), and then writes the data to a sheet. The file currently has 9 sheets with 1 sheet containing 4 simple forms, and another sheet containing 2 search forms, the main data entry form, and an 'edit' form. When I print all the code, there's about 60 pages, but some of those 60 pages contain just a few lines of code - taking out all the white space and there's probably approximately 40 pages of actual VBA code. However, maybe half (or more? it's an estimate...) of the changes and edits required by this job will not be affected. The project itself is 95% complete or better and is functional as is - but needs some...
Category: Software Application       
Skills: Microsoft Excel, VBA       
Preferred Location: North America

M****rly
 [?]
Sign in to view client's details.
| M****rly
|    United States
Fixed Price: $100 or less   |  Posted: Feb 24, 2015  |  Ends: 4d, 13h  |   3 Proposals
I expect following: - A detailed financial model on the company Esterline Corporation (NYSE:ESL) - 3-year historical with minimum 2 years including Qtrs - 4- year forecast including immediate current year and next year quarterly forecast - Proper revenue and cost drivers - Segments - DCF and Relative valuation - Proper cell comments for every assumptions - Sensitivity analysis tables - There should not be any formatting error - No circular reference, you can use circuit braker - You can use macro/vba in the model - A one page SWOT analysis on the company I need all this max within 2 weeks of job start.
Category: Investment Analysis       
Skills: Report Writing, Financial modeling       
Preferred Location: India/Southern Asia, Eastern Asia, Africa

a****avi
 [?]
Sign in to view client's details.
| a****avi
Fixed Price: $25 - $30   |  Posted: Feb 24, 2015  |  Ends: 12d, 11h  |   19 Proposals
I have an VBA excel spreadsheet that check product urls from   [obscured]  ,   [obscured]   etc. And displays the product title, current price, product availability(In stock or Out of stock) and quantity. Recently product url from   [obscured]   are not displaying accurate information for Product availability and quantity. For example where a product link should be "Out of stock" and quantity should be "0", it is displaying "In Stock" and quantity of "5"....I am having this problem with   [obscured]   only.....  [obscured]   and all the others are working fine. The code are already there...It should be an easy fix for anyone who know what they are doing. ..Please let me know who can make this work...It is urgent and i need someone who can work on it right away
Category: Data Analysis       
Skills: Microsoft Excel, VBA, Web scraping       

y****r19
 [?]
Sign in to view client's details.
| y****r19
|    Canada
Fixed Price: Less than $500   |  Posted: Feb 24, 2015  |  Ends: 12d, 10h  |   3 Proposals
I need to implement the logic of the following paper either in excel or R, from where I can call a C++ program for executing the following logic. I am comfortable if you want to do it in some other language or any other efficient way of doing this. The inputs to run this program must be accessible from excel or a text file. I can share a brief overview similar to the logic mentioned above. I can share more details regarding the data file with serious freelancers who have considerable experience in such things and will not be trying to bid for such work for the first time.
Category: Investment Analysis       
Skills: VBA, C++, MATLAB, MetaTrader 4 (MT4)       

q****ian
 [?]
Sign in to view client's details.
| q****ian *
|    India
Fixed Price: Not Sure   |  Posted: Feb 24, 2015  |  Ends: 12d, 9h  |   4 Proposals
I need to write program in VB or .NET for Microstation. It will be CAD overlay for geodesy. I will send on email specification.
Category: Software Application       
Skills: .NET Framework, VBA, Visual Basic, Microstation       

l****600
 [?]
Sign in to view client's details.
| l****600
|    Poland
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Feb 24, 2015  |  Ends: 27d, 4h  |   12 Proposals
Looking for an experienced Excel / VBA programming consultant for a Financial DataModel Macro Scripting who has worked with Excel automation, Visual Basic for Applications (VBA) development, macros and scripting with large, complex data sets.
Category: Database Development       
Skills: Microsoft Excel, VBA, VBScript       
Preferred Location: India

T****rze
 [?]
Sign in to view client's details.
| T****rze
|    India
Fixed Price: Less than $500   |  Posted: Feb 24, 2015  |  Ends: 12d, 0h  |   13 Proposals
I need a dynamic model for a vendor management system. The total number of orders will change over time. However, this number is fixed for each year - e.g. 130,000 for 2014. The total number of suppliers -6, (and their vehicles - total 87 as of now) now is fixed. However, the model is dynamic to account for new players, and the impact on vendor pricing and share of orders each vendor gets - over the years. Also, I need the model to account for different strategies for vendor management - e.g. open bidding, setting up maximum price etc. I have a static model, but that does not have all the functionalities I need. I need this by Friday, 27 Feb 2015.
Category: Software Application       
Skills: Microsoft Excel, VBA, Business Modeling       

a****aul
 [?]
Sign in to view client's details.
| a****aul
|    Australia
Fixed Price: Less than $500   |  Posted: Feb 24, 2015  |  Ends: 11d, 22h  |   15 Proposals
Transform an Excel tabel with biographical and bibliographical data on persons into a readable word document.
Category: Other IT & Programming       
Skills: HTML, PHP, VBA       

c****noe
 [?]
Sign in to view client's details.
| c****noe
|    Hong Kong SAR, PRC
Hourly Rate: Less than $10 / hr   |  Duration: 1-2 weeks  |  Posted: Feb 23, 2015  |  Ends: 11d, 11h  |   3 Proposals
I have an existing Quality Audit form that I would like to create a macro for, to call data, transfer and save data and be able to summarize the data and send it to email - and create a dashboard (pivot table for all data) driven by macro as well.
Category: Other - Administrative...       

m****bee
 [?]
Sign in to view client's details.
| m****bee
|    Philippines
Hourly Rate: $20 - $30 / hr   |  Duration: Not Sure  |  Posted: Feb 23, 2015  |  Ends: 11d, 10h  |   6 Proposals
I currently have an extensive macro in excel that is run off bloomberg data. When I try to run it at the beginning it says "unable to get the match property of the WorksheetFunction class".. I need a bit of help.. It shouldn't take long. Just a minor fix.I would really appreciate your help.
Category: Investment Analysis       
Skills: VBA       

C****531
 [?]
Sign in to view client's details.
| C****531
|    United States
Fixed Price: $500 - $1,000   |  Posted: Feb 23, 2015  |  Ends: 11d, 5h  |   21 Proposals
Hello, I work for a medical billing company and I am in need of a program that can automate one of our processes. Currently, we have individuals manually create a brand new datasheet that corresponds to an aging accounts receivable report. Once the accounts receivables are entered into the datasheet the same individual will transfer the notes from the old datasheet to the new data sheet's corresponding lines. So, I need a program that can automate this system. First, the program will need to take the exporting aging report and arrange it in our datasheet's format. For every balance there should be a new line create for each date and payer. Second, the program will need to transfer the information from the old datasheet to the corresponding lines on the new data sheet. To clarify, the new datasheet is every account that is outstanding and should have lines from the old data sheet. Thus, if John Doe in the old data sheet has a line for 9/2014 with an A/R balance for $300 and the ne...
Category: Data Engineering       

H****MCA
 [?]
Sign in to view client's details.
| H****MCA
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Feb 23, 2015  |  Ends: 11d, 3h  |   16 Proposals
Dear Elancers, I am looking for someone to create a macro for me which I can insert in to my report template. This macro should allow me to insert multiple pictures into the report at the same time, the pictures are to be the same size and way up. My report is a microsoft word document.
Category: Other IT & Programming       
Skills: HTML, PHP, VBA       

l****014
 [?]
Sign in to view client's details.
| l****014
|    United Kingdom
Hourly Rate: Less than $10 / hr   |  Duration: 7-9 months  |  Posted: Feb 22, 2015  |  Ends: 25d, 9h  |   20 Proposals
I am looking for an expert VBA developer who will support me everytime during my daywork. The job will be half turoring and half execution of given tasks. If you don't agree with this method simply skip.
Category: Data Analysis       
Skills: Microsoft Excel, Visual Basic       

B****orp
 [?]
Sign in to view client's details.
| B****orp
|    Czech Republic
Fixed Price: Less than $500   |  Posted: Feb 22, 2015  |  Ends: 10d, 7h  |   23 Proposals
Hey There, We generate our quotes manually based on a cost sheet . the margins are fixed however the parameters that are used to determine which rate and what margins to be used vary and they should ideally be the input for this automated sheet . I am not sure as to how you can go about it maybe using VBA or maybe directly using formulas . If you have read this post before you put down your proposal please start your proposal with the words I believe. I expect the work to take not more than a couple of days . It would be helpful if you put down what kind of approach you are planing on taking towards this . Also any relevant work that you have done along the same lines would be really useful in selecting. Thank you
Category: Data Engineering       

L****son
 [?]
Sign in to view client's details.
| L****son
|    United Arab Emirates
Fixed Price: $500 - $1,000   |  Posted: Feb 21, 2015  |  Ends: 9d, 3h  |   35 Proposals
I have a project I need to implement for my office and it is a bit much for me. Now, I am working for a manufacturer with products in 7 large retail outlets (supermarkets) and we receive sales data from each outlet monthly. This data comes in different formats depending on the retailer and we need to make sense out of it and give various reports. Our current system is Excel and that is what we would like the output to be in. I proposed that we work with an Access backend, that will sort out the data and produce the end result. My employer does not want to invest in a Reporting Tool so we're forced to offer a solution. The sales data is rather large, with some files being as large as 1.1GB, approximately 2mil records. The manufacturer has approximately 1000 products and at the moment it takes different departments about 6 weeks to sift through one months data. What we need is a value proposition solution which makes us process data in a shorter time frame and in a more organized manner....
Category: Database Administration       

w****bu1
 [?]
Sign in to view client's details.
| w****bu1
|    South Africa
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