Save this Search
     

All JobsMicrosoft Excel Macros

 19 results  
Sort by:
  • Posted Date
Fixed Price: $80 - $100   |  Posted: 12h, 55m ago  |  Ends: 14d, 11h  |   0 Proposals
Need to be created as an add-in like in the picture 1.jpg, with each macro as an icon. Also will be adding more such in future, so should be flexible Macro 1: To bring each row of data from excel to one powerpoint slide. Macro 2: Multiple row, like the one i`v described in detail on my last mail Macro 3: To introduce defined number of blank rows or column next to the selected row or column Macro 4: To move entire column or row down, up, left, right, with those arrow marks in the addin. Can show some samples Macro 5: I`m already developing an application on .net for extracting data from picture graphs, which i want to integrate into it.
Category: Software Application       

d****d84
 [?]
Sign in to view client's details.
| d****d84
|    India
Fixed Price: Less than $500   |  Posted: 13h, 45m ago  |  Ends: 14d, 10h  |   7 Proposals
We are looking for an advanced excel expert to design a spreadsheet used to dynamically analyze real estate rental data from a .txt source file. Our firm performs regular analyses of data to determine typical rental amounts, rental ranges for # of bedrooms and median/average from several sources. Here is the problem we are looking to solve: The main source of this data is capable of exporting into a tab delimited .txt format only. It is time consuming to filter, organize and sort this data since the exported data contains a number of irrelevant data fields and the fields are not sorted in a logical manner that would allow for simple and efficient analysis. I am looking to have a spreadsheet developed that is capable of easing this task and making it more efficient. We analyze data sets like this repeatedly, as a result a lot of time is being wasted converting the txt file to a spreadsheet, deleting irrelevant columns, editing and reordering fields, etc. A winning design will auto...
Category: Data Analysis       
Skills: Microsoft Excel       

t****o11
 [?]
Sign in to view client's details.
| t****o11
|    United States
Fixed Price: $40 or less   |  Posted: 16h, 17m ago  |  Ends: 14d, 7h  |   13 Proposals
I have a Microsoft Excel spreadsheet wich I use to calculate freight. A Macro was developed to send parameters as weight and volume to a webservice of a freight company and as a result we become the freight cost. The Macro works very well with Windows 7 / Microsoft Office 2007 When we tried to use the same macro with Windows 8, it didnīt work Now we must adequate so It can work with Windows 8.1 and Excel 2007 When trying to run the Macro, the problem seems to be at "Dim Req As New XMLHTTP" The excel sheet with the code is attached.
Category: Other IT & Programming       
Skills: Microsoft Excel, PHP, VBA, Visual Basic       

p****tao
 [?]
Sign in to view client's details.
| p****tao
|    Brazil
Fixed Price: $50 - $125   |  Posted: 16h, 30m ago  |  Ends: 2d, 7h  |   8 Proposals
I have two sample input files that are converted from PDF into Excel but the problem is the columns sometimes get messed up. Sometimes the data can be in column B and later in column C. Or the data can be exist in both column B and C. I would like to setup an Excel VBA program that can do a few things: 1) Select a file input 2) Select a file input format (Sample 1 or Sample 2) which contain slightly different information OR you can have the Excel VBA program recognize if it has Copay column or not. 3) Parse the data file and remove extra lines, rows, and extract only data that's important. 4) Create an output flat file with columns and data, similar to uploading into a database. 5) Program setup should be easy and interface input/output should be straight forward In order for the project to be completed several test runs of actual data will be used to stress-test and delivery of final product should be on-time. Thank you, Paul
Category: Other IT & Programming       
Skills: Microsoft Excel, .NET Framework, VBA       

p****ard
 [?]
Sign in to view client's details.
| p****ard
|    United States
Hourly Rate: $10 - $15 / hr   |  Duration: 1-2 weeks  |  Posted: Apr 15, 2014  |  Ends: 12d, 7h  |   15 Proposals
I'm looking to create a tool my clients can use to analyze a set of data. They will have to copy and paste a csv file into the excel and then they should be able to see the results of the pre-defined analysis on two or three tabs. To accomplish my objective, I basic macros and advanced filtering will be needed. Ideally, I'd love to meet in person or via Google Hangout to describe the project and obtain your input on other options of what could be done with the data set. Thanks! Jessica
Category: Data Analysis       
Skills: Microsoft Excel       

j****isz
 [?]
Sign in to view client's details.
| j****isz
|    Canada
Hourly Rate: $10 - $15 / hr   |  Duration: 1-2 weeks  |  Posted: Apr 15, 2014  |  Ends: 12d, 7h  |   5 Proposals
I'm looking to create a tool my clients can use to analyze a set of data. They will have to copy and paste a csv file into the excel and then they should be able to see the results of the pre-defined analysis on two or three tabs. To accomplish my objective, I basic macros and advanced filtering will be needed. Ideally, I'd love to meet in person or via Google Hangout to describe the project and obtain your input on other options of what could be done with the data set. Thanks! Jessica
Category: Data Analysis       
Skills: Microsoft Excel       

j****isz
 [?]
Sign in to view client's details.
| j****isz
|    Canada
Fixed Price: Less than $500   |  Posted: Apr 15, 2014  |  Ends: 6h, 56m  |   6 Proposals
We have an Excel 2013 spreadsheet with several tabs with accounting information. We use this Excel to input data to an XML file but we need some range of information to be formatted in XHTML keeping format, size, color, etc. from tables and text. I mean, the XHTML generated will be a copy of the format we have in the spreadsheet. The Macro will feed the XHTML code into an specific book within the spreadsheet. Additional to this, we need to improve our current Print macro, so we would like to have a new Macro which help us to print the books in the spreadsheet in just one clic action. Macro should format the data for printig too.
Category: Other IT & Programming       
Skills: Microsoft Excel, VBA, XHTML, Microsoft Office       

s****roz
 [?]
Sign in to view client's details.
| s****roz
|    Chile
Hourly Rate: Not Sure   |  Duration: 3-4 weeks  |  Posted: Apr 14, 2014  |  Ends: 11d, 9h  |   2 Proposals
Starting with an existing script that takes actuals hours worked from a timesheet database and posts the actuals to MS project. Redesign and or rework the script to perform more automation. We will discuss details. Job Description: We are looking for a talented Visual Basic for Applications Developer who will be responsible for the design, development and deployment of certain macros to assist in automating certain project management functions. Your responsibilities: - Review and perform a technical analysis of requirements - Produce a solid, detailed technical design - Write clean, modular, robust code to implement the desired requirements - Contribute ideas for making the application(s) better and easier to use Your qualifications: - A work style that is extremely detail oriented - A complete Elance profile - References or an established Elance reputation preferred - Working knowledge of the latest release of MS Excel and MS Project - Working knowledge of the lates...
Category: Mobile Applications       
Preferred Location: United States

b****ett
 [?]
Sign in to view client's details.
| b****ett
|    United States
Fixed Price: Not Sure   |  Posted: Apr 14, 2014  |  Ends: 10d, 21h  |   7 Proposals
We have an Excel macro file that needs to work for PC and MAC. It gives an error on MAC - We'll need to transfer vba code fom macro to apple scripting language for Excel.
Category: Data Engineering       

t****ory
 [?]
Sign in to view client's details.
| t****ory *
|    United States
Hourly Rate: Less than $10 / hr   |  Duration: 1-2 weeks  |  Posted: Apr 10, 2014  |  Ends: 7d, 12h  |   2 Proposals
I need (i) a macro in excel to enable easy printing of a work book (comprising 4 work sheets) and (ii) some limited design work to make each work sheet "look good" but still allowing them to function in excel. The design work is to make it look good! There is a logo on each page that provides the colour scheme to use. The macro is to enable it to print out on A4 paper so it fits the page or has headings on pages where it goes past one page. I have added photos as well so you can see it needs to be able to cope with this as well when it prints. The photos will cross reference to some part of the work sheets. I need to be able to send it to Kinkos and have them print and bind it without any hassle.
Category: Other - Design       

R****ler
 [?]
Sign in to view client's details.
| R****ler
|    Australia
Fixed Price: Not Sure   |  Posted: Apr 10, 2014  |  Ends: 7d, 11h  |   13 Proposals
We have an excel macro (existing) for Office 2003 and it works to read emails in MS Outlook and populate an excel sheet. We need to upgrade the macro so it will work for office 2010. The macro is not so complex - but it just needs to work in 2010. This is just a small project. Ask any questions needed. John
Category: Database Development       

l****tic
 [?]
Sign in to view client's details.
| l****tic
Hourly Rate: $20 - $30 / hr   |  Duration: 1-2 weeks  |  Posted: Apr 10, 2014  |  Ends: 7d, 3h  |   5 Proposals
Can you prepare excel sheet with macro, OR make software using Access with good UI ? My requirement is attached. Comment is mentioned in Red font ketan ketanmehta@hotmail
Category: Office Management       
Preferred Location: India

k****hta
 [?]
Sign in to view client's details.
| k****hta
|    India
Fixed Price: Less than $500   |  Posted: Apr 09, 2014  |  Ends: 6d, 0h  |   17 Proposals
Hi Again, Please can you assist me with the same task? I have added 2 Sheets to the document, but they contain Chart Objects. I need the Macro to export 4 sheets, 2 as it currently does, but also the additional 2 Chart Sheets(only the Charts, not any data)? Can you do this? Thanks
Category: Other IT & Programming       
Skills: Microsoft Excel, VBA       

u****ser
 [?]
Sign in to view client's details.
| u****ser
|    United Kingdom
Fixed Price: Less than $500   |  Posted: Apr 08, 2014  |  Ends: 5d, 4h  |   7 Proposals
We need specific information about the pre-school education market in the United Kingdom as well as global macroeconomics data, over the 2012-2020 time period (past, actual and prevision). Format: we will provide an excel sheet with pre-designed fields to filled. Each data will need to be linked to a verified source. Definition of pre-school education: each form of public and private nursery schools, day-care centers and/or kindergarten options, available for kids, before compulsory education. The age range may vary from one country to another (between 2 and 6 years old in average). 1. Macro economics data Demographics ? Total population between 2012 and 2020 ? Number of children below the age of 5 between 2012 and 2020 ? Number of kids per woman and per family between 2012 and 2020 Employment ? Workforce penetration of women with BA degrees between 2012 and 2020 ? Female participation rate in the labour force between 2012 and 2020 ? Unemployment rate between 2012 and 202...
Category: Research & Surveys       

n****ier
 [?]
Sign in to view client's details.
| n****ier
|    United Kingdom
Hourly Rate: Less than $10 / hr   |  Duration: 1-3 months  |  Posted: Apr 05, 2014  |  Ends: 13d, 10h  |   6 Proposals
The areas and tasks the job encompasses will include but are not limited to: Gathering data, product research, and inputting data for listing creation on Amazon, as well as on other online sales channels. Manipulating product photos via Photoshop or Illustrator. Strong writing, communication and grammar skills in English. High level computer skills are required, including advanced Excel expertise, and be able to create and use formulas, create macros and manage multiple sheet Excel workbooks Creating listing feeds via excel/csv/txt files. Maintaining current database of product UPC numbers. Reporting requirements will include weekly status updates in formal documentation. The above is a general list of what we need and it may change as the business evolves.
Category: Data Analysis       

z****sab
 [?]
Sign in to view client's details.
| z****sab
|    United States
Fixed Price: $1,000 - $5,000   |  Posted: Apr 04, 2014  |  Ends: 1d, 7h  |   41 Proposals
Looking for a best in class Macro developer using latest Microsoft features for development of User Interface for Supply Chain
Category: Software Application       
Skills: Microsoft Excel, VBA       

s****lai
 [?]
Sign in to view client's details.
| s****lai
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Mar 01, 2014  |  Ends: 12d, 6h  |   33 Proposals
We are an e-commerce company who sells products online. We are constantly working with data in Excel, TAB, CSV and XML formats. Some tasks our simple and may just be converting one format to another or sometimes combining data fields from multiple spreadsheets. Some tasks are a bit more complex and may need formulas or macros created in order to get the output file the way we want it. And then there are are tasks that involve everything I've described above and more. Another example of what we need or have done before is if we find that we are repeating Excel tasks or functions over and over again, we will instead have an Excel expert create an Excel program for us where we can just drag and drop datasets, enter some values and then just click on run to generate an output file. I realize that most of what I've described here might be easy for someone who is highly qualified, but the needs I've described up to this point are not the main priorities. The main condition for hiring...
Category: Virtual Assistant       

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