offline
Last seen: Jul 17, 2014 1:15 AM EDT
Hire Me!
Rate: $20.00 USD/hour
Follow Invite to Project
 

Awesome Inc

VBA Expert

Username: ZeusMan

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

Location: Chatham, Canada

Member since: August 2010

Reputation:

5.0/5

(94 reviews)

6.1
[see more]

2 users have recommended this freelancer.

  • $32.00 USD
    5.0
    Profile image for Seller gristur1

    gristur1

    Apr 4, 2014

    The only issue I had with this developer is that he seems to be a fairly busy guy and not always available. Make sure you negotiate your timeline with him prior to hiring him.<br/>

    Project Description:I need help with some Excel array functions and queries. Some VBA knowledge is required. 2-4 hours total. Pretty basic stuff. One requirement is that you should be readily available to chat and help when...
    [more]
  • $60.00 USD
    5.0
    Profile image for Seller gristur1

    gristur1

    Apr 4, 2014

    He is great, one of the best developers I have been working with. Highly skilled and smart.<br/>

    Project Description:I need help with some Excel array functions and queries. Some VBA knowledge is required. One requirement is that you should be readily available to work with me on this today for up to 4 hours, sending...
    [more]
  • $125.00 USD
    5.0
    Profile image for Seller groovygeeks

    groovygeeks

    Mar 31, 2014

    Fantastic work .. I will use ZeusMan over and over .. Thanks again

    Project Description:I need you to create 2 spreadsheets that do the same thing . This process should be simple if you know your excel . I have had one done before but lost my sheet .. (sample only includes about 40 items,...
    [more]
  • $30.00 USD
    5.0
    Profile image for Seller delpass

    delpass

    Mar 25, 2014

    Great Job again.

    Project Description:Need an existing MS Excel 2003 Macro changed / rewritten. See the requirements in the attached files.
    [more]
  • $30.00 USD
    4.6
    Profile image for Seller delpass

    delpass

    Mar 24, 2014

    Great and fast delivery of coding needed.

    Project Description:Hello. We need a MS Excel 2003 Macro that creates a “xml” file in the back ground for printing postage labels later. ============================================================== In this job description I will refer to attached files by the file names you can look up to view more details...
    [more]
  • $74.00 CAD
    5.0
    Profile image for Seller pvtiste

    pvtiste

    Nov 13, 2013

    Amazing job : fast and good work. I recommend him!

    Project Description:Hello, I have a CSV file from a survey. Are you able to analyze the data and do some graphs? Thank you
    [more]
  • $19.00 USD
    5.0
    Profile image for Seller zsoltmadlen

    zsoltmadlen

    Nov 2, 2013

    Thank you!

    Project Description:Hello mate how you doing alright?:) I have left 19.5 USD on my account for that price can you tell me about/write me a guide how can I setup this data scraping macro in different sheet becouse now is just...
    [more]
  • $30.00 USD
    5.0
    Profile image for Seller zsoltmadlen

    zsoltmadlen

    Oct 29, 2013

    Best man for this type of job. Easily understand and managed what I asked.

    Project Description:I have Postcodes in column &quot;L&quot; and I want to lookup for the avarage property prices by zoopla.co.uk. &quot;http://www.zoopla.co.uk/home-values/&quot; &amp; &quot;L&quot; contains AB10 1HF than on the page http://www.zoopla.co.uk/home-values/AB101HF get the Zed index value ...
    [more]
  • $40.00 USD
    5.0
    Profile image for Seller kienast

    kienast

    Sep 24, 2013

    Great job, done early and on budget. Have hired before and would definitely hire again.

    Project Description:new project. home page to browse for three different input files FILE 1 is a .txt file this is a revenue file -use order id column as a key between the 3 files -use amount column -in this file...
    [more]
  • $88.00 USD
    5.0
    Profile image for Seller Makaveli19

    Makaveli19

    Sep 18, 2013

    Another great project. Always great quality and always reliable. Thanks!

    Project Description:I would like to create an SEO report tool that allows me to upload 2 Google Analytics reports from different time periods e.g July 2012 and July 2013 (Google Analytics keyword report sample with sample numbers attached)...
    [more]
    Awesome Inc has not completed any projects.
  • $20 USD/hr In Progress

    Hi there, How are you?I need little modify, at macro you did.In sheet Sales, now in column B the same name are in yellow background, I want also yellow background take the same row at column C.Now in column L all the text different to &quot; Posta prioritaria &quot; became in red, also I want copy the text different to &quot; Posta prioritaria &quot; in the sheet labels, for example if ship metod is courier labels will became like :Alexandru Stremtan via Custoza 98/4 46048 Roverbella MN (1 empity row)Courier (arial 9) Labels are already in arial 11, I just want add 1 empity row and ship metod (different to posta prioritaria) at arial 9.Than I need new sheet called Sales 2, Just copy from sheet sales column C, I (paste at Arial 9), J, K, copy with same background of sheet sales Than one more sheet called Courier, in this page I need one button for save just this sheet in (.xls)Just copy from sheet sales the row where the ship metod insn&quot;t &quot; Posta prioritaria &quot;, Copy in Column A (column C from Sales), Copy in Column B (column D, E from Sales), Copy in Column C (column F from Sales), Copy in Column D (column H from Sales),Copy in Column E (column G from Sales), in Column F ( Just make value &quot; 1 &quot;),in Column G (Just make value &quot; 1 &quot;)Waiting your news thanks

    [more]
  • $45 USD In Progress

    Hello,I have attached an excell spreed sheet I want you to work with. You will produce a new sheet with all the scripts in it. I do not want you to modify the old one but come up with the new one. NOTE: THIS JOB IS URGENT, PLEASE DO NOT BID IF YOU ARE NOT READY TO DO THE WORK.The script will do the following:1. the script will have everything on the country room and country tab (except we do not need breezecom and avanguard anymore) country is currently not working right2.the compare rates will remain as they are with the same functions. (except we do not need breezecom and avanguard anymore)2. you will have differenciate tab as it is in the first page what this does is to check all the providers and put the highest rate for that prefix. this is not working properly3. All tabs remain except for &quot;retail with statistics&quot;, &quot;wholesale with statistics&quot;, &quot;reseller with statistics&quot; everything for breezecom and avanguard should also be removed.4. All rates should be in cents 0.01(for 1cent) as opposed to 1.0 for 1cent.5. the getting data is static format. when you click on increase/decrease, you should only get the data for the price that was changed from between old and new.6. The peak offpeak section is only suppose to get the data based on the time. and generate the different data. this is only related to easyconnectbc and easyconnectfc.7. please feel free to add as may tab as you need.8. You have all the files to test with. so Please test properly and feel free to ask any question you may have.the provider folder has all the provider files to populate the data with.

    [more]
  • £61 GBP In Progress

    I need a pop up box entering address fields added to this letter template. The fields needed are: Dear I&quot;ve marked up the attached document to show where the text needs to go. I need a programmer to create this macro/VBA programming for me. Please don&quot;t hesitate to let me know if not clear.

    [more]
  • $39 USD/hr In Progress

    I have some &quot;draw schedules&quot; that I have been using in an old version of Microsoft Excel. These were created with Visual Basic code. I am now starting to experience a number of problems with the macros working and with the schedules in general. I upgraded computers and Excel and I believe the 2 versions of Excel and Visual Basic are not compatible. I have also been told by the person that created these schedules, that Excel has likely quit making updates for the version these schedules were written in, so the error messages will continue and eventually the schedules will not be usable. I need someone to create some new Draw Schedules that will mimic the old ones. I would like to have a template draw schedule made for each of our big clients, so I can Save As and create a job specific schedule as needed.

    [more]
  • $30 USD In Progress

    we want make a macros in Excel. So that we can generate different field to one list.. perhaps how this sample file.. Different entries from line A to E to make a solution how in my sample file. The quantity of the different entries at each line can be from 3 entries until 300 entries. Can somebody help me with this macros? thanks

    [more]
  • $150 USD May 3, 2014

    We are in search of a Data Entry / Admin Assistant who will analyze work pipeline and workflow. Implement scheduling to optimize throughput and efficiency across multiple languages. Increase effectiveness of staff and tools by recognizing opportunities for development and proactively creating new systems and structures. The right candidate must posses strong professional etiquette, organizational skills and attention to detail, fluency in MS Excel, strong interpersonal skills and ability to work with cross-functional teams, strong written and oral communication skills, ability to multi-task, set priorities and work efficiently in a high-paced environment.

    [more]
  • $30 USD Apr 21, 2014

    Export Data from Zillow for Excel1.Use an Excel file containing property addresses to look-up the property record on Zillow.com, export the data, and paste it into the address source spreadsheet in the appropriate columns.2.Assume the method is a VB Macro embedded in the spreadsheet.3.If creating a separate CSV file containing the data is easier, more accurate, or costs less, let’s discuss.4.Please note that I may not have identified all of the potential Fields (data columns) available in Zillow listings since many of the field only appear under specific conditions.Input Source: An Excel file containing address fields. Export: Zillow Field data to be exported listed below.FieldExampleFormatZillow Property URLhttp://www.zillow.com/homedetails/216-Edinburgh-Ln-Petaluma-CA-94952/15756039_zpid/TextStreet AddressTextCityTextStateTextZIPTextZestimate:NumberRent Zestimate:NumberEst. Mortgage:NumberBeds:TextBaths:TextSqFt:TextLot:TextType:TextYear Built:NumberLast Sold:TextParking:TextCooling:TextHeating:TextFireplaceTextDescriptive Paragraph:YOU CAN HAVE IT ALL!! Fabulous 5 bedroom home in West Petaluma located in the heart of Victoria, featuring over 2,500 sq ft of living area with a professionally landscaped backyard that backs up to open space. Master is on the 1st floor and 4 spacious bedrooms are upstairs. Very peaceful setting only a block from Helen Putnam Regional Park with hiking and biking trails. Private playground and tennis courts nearby too!Text--From Charts and Data Table--Zestimate Value:NumberZestimate Range (Low):NumberZestimate Range (High):NumberZestimate Last Updated:DateRent Zestimate:NumberRent Range (Low):NumberRent Range (High):NumberRent Last Updated:Date--From Price History Table-- DateDateDescription:TextPriceNumber --From More Facts:--Last remodel year: DateNotes:1.For any field with no data, return the placeholder “—“ if present or “N/A”, if field is blank.2.Price History Table: Note: “Historical data not available for this property” can be returned.3.Price History Table: Return only most recent entry from this table.4.If property record not found on Zillow, return “N/A” in the Zillow Property URL field.

    [more]
  • $244 USD Apr 7, 2014

    Very simple work, we have an eBay store with 8845 items most items don&quot;t have UPC codes, what it needs to be done is: 1st to add UPC codes in every eBay item, (i will provide the codes) 2nd part of the work is: to put up every item from eBay 8845 items to our buy.com (rakuten) marketplace account, just copy and paste all description, picture, upc code and price. you can also upload the pictures from our website www.snapitdigital.comits quick just copy and paste from ebayplease if you dont have any feedback don&quot;t bidhttp://stores.ebay.com/snapitdigitalif I will be happy with the work I will also need the same job to be done for other sites for extra cost

    [more]
  • $155 USD Feb 11, 2014

    I have a large and complex excel worksheet that relies heavily on ranges, offsets, reference cells, formulas, worksheets, buttons and more. I need an expert with VBA and excel to make some upgrades and fixes to the worksheet project. Currently calculations only work with type &quot;labor adjustment&quot; for the product section of the worksheet. The worksheet calculates consolidated GP%, cost, labor and quite a few other items in a project summary, prints a budget, takes input from stations and enters onto a tab of worksheet. You must be able to work with ranges, modules, dialogs in VBA code. Statements may be similar to ActiveCell.offset(0, 26).Formula = yadayada. Mainly some logic must be corrected, additions and upgrades must be made to the project. You will be adding items to the project summary, adding references to an OID tab from within initial worksheet (station). Also, budget created by worksheet code must output in a specific format, print set up to landscape to output details of project. Budget must be autopopulated correctly. A great deal of the functionality is already in place; however, it must be fixed.

    [more]
  • $75 USD Jan 9, 2014

    Export Data from Zillow for Excel1.Use an Excel file containing property addresses to look-up the property record on Zillow.com, export the data, and paste it into the address source spreadsheet in the appropriate columns.2.Assume the method is a VB Macro embedded in the spreadsheet.3.If creating a separate CSV file containing the data is easier, more accurate, or costs less, let’s discuss.4.Please note that I may not have identified all of the potential Fields (data columns) available in Zillow listings since many of the field only appear under specific conditions.Input Source: An Excel file containing address fields. Export: Zillow Field data to be exported listed below.FieldExampleFormatZillow Property URLhttp://www.zillow.com/homedetails/216-Edinburgh-Ln-Petaluma-CA-94952/15756039_zpid/TextStreet AddressTextCityTextStateTextZIPTextZestimate:NumberRent Zestimate:NumberEst. Mortgage:NumberBeds:TextBaths:TextSqFt:TextLot:TextType:TextYear Built:NumberLast Sold:TextParking:TextCooling:TextHeating:TextFireplaceTextDescriptive Paragraph:YOU CAN HAVE IT ALL!! Fabulous 5 bedroom home in West Petaluma located in the heart of Victoria, featuring over 2,500 sq ft of living area with a professionally landscaped backyard that backs up to open space. Master is on the 1st floor and 4 spacious bedrooms are upstairs. Very peaceful setting only a block from Helen Putnam Regional Park with hiking and biking trails. Private playground and tennis courts nearby too!Text--From Charts and Data Table--Zestimate Value:NumberZestimate Range (Low):NumberZestimate Range (High):NumberZestimate Last Updated:DateRent Zestimate:NumberRent Range (Low):NumberRent Range (High):NumberRent Last Updated:Date--From Price History Table-- DateDateDescription:TextPriceNumber --From More Facts:--Last remodel year: DateNotes:1.For any field with no data, return the placeholder “—“ if present or “N/A”, if field is blank.2.Price History Table: Note: “Historical data not available for this property” can be returned.3.Price History Table: Return only most recent entry from this table.4.If property record not found on Zillow, return “N/A” in the Zillow Property URL field.

    [more]
  • $20 USD/hr Dec 12, 2013

    Write the VBA code to cycle through the data. The rules are fairly simple but have to be done in the correct order to identify specific events. Could do gotomypc type of thing to describe project. Note, I&quot;ve never used this site before and I don&quot;t want to just upload my spreadsheet at this point. I can send spreadsheet after we&quot;ve struck a deal.Thanks

    [more]
  • $40 USD Dec 10, 2013

    Hi, we have a word doc/form that has several fields that need to be populated electronically each time the form is used.We want to be able to &quot;tab&quot; through the form from field to field.I would think 2 hours should be plenty to get this done?The form is about 2 to 5 pages in length (being edited now)What are your thoughts?

    [more]
  • £78 GBP Dec 5, 2013

    I&quot;m after the greyhound race cards in excel format. Ideally all the cards in one excel sheet from http://www.racingpost.com/greyhounds/card.sdI really don&quot;t know if this is possible? The system is to identify bitches running first time after a 29 day or more lay off. If you lay them it shows a profit every month. They tend to have a bad run the first race back.If all the information is in one sheet i can then delete material i don&quot;t need on a daily basis. Would be much easier than flicking through every page on the website.

    [more]
  • $30 USD Oct 30, 2013

    I have Postcodes in column &quot;L&quot; and I want to lookup for the avarage property prices by zoopla.co.uk.&quot;http://www.zoopla.co.uk/home-values/&quot; &amp; &quot;L&quot; contains AB10 1HF than on the page http://www.zoopla.co.uk/home-values/AB101HF get the Zed index value . to a new column next to the postcodes.

    [more]
  • $61 CAD Oct 21, 2013

    Create a professional Dashboard in Excel that is customizable. I need at least 4 sections on the dashboard, but need the ability to add more as required. Information need to be pulled from data sheets and should scroll individually.Adding a template example.

    [more]
  • $240 USD Aug 19, 2013

    I saw that you created a macro to download Zillow information into excel. Would like to discuss what you have created before and possibly purchasing it from you.

  • $15 USD/hr Aug 18, 2013

    We are looking to automate the creation of a word document and the creation of tables within an existing excel spreadsheet that deals only with textual manipulation and formatting. There is going to be a good bit of conditional formatting in the program. The excel file contains only 3 sheets, but this is just an example. Each actual spreadsheet would have about 20 sheets and anywhere from 1 to 70 entries per sheet. We would love for the attached start file to remain the same and both of the final two documents be created as the macro is run.

    [more]
  • $20 USD/hr Aug 14, 2013

    excel data entry

  • $30 USD Jul 25, 2013

    hello there,I would like to know that can you also help me? Task are not in hurry.As example I am looking a secure excel file. (I have to present to client some info in excel which they must not re-produce it)I required a one VBA code for below 3 questions.(No hurry for answers; only initially need to say that task accepted only, will wait for answer)TASK:-1. Disable &ldquo;Save-as&rdquo; &amp; &quot;Save-as&quot; any short cut key (I think ALT-1) for a particular fileonly!2. Disable &ldquo;Copy&rdquo; &amp; Short cut key &amp; Drag for particular column (say A:A)and Particular Range (say B3:F7 &amp; B24:F24)But remaining area should work copy/paste by short cut keys and righclik on mouse further selection manually copy/paste in remain cells.Note: - This can possible by protect sheet; but I do not want to apply any protection.If you are making define range then define range should be disable to modify.3. Disable Right Click on tab to move or copy as new workbook. (Forcreate a copy)Here, I want particular function (move or copy) only disable, not otherfunction which visible after right click on tab.Note:- Again do not want any workbook protection.Faceid preferable, for pt. 1 and 3 for particular sheet only! Or your any best idea!I am using excel 2010.Note:- Pls do not use the XML codes for Pt. 1 &amp; 3 if XML code then give protection idea also.

    [more]
  • $54 USD Jun 20, 2013

    I have a Word Document that I want to update:1. I want to have front page with buttons that will send you to different areas in the form.2. Dynamic size of sections - based on a table size in one of the sections, other sections need to be multiplied i.e. if a table has one row than other section will appear once. If there are 3 rows in that table - a bunch of other section in the document/form need to appear 3 times.

    [more]
  • $74 USD Jun 15, 2013

    We need to put 10,000 - 15,000 Question Data PDF to Excel Files, it can be done by copy paste or copy writing or per Form entry or any way you choose, for us the result matters!each question has:1x question text5-6x answers1x related text1x right answermay have this Data1x extra text1-2x imagesthe the Beginning we will start with 1000 Question and if we are satisfied with it then we can continue!So please make your BID on 1000 question base!

    [more]
  • ₹3000 INR Jun 13, 2013

    Need contact info (name, phone number, job title) for United States magazines. I will make it easy with an excel spreadsheet with the names and website of the magazines needed. I specifically need: Editor name, editor email, and editor phone number filled in the excel sheet that I am giving you. There are a few tabs at the bottom of the spreadsheet. I need all these tabs starting with the &quot;Jude&quot; tab first.

    [more]
  • $35 USD Jun 12, 2013

    Need contact info (name, phone number, job title) for United States magazines. I will make it easy with an excel spreadsheet with the names and website of the magazines needed. I specifically need: Editor name, editor email, and editor phone number filled in the excel sheet that I am giving you. There are a few tabs at the bottom of the spreadsheet. I need all these tabs starting with the &quot;Jude&quot; tab first.

    [more]
  • $30 USD Jun 4, 2013

    your task is to do data extract from 1 site. you do not need to extract full data only 3 statesi need the data from this site in the given format in excel csv file i need both script and data.i do this all the time. i pay $20 per site. but freelancer requires $30.00 minimum.for this time i pay $30.00 for for more projects my rate is $20 per site.Note: this requires to write script and do it. it is not manual processjavascript or php or .net or imacros, javascript, macros is preferrablei consider Perl also if you are using other than these let me knowsince i need to have the ability to execute the script and run it my self if needed in the futureThis is not manual data extact. this requires scripting knowledge

    [more]
  • $39 USD May 30, 2013

    There is no data to enter at the moment but I need a sheet programmed to do the following. We sell a product to many different clients and I want to track how much it is costing us to service these clients. We need to see if we are charging adequately for our warranty.So for each client I need to have the serial number of the product the part # that we replaced the part cost the shipping cost than finally the total cost. Each serial number has to be grouped together so each time have to add new expenses i can see how much that serial number is costing me to repair.If you have any suggestions on how to do this in a better way let me know.

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

Portfolio

[see more]

Résumé

Experience

Computer Tech

Sep 2004 - Apr 2005 (7 months)

R&D In Motion

Worked on telephone monitoring system...

Education

St.Clair University

1998-2001

Certifications

Electronics Engineering

St.Clair

Publications

none

none

none