Save this Search
     

All JobsExcel VBA

 (45 results)  
Sort by:
  • Posted Date
Results for 'Excel VBA'
Fixed Price: Less than $500   |  Posted: 23h, 30m ago  |  Ends: 13d, 23h  |   6 Proposals
Need to copy multiple rows to two columns. want multiple methods to complete task macro/vba (keep formatting of text) Formula: INDEX INDIRECT TRANSPOSE I will apply the solutions to various worksheets and want multiple ways of transposing the data while linking to source data for updates.
Category: Presentation Formatting       

o****eez
 [?]
Sign in to view client's details.
| o****eez
|    Nigeria
Fixed Price: $20 - $30   |  Posted: Feb 28, 2015  |  Ends: 13d, 22h  |   18 Proposals
Need to copy multiple rows to two columns. want multiple methods to complete task macro/vba (keep formatting of text) Formula: INDEX INDIRECT TRANSPOSE I will apply the solutions to various worksheets and want multiple ways of transposing the data while linking to source data for updates.
Category: Presentation Formatting       

r****aac
 [?]
Sign in to view client's details.
| r****aac
|    United States
Fixed Price: Not Sure   |  Posted: Feb 28, 2015  |  Ends: 58d, 21h  |   5 Proposals
attached repo_test2 and basket2.xlsx is for this task. there are requirements for every term one contract has mentioned in repo.xlsx and ur task is to search all the contracts in repo.xlsx and find out those can satisfy the requirements in the basket. and produce a new excel to put those ones. i wil be looking fwd to your sample macro. second task is for those two doc - data for the trade balance and draw the flow chart. specific description is in the docx. basically i wanna draw a chart in excel exactly like the one in doc - kindly advise if this is possible and lets start from here. thanks!
Category: Other - Finance & Mgmt       
Skills: Microsoft Excel, VBA, Data Interpretation       

L****cks
 [?]
Sign in to view client's details.
| L****cks
|    Singapore
Hourly Rate: Not Sure   |  Duration: 1-2 weeks  |  Posted: Feb 27, 2015  |  Ends: 13d, 12h  |   0 Proposals
I need someone to help me do some VBA work using Excel to communicate to a power supply/tester through USB using an Agilent add-on for USB communication. We have started a crude version but need more resources to make it work on a small 10" touchscreen. There will need to be ability to scan in a part number to pull in test information from a test database.
Category: Electrical       
Preferred Location: United States

a****ler
 [?]
Sign in to view client's details.
| a****ler
|    United States
Fixed Price: $50 or less   |  Posted: Feb 27, 2015  |  Ends: 13d, 6h  |   7 Proposals
This is my first time using any freelance site. So this is just a simple request for a login macro to the following website (it's a redirect from connect.ihs.com):   [obscured]  /KeystoneSTS/SSOLogin/Login.aspx?altertheme=castle&theme=ENERGY&ReturnUrl=https%3a%2f%2fglobalsso.ihs.com%2fKeystoneSTS%2fSaml2%2fDefault.aspx%3faltertheme%3dcastle I just need to enter my email address and password to the macro, and have the macro log me into the site. I will likely need more done, but don't want to give out my login information. Having the website return an error message that the login is invalid is OK at this point.
Category: Web Programming       
Skills: HTML, VBA       
Preferred Location: North America

j****rts
 [?]
Sign in to view client's details.
| j****rts
Fixed Price: Not Sure   |  Posted: Feb 26, 2015  |  Ends: 12d, 8h  |   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: Feb 26, 2015  |  Ends: 12d, 3h  |   1 Proposal
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: Feb 26, 2015  |  Ends: 12d, 3h  |   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 25, 2015  |  Ends: 11d, 15h  |   22 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
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Feb 25, 2015  |  Ends: 10d, 18h  |   23 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: $25 - $30   |  Posted: Feb 24, 2015  |  Ends: 10d, 10h  |   21 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: 10d, 10h  |   4 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
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Feb 24, 2015  |  Ends: 25d, 3h  |   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: 9d, 23h  |   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: 9d, 21h  |   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: 9d, 10h  |   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: 9d, 9h  |   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
Hourly Rate: Less than $10 / hr   |  Duration: 7-9 months  |  Posted: Feb 22, 2015  |  Ends: 23d, 8h  |   22 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: 8d, 6h  |   24 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: 7d, 2h  |   38 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
Hourly Rate: $15 - $20 / hr   |  Duration: 4-6 months  |  Posted: Feb 20, 2015  |  Ends: 6d, 18h  |   27 Proposals
I am seeking a general statistical/computer consultant for general statistical and mathematical analysis mainly in bio-statistics, epidemiology and the life sciences. Must have undergraduate and/or graduate university training in statistics, mathematics, physics and/or computer science. Specific experience in developing menu driver Visual Basic Applications (VBA) in Excel would be very useful. Must be a fluent English speaker. Key skills: Data cleaning, data analysis, handling big data sets, summary tables, regression analysis, forecasting model development. Building interactive Excel models in visual basic and or other languages. Key software: Excel, Visual Basic, STATA, SPSS, R, other regression and forecasting software. Immediate position, open until filled. Part and full time initially with more work to follow if all works out. References required. No criminal record. Able to work independently.
Category: Data Analysis       
Skills: Statistics, Visual Basic       

M****015
 [?]
Sign in to view client's details.
| M****015
|    Canada
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Feb 20, 2015  |  Ends: 6d, 15h  |   17 Proposals
Hi, I am looking to hire someone to skype with me for an hour or two to discuss my needs for a mobile app and the best way I can go about developing it. I am interested in developing a database-driven app that would need to work cross-platform. I would be using it at live events and asking participants to download and use the event on-site. I have a degree in computer science but am rusty with my coding skills as it has been a while. In the past, I coded in C, C++ (a little) and VBA layered on Excel. I have never built an app. I have questions like: * Should I use a platform-independent tool like Xamarin to develop? What are the pros and cons, what are the limitations? * What other important things do I need to consider, e.g. database structure, and where do I get started? I can send you more information about functionality over email, or discuss with you by skype. Please help me evaluate the pros and cons of different options and help me get started down the road in development. ...
Category: Mobile Applications       

r****nfo
 [?]
Sign in to view client's details.
| r****nfo
|    United States
Hourly Rate: $15 - $20 / hr   |  Duration: Not Sure  |  Posted: Feb 19, 2015  |  Ends: 4d, 22h  |   22 Proposals
Our Business Analytic application helps companies make profitable decisions ahead of time. Our product is written in VBA and were looking to enhance and optimize the front end and back end. Looking for 5 - 10 years experience in developing excel vba applications as well as having good grasp of business analytics. This person has to have good communication skills and is a self starter who can work independently. Examples of work done must be shown. We prefer looking for a freelancer who we can can trust and we only want to speak him/her and not to any sales department within an organization. Thanks, Ryan
Category: Business Intelligence       
Preferred Location: United States

D****zar
 [?]
Sign in to view client's details.
| D****zar
|    United States
Fixed Price: Less than $500   |  Posted: Feb 18, 2015  |  Ends: 4d, 14h  |   45 Proposals
I have a job where regularly I get chemistry laboratory EDD files (electronic data deliverables) in excel file format. They have the same headers with attributes every time (i.e. chemistry sample test type is always in column "J", units of the test is always in column "F" and so on. I end up manually sorting / trimming / reorganizing the spreadsheet to make a summary table of the chemistry values. The values are often screened / compared to a threshold value (i.e. if the cell value is above 5, make bold, if it is above 10, make bold and underlined). 2/19 UPDATE: I have put the example files and my manual instructions of what I do currently by hand and what i'd like done by VBA or other script / in excel or office without a pay-external program. Let me know what you think! Thanks.   [obscured]  /sh/xjezurdfe0svyma/AAAe5FRiK7rW7V5AwyF6tu3la?dl=0
Category: Other IT & Programming       
Skills: Microsoft Excel, PHP, VBA, SAS       

L****002
 [?]
Sign in to view client's details.
| L****002
|    United States
Fixed Price: Less than $500   |  Posted: Feb 18, 2015  |  Ends: 4d, 14h  |   43 Proposals
I have two data sets in excel. Each data set contains multiple fields but both sets have Draft Date, Last 4, Dollar Amount. I need to compare data set 1 to data set 2 base on these 3 fields and create a report that finds records from data set 1 where the 3 fields don't match the same 3 fields from data set 2. Also need a report when the comparison is ran that finds multiple records from the other data set. If there is a one per one match the records can be discarded.
Category: Other IT & Programming       
Skills: MySQL Administration, PHP, VBA       

e****low
 [?]
Sign in to view client's details.
| e****low
|    United States
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