Save this Search
     

All Jobsexcel macros

 (42 results)  
Sort by:
  • Posted Date
Results for 'excel macros'
Fixed Price: Less than $500   |  Posted: 2h, 21m ago  |  Ends: 14d, 21h  |   4 Proposals
An Excel spreadsheet used for recruiting and tracking needs to be converted in an Access database. The database will be used for recruiting purposes and will track valuable information on recruits and their progress. The current spreadsheet uses macros and has the ability to run specific reports. However, formulas used are very basic. We mostly need to track informational data, not numbers.
Category: Recruiting       
Skills: Database, BASIC       

m****h53
 [?]
Sign in to view client's details.
| m****h53
|    United States
Fixed Price: Not Sure   |  Posted: 2h, 24m ago  |  Ends: 14d, 21h  |   2 Proposals
Hello, If your reading this, then your an expert excel / API coder who can build awesome macros, or someone with a new type of solution. If your not, then no need to apply. I have a client that needs his database imported from his patient management system, into Infusionsoft CRM. His client management system doesn't have an open API, so he is going to export a CSV every day into dropbox with his current client list. Each client will have a unique ID (this would be the client management systems ID, NOT Infusionsoft ID) It is your job to get this patient management CSV uploaded to a dropbox folder, and automatically merge it with his existing database within Infusionsoft. I assume this can be done with an Excel Macro, as I had someone do something similiar to this with that program. I'm not a coder, so I don't know how this can be achieved, I'm open to suggestions on what this will take. Please tell me how you will accomplish the following (as well as a quote) 1. Take lates...
Category: Database Development       
Skills: Microsoft Excel, MySQL Administration, PHP       

p****tho
 [?]
Sign in to view client's details.
| p****tho
|    United States
Hourly Rate: More than $50 / hr   |  Duration: 4-6 months  |  Posted: 4h, 57m ago  |  Ends: 14d, 19h  |   14 Proposals
The ClearPoint Data Analyst is responsible for providing guidance, quantitative analysis, and expertise in the interpretation of multiple data sets. He/she will be asked to build reproducible reports and dashboards ? for one of our new product lines ? as we work towards proving our initial hypothesis. The ideal candidate will have a desire to grow the position, improve our data gathering efforts, and standardize our approach to analytics. This person will also be asked to assist in R&D efforts by developing data models and seeking correlation between multiple data sets, potentially even assisting with the development of corollary algorithms. Responsibilities: ? Extract and manipulate data from multiple systems internally and externally ? from client's systems ? to create statistical reports and dashboard visualizations. ? Utilize a Business Intelligence tool to generate and distribute scheduled reports and dashboards. ? Review raw data from training assessments & surveys and...
Category: Data Analysis       

B****235
 [?]
Sign in to view client's details.
| B****235
|    United States
Fixed Price: Less than $500   |  Posted: 6h, 35m ago  |  Ends: 14d, 17h  |   22 Proposals
EDIT: by database I am referring to a simple Excel list Hi everyone, I am looking for a skilled VBA professional to develop an automation macro for a database. Following is an overview of the end-result: We have a database A, with a list of different types: O, P, Q, which all have different characteristics: height, weight, age. All characteristics are written on the same row as the type, inside the neighbouring columns. Also, we have database B, with identical layout as database A, where there are different instances of those database A types: O-1, O-2, P-1, P-2, Q-1, Q-2. All instances of the same letter have the same charateristics, as declared in database A. Since the charateristics (height, weight, age) change over time, I need a macro which connects these databases i.e. if something in database A is changed it will, by the click of a button, update all the instances in database B. To add: It will also automatically identify which types have changed and will offer you checkb...
Category: Database Development       
Skills: Microsoft Excel, Excel VBA       

k****und
 [?]
Sign in to view client's details.
| k****und
|    Canada
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: 19h, 26m ago  |  Ends: 14d, 4h  |   16 Proposals
Need a document similar to attachment, but more complex. Images will be provided. Asset numbers will be provided. There will be changes so please quote hourly rate. Thanks, Bradley
Category: Other IT & Programming       
Skills: Microsoft Excel, Excel VBA       

m****rgy
 [?]
Sign in to view client's details.
| m****rgy
|    United States
Hourly Rate: $30 - $60 / hr   |  Duration: 3-4 weeks  |  Posted: May 04, 2015  |  Ends: 13d, 11h  |   30 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 Excel       
Preferred Location: Australia

H****las
 [?]
Sign in to view client's details.
| H****las
|    Australia
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: May 03, 2015  |  Ends: 13d, 6h  |   6 Proposals
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
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: May 02, 2015  |  Ends: 11d, 13h  |   17 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: 11d, 10h  |   24 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: Not Sure   |  Duration: Not Sure  |  Posted: Apr 30, 2015  |  Ends: 10d, 3h  |   34 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: 84d, 2h  |   11 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: 8d, 23h  |   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 28, 2015  |  Ends: 8d, 7h  |   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: 8d, 0h  |   11 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
Fixed Price: Not Sure   |  Posted: Apr 28, 2015  |  Ends: 7d, 11h  |   12 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: 7d, 7h  |   31 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: 7d, 1h  |   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
Hourly Rate: $10 - $15 / hr   |  Duration: Not Sure  |  Posted: Apr 26, 2015  |  Ends: 6d, 8h  |   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: 5d, 22h  |   22 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
Fixed Price: About $20   |  Posted: Apr 25, 2015  |  Ends: 4d, 16h  |   18 Proposals
hi Need Macro or VB to split data from text to excel i need to upload text file and split data in excel to there field as shown below. attached data- excel and text files..... need by monday.. 882448 Adam Hunt   [obscured]   67 Prince Street WINEGROVE New South Wales 2460 (02) 6728 0519 Austraila male "Tuesday, February 11,1958" 72.8 167 A+ Adam Hunt Rollins Cecelia Aurora Victoria 3816 Austarlia (03) 5360 5989 YES NO YES NO YES HO_Y5K-AU-10852 "Tuesday, February 11,1958" $250.00 Adam Hunt Mary Rembes1966 DPX-AU_8SSE-115554 "Tuesday, February 11,1958" male Discover PHENTERMINE 2 MG 60 $8.42 $505.00 $20.00 $525.00 Not Available. 1 IMAGE NAME -- NEED TO TAKE FROM NOTEPAD FILE NAME. 2 RECORD NO-- 882448 3 CUSTOMER NAME-- Adam Hunt 4 EMAIL ADDRESS--   [obscured]   5 RES_ADDRESS-- 67 Prince Street 6 CITY_1-- WINEGROVE 7 STATE_1-- New South Wales 8 ZIP_1-- 2460 9 PH_N01-- (02) 6728 0519 10 C0UNTRY_1-- Austraila 11 SEX_1-- male 12 D_BIRTH-- T...
Category: Software Application       
Skills: Microsoft Excel, VB.NET, Visual Basic, Excel VBA       

s****ons
 [?]
Sign in to view client's details.
| s****ons
|    India
Fixed Price: Not Sure   |  Posted: Apr 24, 2015  |  Ends: 4d, 0h  |   7 Proposals
Hello, If your reading this, then your an expert excel / API coder who can build awesome macros, or someone with a new type of solution. If your not, then no need to apply. I have a client that needs his database imported from his patient management system, into Infusionsoft CRM. His client management system doesn't have an open API, so he is going to export a CSV every day into dropbox with his current client list. Each client will have a unique ID (this would be the client management systems ID, NOT Infusionsoft ID) It is your job to get this patient management CSV uploaded to a dropbox folder, and automatically merge it with his existing database within Infusionsoft. I assume this can be done with an Excel Macro, as I had someone do something similiar to this with that program. I'm not a coder, so I don't know how this can be achieved, I'm open to suggestions on what this will take. Please tell me how you will accomplish the following (as well as a quote) 1. Take lates...
Category: Database Development       
Skills: Microsoft Excel, MySQL Administration, PHP       

c****ass
 [?]
Sign in to view client's details.
| c****ass
|    United States
Fixed Price: Not Sure   |  Posted: Apr 24, 2015  |  Ends: 3d, 14h  |   12 Proposals
Programming skills in EXCEL and Autocad Macros. VBA (necessary) LISP, C++ (a plus) Job Description: We're looking for a talented Application Developer to create native applications for our business. Your responsibilities: - Review Design 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 Your qualifications: - A work style that is extremely detail oriented - Strong communication skills - Delivery on schedule and with a high quality
Category: Software Application       
Skills: AutoCAD, VBA, C++, Lisp       

g****upo
 [?]
Sign in to view client's details.
| g****upo
|    Portugal
Fixed Price: Less than $500   |  Posted: Apr 24, 2015  |  Ends: 3d, 11h  |   33 Proposals
Approximate Budget: Less than $500 Category: Admin Support > Data Entry Skills: Computer Skills Data Entry Amazon Listing/Writing Job Location: Freelancer can be located anywhere Posting Period: 15 days Job Start Date: Start immediately Education Requirements: High school graduate or GED Job Title: Amazon Listing Specialist for Hire Job Description: Amazon Listing Specialist Summary: You will enter text into an excel template to list new items for sale on Amazon via "Product Uploads". I will email you the listings to create (or call/Skype) and you enter the data of all parent and child variations. From titles to keywords to upc's and color/sizes, I will pay you for thorough and detailed analytical care. It would help if you have experience selling on Amazon (or any internet sales) and an understanding of current listing practices -or be willing to learn. Familiarity with template building and data macros is a plus. Please see the example below. (I have plenty of used...
Category: Data Entry       

A****ano
 [?]
Sign in to view client's details.
| A****ano
|    United States
Fixed Price: Less than $500   |  Posted: Apr 23, 2015  |  Ends: 3d, 9h  |   20 Proposals
I'm creating an invoice in excel with macros. Need some work to fix it so it prints to PDF correctly. I need the columns to reference the invoice via the headers and not the cell location.
Category: Software Application       
Skills: Microsoft Excel, Excel VBA       

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