Save this Search
     

All JobsMacros

 (59 results)  
Sort by:
  • Posted Date
Results for 'Macros'
Hourly Rate: $30 - $60 / hr   |  Duration: 3-4 weeks  |  Posted: 22 minutes ago  |  Ends: 14d, 23h  |   0 Proposals
We are a Sydney, Australia based sales and marketing company who is in search of an excel whiz/guru who can modernize and innovate our excel based reports. The ideal freelancer must be quick and expertised on excel, able to take our current reports and create much better looking versions which can easily be updated. This excel guru must be able to design dashboards with macros and everything else that's super fancy in excel which saves time and effort for any sales person in providing their customer with a great and quick report.
Category: Business Intelligence       
Skills: Microsoft Office       
Preferred Location: Australia

H****las
 [?]
Sign in to view client's details.
| H****las
|    Australia
Fixed Price: Less than $500   |  Posted: 4h, 11m ago  |  Ends: 14d, 19h  |   1 Proposal
I need the macro that you created the installer for to have some updates. The following is what I need done. 1. Put the custom icons I have made in the macro. 2. Add a button that will open the RGL in word 3. Change the code from VBA to XML
Category: Software Application       
Skills: VBA, XML       

j****yer
 [?]
Sign in to view client's details.
| j****yer
|    Canada
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: 5h, 22m ago  |  Ends: 14d, 18h  |   1 Proposal
I have a Microsoft Excel Macros VBA I am looking to incorporate into a Javascript application I am developing> I am looking for someone who can work with our in house developers to convert this code. I have attached a partially completed spreadsheet. The 2D and 3D regularization codes can be found in the VBA editior. I have not created this code myself so there is also a website you can use as reference (included in VBA editor)
Category: Other IT & Programming       

T****ins
 [?]
Sign in to view client's details.
| T****ins
|    Australia
Fixed Price: Not Sure   |  Posted: 13h, 3m ago  |  Ends: 14d, 10h  |   1 Proposal
Using a provided feed, I need someone with the understanding in RTD's, macros, and excel as well as any API knowledge to extract and collect real-time streaming tick-by-tick market data, otherwise known as time and sales. Dates: The job will be live for all market sessions in the month of May, not including market holidays - May 4-8, May 11-15, May 18-22, and May 26-29. 19 days total. The job might carry on into June as well, depending on the successful use of already extracted data on my end. Stocks: The number of stocks that we will be working with will range between 20-30, with possible updated and newly introduced stocks along the way. Data: The data will have to be submitted at the end of every trading day. The tick data, and hence the number of trades, must be wholesome and consistent with the data being put out by the markets themselves. Example: If there are 2000 trades of a particular stock on a given day, there must be 2000 lines of tick data to reflect that. A variance...
Category: Data Analysis       

m****lry
 [?]
Sign in to view client's details.
| m****lry
|    United States
Fixed Price: $80 - $100   |  Posted: May 02, 2015  |  Ends: 13d, 15h  |   4 Proposals
To design a research project. The paper- a management report: Describe the structure of a research project to address the issue described in the scenario below. The Central Park of Ireland published CP87, 'Macro-prudential policy for residential mortgage lending', in October 2014. The proposal has been subject to much comment from political parties, property firms, media outlets, advocacy groups and others. Design a research project to identify the actual future effects (2015-2018) of this policy on either ? Property prices or ? Home ownership patterns The paper should address in some detail, decision made and issues arising in relation to: 1. Research definition 2. Research strategy 3. Research design and methodology 4. Sampling methods (if any) 5.Research instruments used 6. Data analysis techniques proposed 7. Estimated timeline and budget for the research The paper should explain briefly not only why a particular approach was used at each stage of the research process, ...
Category: Academic Writing       
Preferred Location: United Kingdom

A****d01
 [?]
Sign in to view client's details.
| A****d01
|    Ireland
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: May 02, 2015  |  Ends: 13d, 1h  |   14 Proposals
I need a spreadsheet that will be able to run graph reports with the click of a button that are based on segments of data contained in the primary sheet. Need the ability to ad median, mean, average and additional lines on the graph with ease via one input field that will reflect across all the tabs/ graphs. From the main tab, the data will need to segment into separate tab sheets of 15 sections. I think it is macro / v-look up function??
Category: Data Analysis       
Skills: Microsoft Excel       

j****y81
 [?]
Sign in to view client's details.
| j****y81
|    Australia
Fixed Price: Not Sure   |  Posted: May 01, 2015  |  Ends: 12d, 22h  |   22 Proposals
Looking for someone to create and Excel VBA script for me. Basiclly, it will be a file lister (folder & subfolders). All filetype are tiff. Some are 1-Bit and some 24-bit. The macro will list (show) only the 24 bit then change the file extensions to jpg (replacing the tiff in the same folder). If it could use multiple threads to preform this and increase the speed, that would be awesome. Must be a functioning excel not just the script.
Category: Other IT & Programming       
Skills: Excel VBA       

a****ley
 [?]
Sign in to view client's details.
| a****ley
|    United States
Hourly Rate: $15 - $20 / hr   |  Duration: Not Sure  |  Posted: May 01, 2015  |  Ends: 11d, 23h  |   16 Proposals
I need a macro (or maybe multiple macro's) to create separate tabs from the list of items contained on the summary tab. Each of the created tabs will need to be formatted the same and will need to add several rows of data. I will have seven separate files in which I will have already created the summary tab. The attached file is a sample of what I'm talking about. I am working under a tight timeline and will need this by Tuesday 5/5 at 5pm edst. I am available to discuss further and am open to ideas that can help me get this done as quickly and efficiently as possible.
Category: Other IT & Programming       

M****714
 [?]
Sign in to view client's details.
| M****714
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Apr 30, 2015  |  Ends: 11d, 15h  |   31 Proposals
When filling out a button on the excel form the triggered macros displays an error. This was written by another employee that is no longer with the company. We have copied the files to our system.
Category: Software Application       
Skills: .NET Framework, PHP, VBA, IMacros, Excel VBA       

D****tra
 [?]
Sign in to view client's details.
| D****tra
|    United States
Fixed Price: Not Sure   |  Posted: Apr 29, 2015  |  Ends: 85d, 14h  |   9 Proposals
Hello and welcome. My name is Rob Sugar. I am the founder and president of a Weight Loss and Emotional Eating company in Canada. We are seeking a multitalented professional marketing strategist to develop new marketing initiatives to generate new customers. Job Description: Your responsibilities: - Create highly cost effective strategies to generate new clients - Review and analyze our current marketing initiatives - Conceptualize unique marketing programs to increase customer acquisition - Collaborate, coach and consult with senior management to develop new marketing plans - Write brief reports outlining goals, specific tasks, to list lists and action plans - Implementing and managing marketing initiatives is optional Your qualifications: - Strong professional marketing background employing micro and macro strategies - Ability to assess our current incentives and independently initiate new marketing ideas - Excellent analytical skills - Strong creative skills - Proven ability t...
Category: Marketing Strategy       

C****now
 [?]
Sign in to view client's details.
| C****now
|    Canada
Hourly Rate: $10 - $15 / hr   |  Duration: 1-2 weeks  |  Posted: Apr 29, 2015  |  Ends: 10d, 12h  |   5 Proposals
Requesting Excel/Macro application experts. I need to have one activity automatically produced. I'm using a SAAS based solution software. I need to have my reports from the cloud application automatically exported to excel and formatted correctly. Please let me know if you can automate this task. Thank you
Category: Data Analysis       
Skills: IMacros, Excel VBA       

j****pla
 [?]
Sign in to view client's details.
| j****pla
|    United States
Fixed Price: Less than $500   |  Posted: Apr 29, 2015  |  Ends: 10d, 12h  |   15 Proposals
I have created a basic outline of two workbooks that need to be created. 1. Create template workbook from associate summary1 'create books' sheet for each name listed in name field when create workbook button is pressed for corresponding field. Save workbook as name field in folder listed in file path field on same page. Template Workbook: 2. On 'dashboard' sheet, clicking on the add to funnel button adds the fields listed above in red are added to corresponding columns in the 'funnel' sheet in same workbook. 3. Fields listed with an asterisk (*) are required to input for macro to work. (pop up error optional). 4. Fields with validation are to have drop down selection boxes. 4.a. For lead source, validation drop box items to be validated from input sources (in green) in Associate Summary1 workbook 'store dashboard' sheet. 4.b. Probability validation has drop down selection of 25%, 50%, 75% and 95%. 4.c. Apt. Made? validation has drop down selection of yes or no. 5. When fi...
Category: Other IT & Programming       
Skills: Excel VBA       

C****tor
 [?]
Sign in to view client's details.
| C****tor
|    United States
Fixed Price: Less than $500   |  Posted: Apr 29, 2015  |  Ends: 10d, 10h  |   8 Proposals
High level: Import, parse and upload zipped CSV file received daily in google apps to different google sheets based on data in column inside CSV. ... To-date I am getting a zip file emailed to my google apps, which contains a CSV file. I am looking to take this CSV file and based on data in a column upload it to a google sheet... I attached a sample file: In column B, you can see there are two dlsources: visionapi001, visionapi0dealtop I currently manually take this report, and copy and paste the data into two seperate google sheets... one for visionapi001 and the second for visionapi0dealtop ... As additional data gets added into column B I want additional google sheet files to be created automatically. .... I would like this to be automated with some macro. I'm not married to google sheets for this solution, but I am interested in exposing this data to my partners via a persistent URL. In my ideal scenario, I embed this data inside my wordpress based intranet. ...(ID: 72...
Category: System Administration       

i****han
 [?]
Sign in to view client's details.
| i****han
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Apr 29, 2015  |  Ends: 10d, 7h  |   6 Proposals
I would like a macro inserted in to my microsoft word document (report template) so that i am able to insert a number of photos at the same time, instead of one at a time. I am looking for the photos to be sized so that they would insert as 10 per page (5 down each side), obviously with nice spacing in between.
Category: Other IT & Programming       

l****014
 [?]
Sign in to view client's details.
| l****014
|    United Kingdom
Fixed Price: Less than $500   |  Posted: Apr 28, 2015  |  Ends: 9d, 20h  |   8 Proposals
Attached is the example of an actual audit XL Spread Sheet that I have used. I will carry out my audit based on 1 - General Safety 2 - Dive Control 3 - Twin Lock Chamber 4 - Divers LARS (LARS 06) 4 - Divers LARS (LARS 13) 5 - Diving Basket 06 5 - Diving Basket 13 9 - Diver's Umbilicals 10 - Diver's Personal Equipment 11 - Compressors 12 - HP Air and Gas Storage As I carry out the audit, I only populate (fill up) the 3 columns: "C/NC/OS", "Remarks" and "Cert Issued". At the end of the 2nd day (normally the audit lasts 2 days), I have to provided a summary of items that have been audited as: NC and OS for each of the section audited but further placed under various Categories; namely: Record of Inspections- NC (The item is Non Compliant due to some reason but NOT because of Certification ) In this case the "C/NC/OS" column will be filled up with notation "NC" but has the "Cert. Issued" column blan...
Category: Database Development       
Skills: Excel VBA       

s****343
 [?]
Sign in to view client's details.
| s****343
|    Malaysia
Fixed Price: Not Sure   |  Posted: Apr 28, 2015  |  Ends: 9d, 13h  |   10 Proposals
Online training company is looking for a sharp, organized Customer Happiness Expert to join our team. We are a growing company with a formidable catalog of online and live trainings. We are looking for a detail-oriented, efficient, friendly person to work with us to ensure that our customers/students have a quality experience. We have a world-class brand and change lives every day. This position is about making sure that customers are getting continuous clear great service. Since we are a training company, this position requires great written communication skills and ability to review a customer's journey to make sure they are getting what they need. Responsibiities will include: Responding to customer service by email (as needed) Writing Zendesk Macros (responses to email queries) Write & edit course instructions & directions Write & edit email sequences (based on current models) Troubleshoot and/or develop FAQs for purchasers and students Review online membership si...
Category: Customer Service...       
Skills: Customer Service, Email       

P****elp
 [?]
Sign in to view client's details.
| P****elp
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Apr 28, 2015  |  Ends: 9d, 0h  |   6 Proposals
We are currently going through a re-branding process and we need to re-brand our Word Documents. We need someone with highly advanced Microsoft word skills that includes design, macros and general word styling. We have 5 documents that is an urgent job request, however if we are satisfied with the standard and speed of the completion we may extend the project.
Category: Other - Writing Services       
Skills: Business Writing, Content Writing, English       

E****dAU
 [?]
Sign in to view client's details.
| E****dAU
|    Australia
Fixed Price: Not Sure   |  Posted: Apr 28, 2015  |  Ends: 9d, 0h  |   11 Proposals
We are looking for an Excel expert, preferably with SQL Server experience as well. We need to deconstruct a 3 workbook, VBA macro driven tool (see link below to download and evaluate). The first piece of this will be to trace the calculations, functions, macros and methodology used to calculate the results in the Cell Range H372:I385 on the 'Results' worksheet of the Public Tool.xlsm workbook. We will need the following as outputs: - Equation traces and clear documentation of data flow for these results - Summaries of data tables needed to recreate these results - Extraction of all data into stand alone tables with clearly labeled relational information for transitioning this to SQL Server. Please include in your bid a detailed explanation of your approach, and an example of the documentation output that would accompany your work. Tool can be downloaded below:   [obscured]  /NR/rdonlyres/3F4F3002-B613-4139-8533-DA4A2A403FFD/0/CPUCPublicTool.zip
Category: Data Analysis       
Skills: Microsoft Excel, SQL, Excel VBA       

a****ker
 [?]
Sign in to view client's details.
| a****ker
|    United States
Fixed Price: Less than $500   |  Posted: Apr 27, 2015  |  Ends: 8d, 20h  |   30 Proposals
I need a few simple macros created for this excel workbook. The macros need to have the ability to work with variable sets of data. For example, if the report is created off of a document that online has 50 lines of data, it will still need to be able to work with 100 lines of data. I have attached the raw data and then the 3 formatted reports that we will need to pull from it. Please let me know how long it will take to complete these projects and then an hourly rate for potential further work on this project. I have also included an instructions tab in the workbook.
Category: Other IT & Programming       
Skills: Excel VBA       

j****e08
 [?]
Sign in to view client's details.
| j****e08
|    United States
Fixed Price: Less than $500   |  Posted: Apr 27, 2015  |  Ends: 8d, 13h  |   9 Proposals
VBA Development Air Application Development Excel Macro Business Accumen Job Description: We're looking for a Database expert to help us create applications and infrastructure to maintain our data. Overview: I have a series of data that is in an excel file that I receive weekly. The data comes in several different formats I can have it in weekly numbers, monthly numbers. The data is specific to a provider and associates providers with products they have used. The other set of data is specific to providers and associates providers with the products and vendors that provide that product. The attached excel MARKET-BLAHBLAH.xls is one format for one market, in weekly data. There can be several hundred rows of data this is just an example. The monthly data would be the same only instead of column heads of weeks it would be in months. Here are the things I need the app or excel macro to do: - Allow me to select my product/products and which market they belong to so that data can comp...
Category: Database Development       
Skills: MySQL Administration, PHP, VBA       

d****pro
 [?]
Sign in to view client's details.
| d****pro
|    United States
Fixed Price: $500 - $1,000   |  Posted: Apr 27, 2015  |  Ends: 8d, 9h  |   7 Proposals
Hello, looking for an app developer to create a macro-budgeting app. It'll require building a simple budget. It'll take a starting value and add and subtract custom recurring and 1 time expenses. It'll take the running monthly balance and create awesome graphs. These platforms look great:   [obscured]  /2013/12/03/build-mobile-apps/ I would like to know your thoughts. There will be no linking to bank accounts/credit card accounts. Please share apps you've developed and their ratings in the respective app stores.
Category: Mobile Applications       

a****009
 [?]
Sign in to view client's details.
| a****009
|    United States
Fixed Price: Less than $500   |  Posted: Apr 27, 2015  |  Ends: 5h, 44m  |   7 Proposals
Create a questionnaire in Excel which asks users for inputs on about 10 elements. The questions will be answered iteratively and the total outputs must be consolidated into a summary scorecard. The questions, which are related to evaluating the ecommerce presence of a product, are all provided - your task will be to transform them into a user-friendly interface. Users will evaluate multiple products (on each of the 10 elements, which have 2-10 sub questions) and you will consolidate their answers in a colour-coded scorecard. Final product must also be usable on iPad (if possible?) as well as PC (Excel 2010). Deadline is May 8th, including all testing/trouble-shooting.
Category: Research & Surveys       
Skills: Microsoft Excel, Excel VBA       

l****one
 [?]
Sign in to view client's details.
| l****one
|    United Kingdom
Fixed Price: Less than $500   |  Posted: Apr 27, 2015  |  Ends: 8d, 2h  |   6 Proposals
Should take between 20-60mins for a experianced Coder.. Therefore budget is between $10-$45 Create Libreoffice Macro to delete all but needed columns in .CSV by looking at column header, then remove all "[" "]" Characters from .CSV. e.g "Mobile Number" [+6143756564] Also delete all ROWS that contain a duplicate mobile number. Mobile number needs + symbol at beginning to match with current database. Next. In one column with header "SMS Sent" delete all but last character in cells. The last character will be an Emoji icon which not a standard character so CSV will need to be opened with UTC-8 settings applied. what is left remaining will basically be the last SMS sent to each unique mobile number, displaying only the last character which will be an emoji icon which we will use as an tracking device to update the status of communication with customer via SMS.
Category: Other IT & Programming       
Skills: VBA, Visual Basic       

l****man
 [?]
Sign in to view client's details.
| l****man
|    Australia
Hourly Rate: $10 - $15 / hr   |  Duration: Not Sure  |  Posted: Apr 26, 2015  |  Ends: 7d, 20h  |   29 Proposals
Hi, I have an excel spreadsheet from a "source" that contains data in several columns and rows. I need an automation process to present the data in pivot tables and charts on a separate tab. The process must be automated so that every time a spreadsheet is pulled from the "source", the charts and pivot tables will adjust to the data. (The columns are always at the same place but the number of rows vary.) I will design the charts and pivot tables the way it should be, I just need the macro automation for building these. Nice and easy job, this is a walk in the park for anyone with average VBA skills who knows how to adjust the code for changing ranges.
Category: Data Analysis       
Skills: VBA, Automation, Excel VBA       

p****gen
 [?]
Sign in to view client's details.
| p****gen
|    Canada
Fixed Price: Not Sure   |  Posted: Apr 26, 2015  |  Ends: 7d, 10h  |   21 Proposals
Need immediately MS-Excel and MS-Word manipulator with VB/macro knowledge for following tasks- 1. Excel formula building 2. Data manipulation in excel 3. Write macros and scripts for transferring between excel and word and vice-a-versa
Category: Software Application       

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