offline
Last seen: Apr 16, 2014 9:21 AM EDT
Hire Me!
Rate: $30.00 USD/hour
Follow Invite to Project
 

vbexcel

Prompt, proficient and professional

Username: vbexcel

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

Location: London, Canada

Member since: February 2010

Reputation:

4.9/5

(34 reviews)

5.6
[see more]

No user has recommended this freelancer.

My skills:

My projects:

  • $250 USD
    5.0
    Profile image for Seller mercuryproject

    mercuryproject

    Jan 20, 2014

    This was a very complicated project with many layers. VB Excel was very patient with me and my needs and he went above and beyond to deliver. I'm so appreciative

    Project Description:Finish and revise existing financial model. The project is geared toward a multi layered real estate acquisition and development.
    [more]
  • $250 AUD
    0.0
    Profile image for Seller Newpunter

    Newpunter [ Incomplete Report ]

    Sep 17, 2013

    The project is not completed according to the dispute

    Project Description:I Need a complete update of my spreadsheet as per Update file below,it needs to be able to import data from a daily file,do calculations and and filter data and provide output as per file below. I am...
    [more]
  • $78 USD
    5.0
    Profile image for Seller kevinkvk

    kevinkvk

    May 29, 2013

    good job! complete in time with high quality !

    vbexcel's reply:

    Great vendor, A+ in all categories

    Project Description:Its a very small and easy project, it will include excel vba skill. less thank 8 hours work. only need to create userform and set function such as match, vlookup need to complete in 24 hours,...
    [more]
  • £150 GBP
    5.0
    Profile image for Seller davidschindler

    davidschindler

    Apr 22, 2013

    100% recommend - superb / brilliant!! The King of Excel!

    Project Description:I am looking to drop ship from a European company Pixmania Pro - http://www.pixmania-pro.co.uk I have a domain with Godaddy www.printersandinkcartridges.co.uk Pixmania supply the following CSV file link...
    [more]
  • $80 USD
    5.0
    Profile image for Seller tylerbook

    tylerbook

    Mar 2, 2013

    Absolutely perfect, helped with everything we asked for. Fantastic worker, would hire again and again.

    Project Description:We have two csv files that we want to import into excel to have formulas applied to ::: . The CSVs we use have static number of columns, and static column names, if that helps. We want formulas applied...
    [more]
  • $179 USD
    0.0
    Profile image for Seller zoomonkey

    zoomonkey [ Incomplete Report ]

    Oct 17, 2012

    Poor communication despite being promised my project would be a priority. Failed to complete project, overall a waste of time.

    vbexcel's reply:

    Misleading specification given by employer. Basically, the idea was to debug six web scraping macros, however all of which required major recoding. For the three scrapes that I redid no compensation was offered.

    Project Description:I have 6 macros that scape data from 6 different websites (the codes direct the websites in what data to display and then loop through different dates and inputs - which have been driven by different excel spreadsheets...
    [more]
  • $390 USD
    5.0
    Profile image for Seller bradjester

    bradjester

    Sep 25, 2012

    Zenon is excellent. Loved working with him.

    Project Description:Below is a detailed description of what we do on a regular basis - this project is to automate as much as possible of the steps below so that I end up with a bot that I can run whenever needed, on whatever spreadsheet I want to use...
    [more]
  • $50 USD
    5.0
    Profile image for Seller fbod383

    fbod383

    Aug 4, 2012

    super fast, exactly what i needed

    Project Description:I saw you had bid on doing a tire size DB for Bratok21 about a month ago. If you still had the DB or Excel spreadsheet I would be willing to buy it. here is the posting. http://www.freelancer.co.uk/projects/Data-Processing-Data-Entry/Tire-Sizes-Vehicle.html...
    [more]
  • $9.8 USD
    0.0
    Profile image for Seller computer13

    computer13 [ Incomplete Report ]

    Jun 20, 2012

    what can i say, this guys never reply to me didn't meet the deadline gave him a chance to reply never did, even have prove of it.

    Project Description:program is done just need report to be done. need to be done 1 and half days. look below for full details
    [more]
  • $130.83 USD
    4.4
    Profile image for Seller BikProfessor

    BikProfessor

    Jun 3, 2012

    Amazing freelancer, highly recommend. He put a lot of effort into the project.

    Project Description:I need a deep analysis of major OMX stocks, including betas for stocks and etc.
    [more]
    vbexcel has not completed any projects.
  • $30 USD In Progress

    Hello there,Pls can you quote for below,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 “Save-as” & "Save-as" any short cut key for a particular file only! 2. Disable “Copy” & Short cut key & Drag for particular column (say A:A) and Particular Range (say B3:F7 & 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. (For create a copy) Here, I want particular function (move or copy) only disable, not other function 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 & 3 if XML code then give protection idea also.Payment can be done by Paypal Only or Bank Transfer for Indian Bank!ThanksRahul Kale

    [more]
  • $49 USD In Progress

    Need to modify existing macro to get correct data - history odds: 1X2 and O/U (Over/Under) 2.5 from betexplorer.com.Everything except O/U 2.5 works fine.Problem with O/U is that the scraper takes first meanings (picture 1), which are wrong because they are not the odds for O/U 2.5, but 0.5 and they are not the odds from the bookie I want.Scraper should check: 1) if the bookie is a chosen one and 2) if the odds are for O/U 2.5 (picture 2 - orange marks).Correct result (picture 2 - green mark) should then be translated to columns N and O in the DATA Sheet.In the attachment:- an example spreadsheet with wrong data in columns N and O,- 2 pictures for understanding.Any questions - feel free to ask.

    [more]
  • $250 USD In Progress

    I am looking to have an Excel Plug-in made that can pull data from the Instagram API that works in a similar (but smaller scale) way to this Twitter Plug-in: http://www.rssbus.com/excel/twitter/hiw.aspx Note: Full Scope of Work to be provided upon awarding the projectThis Excel Plugin should be able to pull data in two different ways (with details):1.Pull data about any authenticated user logins’ followers and compiled data a. Pulls data about a users own account followers/comments b. Should be able to pull account data in a few different ways Follower: * Every follower, # of their followers, date they began following, # of comments, location of follower, etc (full data in scope) Comment * Every comment made by followers, date comment made, time of day comment is made, # of likes, location of comment, etc (full data in scope) * Every comment made from the user account a. Date of comment, time of comment, # of likes, # of comments, reach of comment2.Pull public Instagram data about any keyword term a. Pulls data based on a keyword search b. Should be able to pull all posts that have a set keyword/tag * Data included: a. Comment, username, location, date, time, # of likes, reach (# of users followers + # of followers from any commenters), etcBasic Functionality Use-Case•I open Microsoft Excel•Go to the Plugin tab•Launch a new data query•Select if I want account data or keyword data - Enter in necessary information based on the path * Account data: Instagram username/password credentials * Keyword data: Instagram keyword to search•Select the data to be pulled - Followers, Day, Time, Reach, # likes, # of comments, location, etc•Click generate/submit/etc•Raw Data is pulled based on the filled out criteria - With top row having headers for each type of dataThis would pull data using the Instagram API: http://instagram.com/developer/# Data output example will be provided with final scope upon awarding the project.

    [more]
  • $50 USD In Progress

    Very similar to one you just bid on. I have a spreadsheet with property addresses on it. I want to link the Zillow Zestimate of Value or Rents to the Cell in the spreadsheet. And I need ot to be easy to add new properties to or to start a new spreadshhet all together.I realy just need a LINK or a code that I can put into a spreadshhet that links it to Zillow?? If possible?

    [more]
  • $60 USD In Progress

    We use an XL spreadsheet for picking college and NFL football games we need somebody to write a formula so alls we have to do is enter scores and it will calculate who won and who lost and keep the weekly percentage total and an annual win percentage total we have the spreadsheet set up we just need the formulas written

    [more]
  • $600 USD In Progress

    Hello again. At the end of the last project, we chatted on coding for a different Zillow API - one that would return results in a single pass with address input versus the 2-pass method.If you are available, I"d like to have you do this for me. The API that will return results with only an addressed passed is: http://www.zillow.com/howto/api/GetDeepSearchResults.htmFor this project, I"d like you to code the VB into the existing Excel version, and then we will follow up with either .NET or Javascript version for integration.Let me know if you are interested and your estimate for VBA/Excel version and Javascript.Thanks,Mike Whitson512-917-4309mwhitson@granite-excell.com

    [more]
  • $450 USD Mar 16, 2014

    Hello coders!\r\nI would like to get a list of Active companies registered in Canada from September 1, 2013 to today (March 16, 2014)\r\nOnly want companies registered between these dates, not the older companies.\r\nNeed company name & address. Would like phone # too, if it is available.\r\nThis information is public knowledge.\r\nSome websites scrape info. from the Govt. of Canada website, like this one:\r\nhttps:\/\/opencorporates.com\/companies\/ca?current_status=Active\r\nOriginal government source is: \r\nhttps:\/\/www.ic.gc.ca\/app\/scr\/cc\/CorporationsCanada\/fdrlCrpSrch.html\r\nPlease let me know if you can do this project. Also time and cost. \r\n\r\nIf you do a good job I will use you again, as I want a list of all new companies every month.\r\nThank you!!!! :)

    [more]
  • $30 USD Mar 16, 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. (See Spreadsheet for Example Layout)Export: Zillow Field data to be exported listed below. (See Spreadsheet for Example Layout)FieldExampleFormatZillow Property URLhttp://www.zillow.com/homedetails/216-Edinburgh-Ln-Petaluma-CA-94952/15756039_zpid/TextStreet AddressTextCityTextStateTextZIPTextFor Sale:NumberPrice Cut:NumberZestimate:NumberRent Zestimate:NumberBeds:TextBaths:TextSqFt:TextLot:TextYear Built:NumberLast Sold:TextParking:TextCooling:TextHeating:TextFireplaceTextOn Zillow:NumberMLS#:TextDescriptive 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!TextZestimate:NumberRent Zestimate:NumberFrom Price History Table DateDateDescription: (values seen)Price ChangeSoldListing RemovedListed for SaleTextPrice:NumberFrom More Facts:Combined FactsConstruction quality:NumberNeighborhood Name:TextParcel #:Format in Zillow: 008580003Return in this format: 008-580-003Text# Stories:TextZillow Home ID:TextNotes:1.Field “Price Cut” is a dynamic variable field, e.g., not always included in the visible record.2.For any field with no data, return the placeholder “—“ if present or “N/A”, if field is blank.3.Price History Table: Note: “Historical data not available for this property” can be returned.4.Price History Table: Return only most recent entry from this table.5.Parcel #: Leading zero, if present, is a part of the number and must be returned. NICE TO HAVE: Return data in this format: nnn-nnn-nnn. Insert a hyphen after the first three digits; insert a hyphen after the next three digits. 6.If property record not found on Zillow, return “N/A” in the Zillow Property URL field.

    [more]
  • $199 USD Mar 16, 2014

    his job is to gather a data from a grocery store website.The data will include.1.) Full Product Name2.) Category3.) Subcategory6.) Image URL7.) Price8.)PLU(code of each product)9.) Discount PriceExample excel columns:Full Product Name: **Caffe D Vita French Vanilla Cappuccino - 16 Oz**Category: CoffeeSub Category: Instant Coffee MixImage File : 100x100.jpgPrice: $3.29 PLU: 123456Discount Prices(each day is a different product) : $3.29 We need the script to update it one time per day.

    [more]
  • $250 USD Mar 15, 2014

    We are looking for someone to set up a scraper that would on command find selected info and pictures from 3 public websites. Where I will be able to email customers the collected info via email. All done through a command post. I want to be able to enter a specific criteria and allow the system to search from the 3 urls provided for me . Each email will consist of info for each listing followed by pictures and deep links to a organized and desired format\r\n We will require, 1. a scraper job, that"s is search and catch automated and 2. data sent to email and formatted completely and set up ready to be sent.

    [more]
  • $50 USD Mar 15, 2014

    You"re gonna need Excel 2013 for this. I have a Mac, so I can"t do it. Need it done by 11:59pm. (8 hours) Price is negotiable. I will have to e-mail you the full instructions. There are 23 steps, but this site won"t let me list them all. Seems easy enough for someone good with Excel.1 Start Excel. Download and open the file named go_e02_grader_h3.xls.2 Change the Theme to Slice. Rename Sheet1 as Bulbs and Sheet2 as Trees. Click the Bulbs sheet tab to make it the active sheet.3 To the right of column B, insert two new columns to create new blank columns C and D. By using Flash Fill in the two new columns, split the data in column B into a column for Item # in column C and Category in column D. As necessary, type Item # as the column title in column C and Category as the column title in column D.4 Delete column B. By using the Cut and Paste commands, cut column C—Category—and paste it to column G, and then delete the empty column C. Apply AutoFit to columns A:F.5 Display the Trees worksheet, and then repeat Steps 3 and 4 on this worksheet.6 Without grouping the sheets, make the following calculation in both worksheets:• In cell B4, enter a function to sum the Quantity in Stock data, and then apply Comma Style with zero decimal places to the result.• In cells B5:B8, enter formulas to calculate the Average, Median, Lowest, and Highest retail prices, and then apply the Accounting Number Format.7 Without grouping the sheets, make the following calculation in both worksheets:• In cell B10, enter a COUNTIF function to determine how many different types of Tulips are in stock on the Bulbs sheet and how many different types of Evergreens are in stock on the Trees worksheet.8 Without grouping the sheets, make the following calculation in both worksheets:• In cell G14, type Stock Level. In cell G15, enter an IF function to determine the items that must be ordered. If the Quantity in Stock is less than 75 the Value_if_true is Order. Otherwise the Value_if_false is OK. Fill the formula down through all the rows.9 Without grouping the sheets, apply the following formatting in both worksheets:• Apply Conditional Formatting to the Stock Level column so that cells that contain the text Order are formatted with Bold Italic with a Font Color of Dark Blue, Text 2. Apply Gradient Fill Blue Data Bars to the Quantity in Stock column.10 In the Bulbs sheet, format the range A14:G42 as a table with headers and apply Table Style Light 20. Insert a Total Row, filter by Category for Tulips, and then Sum the Quantity in Stock column. Record the result in cell B11.11 Clear the filter from the table. Sort the table on the Item Name column from A to Z, remove the Total Row, and then convert the table to a range. On the PAGE LAYOUT tab, set Print Titles so that row 14 repeats at the top of each page.

    [more]
  • $133 USD Mar 15, 2014

    I need a automation system / software, scripts to extract some information from email based on the text field. The lines in an email need to be transferred to a google doc (spreadsheet) with each characteristic in a different column on the same line.Please bid only If you have prior experience in script writing and are awesome. You will be required to teach me how it works.

    [more]
  • $30 USD Mar 15, 2014

    Need to convert XML file to example format excel file found here https://www.dropbox.com/sh/ntn4xbf1iz2t8w1/3jDKdwzXOKThis should be done using some sort of automation, also any additional attributes found in the file should be added as a header just like in the excel exampleThis should be a simple task and not take long to complete

    [more]
  • $135 USD Feb 12, 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 "labor adjustment" 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]
  • $30 USD/hr Feb 5, 2014

    I am currently working on an Excel model in order to predict call using the Erlang formula. I have the basics and the formulas but I need incorporate different formulas and spreadsheet into one. I need to have the data update throughout the day based on what happened earlier in the day. I need someone who is familiar with statistics, math and Excel.

    [more]
  • €139 EUR Sep 13, 2013

    I need a plugin or software that fetches the data from the web and organizes teams on excelthe website is http://www.soccerstats.com/ and i want to download the teams information goals, wins etc for an excell with a button to refresh and one page for each league

    [more]
  • $30 USD Sep 13, 2013

    I Have budget template on excel sheet. its need some BBA by developer, most of work is combo list combo box, drop list. examples:- we have 6 divisions and each user can choose up to 6 division, if the user choose 4 division, he should have 4 column budget, one for each division- if the user fill 5 project he should have 4 budgets tables. one for each project. and so on. the file will be ready tomorrow and I need it within 24 hours. paid upon successful completion

    [more]
  • £150 GBP Jun 7, 2013

    Hi I am looking for someone to update my invoice. I think I would like a data base running from an invoice in excel.I would need to be able to analayse customer information eg. prevoious invoices and what stock they bought and what returns they had. I run a small wholesale business.

    [more]
  • $330 USD May 3, 2013

    We are looking for a firm that is familiar with construction blue prints and has a very good knowledge of how to do construction take offs for masonry and concrete construction. You must be able to determine material quantity after reviewing prints of large construction projects. You will then have to deliver those quatities on an a spreadsheet. You are not required to determine any cost only material quantity to complete job. You will be expected to do multiple jobs at any given time as we have multiple job to review. Great monetary potential. It would also be helpful if you could also determine quantity take offs for other areas of construction.

    [more]
  • $66 USD Apr 17, 2013

    My client needs the data from this PDF extracted to a .xls sheet. There are 6 columns to be listed:Name CompanyAddressPhoneFaxCAPS Classification.The .xls sheet needs to be fully editable. Attached is the file.

    [more]
  • $459 USD Feb 26, 2013

    I want an automated code which can visit a Food Recipe website and extract the following information from the Food Recipe URL.-Food Image-Recipe Title-Recipe Directions + Ingredients-Recipe KeywordsThen I want to use this information to generate short YouTube video"s using the "Food Image" to be shown for the YouTube video + adding on Royalty Free music.The video will basically show the image of the recipe and play the royalty free music for about 30 seconds.I want to use the "Recipe Title", as the YouTube Title, the "Recipe Direction" + "Ingredients" as the information about the YouTube video, so when you click "show more" on the video it will display the full Recipe including the ingredients and directions.and lastly, the "Recipe Keywords" to be used as the YouTube Keywords for the video.I want everything to be automated so it can extract the information from the website /and upload the videos to my YouTube channel by the thousands.

    [more]
  • $180 USD Feb 8, 2013

    We need a skilled data mining programmer to mine public library directory sites in the United States, Canada and Australia to develop a database of approximately 20,000 public library administrator email addresses. We hope to pay about 0.5 to1 cent per email address. Some sample sites are listed below but we are most interested in coverage and not necessarily in any one specific site.

    [more]
  • $250 USD Aug 17, 2012

    Hello,I am looking for someone that has the expertise to build an API web tool in order to extract Real Estate data from Zillow.comPlease see the information from the link below.http://www.zillow.com/howto/api/GetZestimate.htmI will provide more information and requirements to the right candidate.

    [more]
  • $50 USD Jul 23, 2012

    Hi - I saw that you did a project downloading the Inc. 5000 list and adding business description and contact info for each company. I need the exact same thing. Can you just send this to me?

  • $50 USD Jul 20, 2012

    Hi - I saw that you did a project downloading the Inc. 5000 list and adding business description and contact info for each company. I need the exact same thing. Can you just send this to me?

  • $30 USD Jan 3, 2012

    HELLO,I like join with data entry job (but not captcha job) or accounting job.

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

Portfolio

[see more]

Résumé

Experience

Senior Consultant

Sep 1995 - Present (18 years)

CDN Global Solutions

Education

BASc

University of Toronto

1988-1992