Save this Search
     

All Jobsexcel macros

 (31 results)  
Sort by:
  • Posted Date
Results for 'excel macros'
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: 14h, 20m ago  |  Ends: 6d, 8h  |   7 Proposals
Hello, I have a list of products in excel that I would like to insert the pictures next to them automatically then save the excel workbook to be able to email to customers. I understand this may need to use a macro but I only want the macro to be run once then when all the pictures are inserted I want them to remain as part of the excel workbook. I do not want the macro to need to run every time the workbook opens in order for the images to show. Many Thanks
Category: Technical Support       
Skills: Microsoft Excel       

O****OUP
 [?]
Sign in to view client's details.
| O****OUP
|    Australia
Fixed Price: Not Sure   |  Posted: 15h, 54m ago  |  Ends: 2d, 7h  |   16 Proposals
I have a SQL Stored Procedure that inserts data into a SQL Table I want to have an excel macro or VBA that takes data from the excel file and uses the SQL stored procedure to import that data into the table. Stores Procedure and data upon request
Category: Other IT & Programming       
Skills: VBA, Microsoft SQL Server Programming, Macro       

c****ls1
 [?]
Sign in to view client's details.
| c****ls1
|    United States
Fixed Price: Not Sure   |  Posted: Mar 03, 2015  |  Ends: 12d, 0h  |   20 Proposals
A simple macro run in excel to look at a folder path input in a cell in a worksheet for all PowerPoint files and combine them into one single file name also specified on the excel spreadsheet. Thanks
Category: Data Analysis       
Skills: Visual Basic       

z****tel
 [?]
Sign in to view client's details.
| z****tel
|    United States
Hourly Rate: Not Sure   |  Duration: 1-2 weeks  |  Posted: Mar 02, 2015  |  Ends: 11d, 12h  |   13 Proposals
.txt file is converted into Excel file and use a combination of macros and formulas in cells to calculate. Need a access database to automatically calculate these fields and create charts/reports.
Category: Technical Support       
Skills: Database, Microsoft Access Programming       

S****eCS
 [?]
Sign in to view client's details.
| S****eCS
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Mar 02, 2015  |  Ends: 86d, 7h  |   1 Proposal
I'm accepting offers for the development of a forecasting tool based on output data generated from either SAP reports and/or other similar software, outputs provided in excel. Expected development time: 10 hours (but length is open for negotiation) Minimum knowledge: Macros in Excel is a must, other database knowledge is a plus but not required Due to confidentiality of information applicants are expected to work at the facilities of the client in Morristown-NJ, hardware and software to be provided by client. Proposals to be submitted preferably by full package or by hourly rate.
Category: Statistics       
Skills: Microsoft Excel, Negotiation, Database       
Preferred Location: United States

t****ari
 [?]
Sign in to view client's details.
| t****ari
|    United States
Hourly Rate: More than $50 / hr   |  Duration: 1-3 months  |  Posted: Mar 02, 2015  |  Ends: 25d, 19h  |   26 Proposals
I am an IT enthusiast, but I am not too good with programming or VBA. As a side project, I am compiling some data and would like to make it user friendly. In an excel file I have been developing insofar, I have been successful in implementing different functions throughout, by the help of some individuals here, friend circles, and myself through research. Through this listing, I am seeking someone to cooperate in the long term future, as well as current tasks which I need to take care of. My pre-requisites, is that you understand how to communicate, you speak English at a standard level, are an expert at VBA, data entry and can develop a relationship for the long term, therefore a responsible individual all around. Hence, only individuals with a 'repeat hire rate' of 30% and above need to apply or bid. You can have a look at the file attached and let me know whether you understand the code, and are able to work with it in the long term? I already have some tasks which you could ...
Category: Database Development       
Skills: VBA       

a****bos
 [?]
Sign in to view client's details.
| a****bos
|    China
Hourly Rate: $10 - $40 / hr   |  Duration: 1-2 weeks  |  Posted: Mar 02, 2015  |  Ends: 10d, 18h  |   82 Proposals
Our company mantains a complex excel macro that transforms data from one format into another format. Our current macro programmer is not available and we need a new macro programmer. The job-details follow later and will be send to the applicants we select for the 2nd round. our requirements: A reliable person, which means: - Response to each mail within 2 working days - Announce in advance vacation periods and other non-available periods Several years experience in VBA Development Good in communication: - asks questions if he/she doesnt understand. - can summarize the business requirements - profound english knowledge We offer We offer hourly contracts, you get paid for each hour you spend on our projects. I will not take copy / paste proposals into account. please respond to my requirements and why we should pick you
Category: Other IT & Programming       
Skills: Microsoft Excel, VBA, English, Visual Basic       

w****pro
 [?]
Sign in to view client's details.
| w****pro
|    Switzerland
Fixed Price: Less than $500   |  Posted: Feb 28, 2015  |  Ends: 8d, 19h  |   7 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: Not Sure   |  Posted: Feb 28, 2015  |  Ends: 53d, 17h  |   10 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
Fixed Price: $40 - $80   |  Posted: Feb 27, 2015  |  Ends: 8d, 7h  |   7 Proposals
1. We would like to be able to freeze part of the window and scroll the other part horizontally not just vertically. Example: We have spreadsheets that have charts at the top. We want to freeze these charts and then be able to scroll horizontally to all of the columns in the cell layer of the spreadsheet. 2. We would like to be able to have 4 separately scrollable panes (2 panes x 2 panes), both horizontally and vertically scrollable. Bonus request: We would like to have a button at the top of a column that will let us hide and unhide a group of columns.
Category: Other - Administrative...       
Skills: Microsoft Excel, macros       

R****sky
 [?]
Sign in to view client's details.
| R****sky
|    United States
Fixed Price: $50 or less   |  Posted: Feb 27, 2015  |  Ends: 8d, 2h  |   9 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: Less than $500   |  Posted: Feb 27, 2015  |  Ends: 7d, 22h  |   7 Proposals
I need a research resource that can produce a report to illustrate business transaction/acquisition activity in the USA for 33911a, Medical Instrument and Supply Manufacturing. I need to see a few select transaction announcements with some detail on a transaction level for the following industries/competitors and others if available within the last 24 months: ? Consumables: STERIS (STE), Medivators (CMN), Ecolab (ECL), Ruhof, Metrex, and Cygnus Medical (Expect to see 3-5 completed transactions) ? Durable goods: Knight LLC ( IEX), STERIS (STE), Medivators (CMN), Olympus (OCPNY), and/or other privately held companies like Endoscopy Replacement Parts, and Global Endoscopy. (Expect to see 3-5 completed transaction comps) Additionally, I need to see actual US transaction comp information from a qualified public or private resource such as BizComps, PeerComps, PrattStats, Done Deals, etc. (expect to see 40-50 transaction comps) Qualified Transaction Comps should include the following inf...
Category: Research       
Skills: Research       

T****ine
 [?]
Sign in to view client's details.
| T****ine
|    United States
Fixed Price: Less than $500   |  Posted: Feb 27, 2015  |  Ends: 7d, 21h  |   7 Proposals
I am looking for someone how have great experience with the APPROXIMATE ENTROPY calculation. I have a MACRO EXCEL file which are calculating ApEN value and it is needed to check it, if it is really working in the way as it should. I need someone how can describe me what is the "m" and "r" value in the calculation process.
Category: Chemical Engineering       
Skills: Microsoft Excel       

2****dam
 [?]
Sign in to view client's details.
| 2****dam
|    Hungary
Fixed Price: Not Sure   |  Posted: Feb 26, 2015  |  Ends: 22d, 14h  |   22 Proposals
Using Excel/Access, collate Australian Telco invoices that are in CSV format and interpret the cost by category (Voice, Mobile, Data), Services that are under-utilised using supplied measurements and inputting the information into relevant sections into a template report. - Must have Telco expense management experience, or IT/Telco background and will understand terminology such as MSA, BSA, VoIP, Fixed Voice, Mobile Data, - Understanding of the SI units- bytes, Kb, MB, GB, Terabytes and use them in formula for results output. - MS Access/Excel skills such are pivot tables, lookups, sort and macro generation. - Must be able to "think" and report in English - Ability to meet deadlines - Data Entry Experience Each report is approx. 40 hours effort and will be ongoing monthly, which means that the process will take less time to replicate every month. If there is capacity, you will be awarded further reporting opportunities with different data sets from other clients, but ess...
Category: Data Analysis       

B****how
 [?]
Sign in to view client's details.
| B****how
|    Australia
Fixed Price: About $20   |  Posted: Feb 26, 2015  |  Ends: 6d, 22h  |   6 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: Less than $500   |  Posted: Feb 25, 2015  |  Ends: 5d, 20h  |   6 Proposals
Hi Folks, Looking for a Microsoft Excel Expert who should possess the below following skills: -Extremely high level of familiarity with Excel 2010 -Experience using formulas in Excel in the performance of data analysis and compilation. This would include formulas such as VLOOKUP, -CONCATENATE, LEN, RIGHT/LEFT/MID, IF, SUM, COUNT, VALUE, FIND, etc. -Can use/comprehend usage of multiple formulas over several steps to produce needed data. For example, concatenate two cells, then use the result of that concatenation in a vlookup formula. -Has used nested formulas - i.e. a formula within a formula. -Is familiar with and has used conditional statements. ('if, then' statements) -Understands how to troubleshoot formulas that do not perform as expected. -For example, if a vlookup formula is not bringing back the desired data, knows to look at the format of the data that is being compared. (different data formats, e.g. text versus values, will cause the comparison to fail) -Hyper-sensitivity to...
Category: Content Management       
Skills: Microsoft Excel       

S****mar
 [?]
Sign in to view client's details.
| S****mar *
|    India
Hourly Rate: Less than $10 / hr   |  Duration: 1-2 weeks  |  Posted: Feb 24, 2015  |  Ends: 5d, 10h  |   4 Proposals
Hi all I am an investor who needs some one with Microsoft excel for mac 2011 skills. I have an excel spread sheet that I do all my individual stock valuation calculations on each day and I have up until; recently had msn money bringing in end of day fundamental market data in to my sheet using the web query macro. Msn has now discontinued support for this free market data service and I cannot work out how to re create this very simple but very important feed. What do I need? Please view the attached pdf. This is what msn looked like in mac excel. I do not need all the fields supplied by msn but that's just how it supplied it. I had an up date button on the sheet that updated the data using a macro linked to do it. All I need to be able to do is add any stock symbol extract the end of day fundamental information the actual fields that I need are as follows: 1. Current market price 2.current earnings per share 3.PE ratio 4. Current dividend per share 5.current book value The data mu...
Category: Software Application       
Skills: .NET Framework, Java, PHP       

d****nic
 [?]
Sign in to view client's details.
| d****nic
|    Australia
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Feb 24, 2015  |  Ends: 5d, 2h  |   38 Proposals
We are looking for an Excel Macro Guru to help us , take a CSV file with product details ( product name / product number / price / msrp / ...etc) and fill out a clients templates with all the necessary information in the right fields. each client has their own template, so this script needs to be able to be customized for each client. ( we have 5 clients) not sure how we can implement this, thats where we will need your expertise on this.
Category: Other IT & Programming       
Skills: Microsoft Excel, MySQL Administration, HTML, PHP       

p****798
 [?]
Sign in to view client's details.
| p****798
|    Canada
Fixed Price: $50 or less   |  Posted: Feb 24, 2015  |  Ends: 5d, 0h  |   10 Proposals
We need to adjust a macro that was already created. We need to separate tables that were already created and run a macro that will export a CSV file.
Category: Other IT & Programming       
Skills: Microsoft Excel       

G****r23
 [?]
Sign in to view client's details.
| G****r23
|    Colombia
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Feb 24, 2015  |  Ends: 19d, 23h  |   13 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: 4d, 17h  |   17 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: 4d, 6h  |   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
Fixed Price: $25 - $50   |  Posted: Feb 23, 2015  |  Ends: 4d, 4h  |   25 Proposals
Build an excel macro to compare 2 files. File 1 contains the master list. This list must be compared to file 2. Output file should be in the same format as file 2 and only list unique SKUs.
Category: Database Development       
Skills: Microsoft Excel       

g****ter
 [?]
Sign in to view client's details.
| g****ter
|    Canada
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Feb 22, 2015  |  Ends: 3d, 11h  |   21 Proposals
***only respond if you work individually and can support US hours******* Job Description: As an Analyst/Developer you will be involved in the analysis, design, implementation, and support of an CRM application built in MS Access and SQL. Requirements Proven skills in organization, prioritization, time-management, and decision-making Good oral & written communication skills (fluent English) Good knowledge and experience in the SDLC (System Design Life Cycle) Ability to analyze requirements and develop design specifications (working with business and IT contacts) Extensive experience with technical software development (understands online and batch concepts. Fluent in best practices) Good knowledge on database design and performance concepts Ability to develop, execute, and document test scripts Adhere to standards for software development and change management Provide production system support as necessary Working knowledge in Microsoft Office Suite (Outlook, W...
Category: Other IT & Programming       
Skills: Microsoft Excel, Microsoft PowerPoint       

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