offline
Last seen: Apr 16, 2014 2:04 PM EDT
Hire Me!
Rate: $15.00 USD/hour
Follow Invite to Project
 

JayLancer43

VBA/Macro Expert of entire MS Office suit (Excel/Word/PPT/Outlook/Access etc) for all versions.

Username: jaylancer43

  • Has made a deposit.
  • Has verified their email address.
  • Has completed their profile.
  • Has verified their secure phone number.
  • Verified
  • Payment is verified.

Location: Paris, India

Member since: October 2012

Reputation:

5.0/5

(61 reviews)

5.4
[see more]

6 users have recommended this freelancer.

My projects:

  • $45 USD
    5.0
    Profile image for Seller livingresearch

    livingresearch

    Yesterday

    Very dedicated and excellent skills! Thanks a lot!

    Project Description:Hi freelancers, Please check the attached file. The xls file contains different price scenarios for a cosmetic product based on varying concentrations of the ingredients. I need a freelancer that could...
    [more]
  • $105 USD
    5.0
    Profile image for Seller rittermp

    rittermp

    4 days ago

    Project completed on time with tight deadline and met my expectation.<br/>

    Project Description:have updated the worksheet to include another manufacturing location reports &amp;amp; charts to generate 1) tonnage consumption by facility by year (if no data for the year, footnote on bottom of chart the specific facilities...
    [more]
  • [Sealed]
    5.0
    Profile image for Seller themoonmonkey01

    themoonmonkey01

    14 days ago

    It was a pleasure working with jaylancer43, his VB work was brilliant and did exactly as requested in the brief. Highly recommend and will certainly contact him again for my next Excel project.

    Project Description:I would like to put the reference code in 10 cell values and then 10 images to appear after clicking a macro button, using part of the data in the first set of cells to generate the image source (URLs)...
    [more]
  • $187 USD
    5.0
    Profile image for Seller hagof

    hagof

    Mar 12, 2014

    World-class A+++++++ professional who comes with a lot of maturity, expertise and trust.He is strongly recommended as a great professional and inspiring freelancer<br/>

    Project Description:Modeling dashboard for spend efficiency and optimisation
    [more]
  • $30 USD
    5.0
    Profile image for Seller tiger234

    tiger234

    Mar 11, 2014

    Very efficient. Delivered even more than requested.

    Project Description:Hello, I have two list of people with their center of interest (a, b, c, d, e, f, g...) I would like to do two things with that : a/ (random) If I have a list where two name of people are put one...
    [more]
  • $250 USD
    5.0
    Profile image for Seller shroomjunkie

    shroomjunkie

    Mar 10, 2014

    Fantastic work !! Difficult job completed on time and under budget. Highly recommend this freelancer and any job type. Thanks

    Project Description:This task involves fetching a tree view hierarchy from existing website and create those hierarchy into multi-level dependent drop-downs. Source website keeps on updating so the length of hierarchy and depth of hierarchy will keep on varying...
    [more]
  • $8 AUD
    5.0
    Profile image for Seller iancampbell

    iancampbell

    Mar 9, 2014

    fantastic will use again thanks very much<br/>

    Project Description:i have forgotten password need to unprotect
    [more]
  • $60 USD
    5.0
    Profile image for Seller komorin

    komorin

    Mar 6, 2014

    Jay is the best freelancer I have worked with. He solved all the problems in a professional manner with great results. I will definitely work with Jay on more projects!

    Project Description:I have an excel-sheet with the following columns; &quot;Date for order&quot;, &quot;Name of customer&quot; and &quot;Order amount&quot;. The excel-sheet contains all the orders that were made in my shop for the past 2 years. I need to get as much data as possible about the returning and non-returning customers and the orders...
    [more]
  • $150 USD
    4.2
    Profile image for Seller MediaMARKAu3058

    MediaMARKAu3058

    Mar 6, 2014

    I wa sa first time hirer, very patient with my endless questions.

    Project Description:as discussed previously I have accepted his bid in copius correspondence on this project. I have received staisfactory responses and wish to complete the payment by releasing Us $!50 to Jaylancer43.
    [more]
  • $50 USD
    5.0
    Profile image for Seller GeneLigeonExcel

    GeneLigeonExcel

    Mar 5, 2014

    Jay is wonderful to work with. He understood the project very quickly and was able to provide multiple solutions. Once I decided on the best suited solutions, he was able to quickly deliver.

    Project Description:I need to take input from one excel file into another formatted file, by use of a macro. The destination files are all different in formatting. I can further explain once we talk one on one. Basic...
    [more]
    JayLancer43 has not completed any projects.
  • $25 USD In Progress

    Convert data in format to import into Magento database

  • $100 AUD In Progress

    As discussed. work awarded to jaylancer

  • $250 USD 2 days ago

    i need a program that you can trade itemes from vac banned accounts ! Counter Strike Global Offensive

  • $1500 USD 3 days ago

    I want an for control of Tasks related to Entities and Events or Reports which relate to these Tasks.I have created the database structure and the relationship between the tables I need someone to create the forms and all of the code.I&quot;m looking for someone with a lot of experience and that will help with your expertise to enrich the program and create an interface pleasant, simple and intuitive.The database would be in ACCESS in beginning or already in SQL or mySQL and language VB, VB, C#, PHP or another, everything depends on the offer. WEB application and future with interface in Android or IPhone has great interest.There are only four main forms with some connections complex and calls for other very simple for introduction and editing related tables (auxiliary).The software must work in network, with control access by user in every form and field of application, connection to Crystal Reports for printing documents and listings, record (log) of all changes in the fields of the records of main tables and even auto send email&quot;s or sms with information of records.Someone with experience and a code base already built with modern interface and part of the functionalities referred to will be greatly appreciated. Join Print&quot;s of examples will be proposed.The solution must be provided with code duly commented on, the application will be our by agreed value and may not be resold by contractor.This project has several phases, this is the initial phase, following others.Please make a proposal only if you are a professional with lots of experience and will be comfortable with projects identical, as I, you will not want to miss your time.Thank you

    [more]
  • $250 AUD 3 days ago

    a social network site, similar to twitter

  • $244 SGD 3 days ago

    I&quot;m looking for someone to design a large, detailed iPad game called &quot;gadget.&quot; I have attached GadgetApp.txt which outlines this game.This game will be made in HTML+CSS+JavaScript and compiled for iPad using Apache Cordova on http://build.phonegap.com/You will need to be familiar with HTML5, CSS, and JavaScript, as well as Cordova. You will also need to design a server-side API (preferably in PHP) to store information about the app&quot;s users.Finally, you will need to be experienced with Graphics Design and User Interface to build a nice, clean looking app. The app should be similar to apps by SuperCell.

    [more]
  • €500 EUR 3 days ago

    Hi,we use salesforce to manage our Sales and now need Data from our IO´s (insertion orders) in our backend (php).We need a script where we enter the IO Number and get back all details for that IO as array.Also we need detailed instructions what we need to do to activate the salesforce api.Please describe shortly how this can be done and how long it takes roughly.

    [more]
  • $100 USD 3 days ago

    I have a Excel 2013 workbook that has several sheets.I need to have the data that gets entered on 1 page transfer to another page that I use to print receipts. The reciept template has to be able to print 50+ pages with one click of a print button. Data then is transferred to a master sheet that is like a report that I want saved as pdf and emailed on a daily basis. I have outlook and a server if needed for emailing. Don&quot;t bid if you are not able to start this today. https://www.dropbox.com/s/a38j5qj0p0zzius/Screenshot%202014-04-10%2018.02.25.pngI can explain more once hired over chat on team viewer.

    [more]
  • $88 USD 3 days ago

    Simple requirement is to have an excel with three columns one, Contact Name, second Contact Email address, third Contact TechnologiesTool should be able to do:1. Read the master sheet which has the data for all the contacts2. prepare an email addressed to individual Contact names (separate emails for each Contact), with pre-defined common template.3. Send the email from outlook, with an attachment (preferentially excel) having the information Contact name, Email address and technologies. (ONLY related to that contact where the email is being sent.4. This process needs to happen for all different contacts on the sheet (Approx 200)

    [more]
  • $166 USD 4 days ago

    I am looking for a female voice over for IVR, i have couple of recordings which needs to be done at the earliest. I am looking for only female with Neutral Accent. Send me sample of your voice recording i will select in 48 hours. There are lot of similar project for the the right candidate.

    [more]
  • $100 USD 5 days ago

    I have a webservice that builds a XML with data taken from a standard form. Need to automate the process taking data from CSV or Excel File to automate the process without user input, just loading the file that contains same information. Please write PM to let you know Excel-CSV file and webservice definition.

    [more]
  • £100 GBP 6 days ago

    We have 1 CSV file sent daily within this file we need to split the file based on the entries in 1 of the columns so they have seperate CSV files createdalso the csv files created cannot exceed 75 Lines so this will need to be taken into account and additional files created if requiredthe names of the files must be kept as original with suffix which i will advise onSo 1 file split into possibly 3 , then if any exceed 75 lines to create additional

    [more]
  • Rp5555555 IDR 6 days ago

    Program ini di buat dengan menggunakan software Notepad++ dan di compile(dijalankan) dengan software CLISP .Tujuan di buatnya progam ini adalah untuk mempermudah kinerja manusia, seperti :* Fungsional.lisp => program tersebut di buat untuk membuat atau menghitung suatu tekan suhu dan meng-konvertnya , dan juga menghitung jumlah mata uang dari dollar ke euro .* Interval.lisp => program ini hanya melibatkan peranan&quot; aritmatika seperti kali, bagi jumlah dan pengurangan.* Kasus1.lisp => program tersebut menjelaskan tentang cara menghitung dari inch to centimeter, yard to feet dan masih banyak lagi.* Kasus2.lisp => program ini di buat untuk mengukur sebuah volume segitiga dengan inputan angka bebas.* Kasus3.lisp => program tersebut sangat sedrhana, hanya untuk menghitung luas segitiga.Sekian project saya ini.

    [more]
  • $6666 AUD 6 days ago

    HI there,We are after an app for the school to complement the website (website will only be shown to the developer who gets the job).We have an art director for design already.Push notifications – messages and remindersAbsentees notificationsEvents/CalendarNewsletterMap of the CollegeP and F updatesUniform updates and requirementsGalleryNewsLinks to afterschool and vacation careCurriculum/Subjects linksCould i please get an estimate, then we can get a full brief and advise what further questions we need to ask the client.Regards

    [more]
  • $250 USD 6 days ago

    Зополнять опросные анкеты.остальное в лс

  • £100 GBP 8 days ago

    We have a large excel spreadsheet and some of the phonenumbers have become corrupt displaying as things like 4,41405E+11. We have found on some it still reads 4.41761E+11 even when you increase the cell width, but when you click on the cell, you can see that the number is actually 441761470142. I did a =text(cell,”0”) and then saved as values and the number then displayed correctly, we are looking at recovering all the numbers. The sheet is attached, when quoting I would be grateful if you could provide some samples of recovered data as well as the cell refrences for me to check.https://www.transferbigfiles.com/d13e5edb-469d-4612-9cbe-5fa65f511fbb/X-r8XeWb6922a-_h4sMnjw2

    [more]
  • $244 USD 8 days ago

    We have an existing php/mySQL software due to upgrade.It is a tracker for enquiries.Need a reliable and fast programmer to finish the job within 2 weeks.Please email for more information.Thanks.

  • $30 USD 8 days ago

    I need a small script/software creating to test a CSV list of websites to see if they are using Joomla or wordpress. This can either run from the meta data, or from the login url.Looking forward to receiving your bids.

    [more]
  • £250 GBP 8 days ago

    I have a multi series line graph which fits a set of data in a cdv file. I need to add a couple of pieces of functionality;1. Be able to remove and re add data which should be included in the graph, able to select it by something simple like clicking on the name in the legend and it &quot;greys&quot; out the name and removes that data from the line graph.2. Use the data from the multiline graph to make an average line that is shown on a different graph. The data that is removed from the original graph should make sure it is not included in the average one too if not selected in the original

    [more]
  • $111 USD 9 days ago

    Context: Creating an excel sheet with a schedule for 95 individuals. Use excel functions and VBA macros to place individuals to perform a different duty every week. Everyone should have approximately the same amount of time at each duty.I have 5 teams of 19 individuals. Every four weeks, the workers switch to a different location. There is a total of 95 spots to be covered:- Site 1: Has 12 spots- Site 2: 6 spots- Site 3: 3 spots- Site 5: 9 spots... etc.- Vacation: 8 spotsEveryone needs 4 weeks of vacation every 1 year.I already have an excel with this information:- Name of individual- Level of individual (either 1, 2 or 3 - depending on their experience)- List of locations arranged by which week of the year.I will need VBA macros to achieve the following:- Ensure that each spot is covered by an appropriate person with an appropriate level (e.g. site 2 has 6 spots, 3 must be covered with a more experienced person level 2 or 3)- Assign each worker to a location.- Ensure there are no duplicates.- Everyone needs to have the same number of exposure to each site.More details will be provided.

    [more]
  • $222 USD 9 days ago

    Aid Manager in running an website1) Discuss or implement email marketing designs2) Schedule and send them in a timely fashion3) Chat with client, answer questions as need4) Respond to client emails 5) social media marketingRequires 10-20 hours of work.

    [more]
  • $11 USD/hr 9 days ago

    i need help to develop a drupal site. it is a new site where i hav made the description of the project and will work together with the developer to make the site. please bid if u are good at drupal and i will get back to u and discuss ur skills and the requirements

    [more]
    JayLancer43 does not have any open projects.
    JayLancer43 does not have any work in progress.
[see more]

Portfolio

[see more]

Résumé

Experience

Business/Data/Reporting Analyst

Mar 2008 - Present (6 years)

Capgemini

Education

MBA

University of Wales, Cardiff

2006-2008

Bachelor of Engineering

Nagpur University

2000-2004

Certifications

Business Analyst

Capgemini

Completed Business Analyst certification successfully.

Publications

Impact of Portable ICTs on Learning and Productivity.

MBA Dissertation

Impact of Portable ICTs on Learning and Productivity.