Last seen: Aug 01, 2014 11:59 AM EDT
Hire Me!
Rate: Ask for Hourly Rate
Follow Invite to Project


Excel Formulas and VBA Programming

Username: zExcel

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

Location: San Diego, United States

Member since: June 2013



(101 reviews)

[see more]

6 users have recommended this freelancer.

  • $196.00 USD
    Profile image for Seller reastlan



    I am definitely going to work with zExcel again. zExcel gave me exactly what I wanted and did so ahead of my deadlines.

    Project Description:I need one macro that helps me convert my monthly client account statements (one on each sheet in my workbook, attached) into PDFs. The PDFs would automatically be saved to their appropriate folders,...
  • $65.00 USD
    Profile image for Seller Eaze21


    2 days ago

    Good job. Will surely hire again.

    Project Description:I need an excel template to function with suggested columns like, SUBJECT, BRIEF, CASE, SUMMARY,.., every subject has multiple briefs, every brief has multiple cases, and each case a summary. For every...
  • $250.00 AUD
    Profile image for Seller tvlbusiness


    6 days ago

    Initial miscommunication re my desired outcomes, zExcel offered a solution acceptable to us both. Professional & easily understood communications.

    Project Description:I want to measure timeframes between milestones in each of our construction projects so that I can monitor the performance of our contractors, suppliers & employees responsible for each task. I created...
  • $175.00 USD
    Profile image for Seller axiaer

    axiaer [ Incomplete Report ]

    19 days ago

    The project is not completed according to the dispute

    Project Description:The project is to build an app for Mac OS X with following functionalities Input field 'A': Select multiple excel files Check box 'AA': Remove duplicates (check/uncheck) Unique Identifier 'B':...
  • $190.00 USD
    Profile image for Seller vinom15


    22 days ago

    Great! I ll hire in future :)

    Project Description:need to display id, name, modules, date, time in and time out for rfid scanning
  • $525.00 CAD
    Profile image for Seller signuppr2c


    23 days ago

    zExcel far exceeded expectations for the end product. Comm was 10/10 throughout. Very professional and time concious. Extremely fast coding considering the detail required + multiple changes.<br/>

    Project Description:I have excel ready comma delimited data that needs to be turned into a formal presentation repeatedly via a macro. I would like a pivot table and graphs to be included in the report accross multiple tabs...
  • $325.00 USD
    Profile image for Seller kevinrebel


    Jun 26, 2014

    I would recommend Jon for any Excel project you may be considering. The project ran smoothly and all was delivered on time and within budget.

    Project Description:We are looking for a Freelancer to write an Excel Macro to assist with our client reporting. So, to take our raw data, prepare it and auto populate our reporting templates. Here is the current process: 1...
  • $290.00 USD
    Profile image for Seller devonpetgorilla


    Jun 23, 2014

    Good work but seemed in a hurry to complete tasks, so much so that he did work based off his own guessing rather than ask for clarification before completing something.

    Project Description:I need an excel expert to help me take a semi-formatted excel document and insert several formulas (if, then based and referencing to other worksheets), as well as a couple of macros with buttons. This...
  • $60.00 USD
    Profile image for Seller migduvednok


    Jun 17, 2014

    Freelancer was not accommodating and had some temper. Probably skilled but not nice to work with.

    Project Description:See attached Excel - note the tab &quot;medlemmer&quot; The green &quot;box of members&quot; is not working properly, (For example the table doesnt list when a member has crossed the date line for the membership. (i.e...
  • $60.00 USD
    Profile image for Seller dsmith247


    Jun 16, 2014

    As always, zExcel came through on-time and on-budget... Do not hesitate to work with this freelancer. Thanks again!<br/>

    Project Description:Need additional modifications to previous VBA coding. Chat required to confirm needs and cost. Thanks.
    zExcel has not completed any projects.
  • $150 USD In Progress

    Project for zExcelRepair to the completed COP Template programming.

  • $215 USD In Progress

    I need a program that realizes the combinations between different users. The program is used to manage the winnings and losses of the different players. There are n players, where everybody plays by different users making of wins and losses. The purpose of the software is to compensate for the win with the losses of each individual player. example: Our n is 3, player A, player B, player C They all played with each other A wins € 3k with B B wins € 3k with C C wins € 3k with A then: A must get € 3k B but must give € 3k C B should receive € 3k C but must give € 3k to A C is to receive € 3k from A but must give € 3k B THE SOLUTION AND software &quot;to compesare winnings with losses THE SOLUTION WILL &quot;1.1) STEP A transfers C to B with his winnings of € 3k in exchange for compensation of the loss with C. A >> C >> prizes up to B & C A A prizes up to A must NOT receive € 3k B and should NOT give € 3k C B should receive € 3k C but must give € 3k C C is to receive € 3k B but must give € 3k B 1.2) STEP B and C compesano winnings and losses B >> C >> prizes up C & C B B prizes up B should NOT receive € 3k C and should NOT give € 3k C C should NOT receive € 3k B and should NOT give € 3k B 1. 3) FINAL STEP winnings of A, B, C have been offset their losses The wins and losses can be of a different amount, but every player has the most wins with different players and different losses with different players. The aim is to combine the winnings for each user with its own losses All the information that the software must manage will be uploaded to an excel sheet

  • $90 USD In Progress

    Hi, I am having difficulties getting one of my formulas correct on an Excel spreadsheet. The formula is basically to select the four lowest values, based on a variety of criteria.The formula should select the four lowest interline rates based on:1. the origin / region (whichever is cheaper)2. the hub3. Cargo type 4. Freighter / pax5. Weight break range6. trucking add-ons in the US / at the hubs.It will also be necessary to return the interline partner with whom the rate is.I hope someone can help!Many thanks in advance.Liana

  • $250 USD In Progress

    i am looking to create a program that can take a downloaded data sheet of work currently going through my factory and convert into a Value work in hand £I have a price list in excel the download of current work is in CSV format from my PHP based online order system Then want all converted into a excel sheet that gives me a £ value of the current work load Have some examples if needed

  • $22 USD/hr In Progress

    I need someone to help with programming of data that is delivered via Excel from an online survey platform that was created in Drupal.The programming can take place either after data has been created and delivered in Excel or it can take place in Drupal creating a way for the data to be delivered in a format that makes it easier to use in Excel.My preference would be to have the programming executed in Excel if at all possible.I can deliver sample Excel files to you and I can demonstrate how the data is created.

  • $50 USD In Progress

    Deliver the spreadsheet unlocked and compatible with both pc and mac.

  • $27 USD/hr In Progress

    Analyze voter registration and voter history records - which I will provide you - for Knox County, Tennessee and extract some desired information, such as how many 18 year-olds were registered to vote in some specific elections and how many actually voted in those elections. If you are skilled in Microsoft Access, this should be simple.

  • $40 USD In Progress

    Hello,I need a macro created to work a certain way with my excel spreadsheet which i can send you. Basically i just want it where if i paste in 100-1000+ links it will edit those links into how i want it, for example it will:- delete any blank cells- delete the &quot;http://www.&quot; in the beginning or the URLs that have it- delete the &quot;/&quot; at the end of any URL that has it- it will then paste into the proper column into where my spreadsheet converts it further as its setup to do currently.Must be in Excel 2013.Thanks

  • €18 EUR/hr In Progress

    Västergård Outdoors arranges cycle tours in Turku Archipelago. Data, name and number of participants, accommodation etc for each tour is on one line in a excel table. By pointing to one line on the first sheet the next sheet should contain the invoice and the following their vouchers for that particular customer which can be printed.

  • [Sealed] In Progress

    [This is a Private Project. You must be logged in to view the Project Description]

  • ₱6000 PHP Today

    Hello po, I need someone who does programming, need to make a simple program with user authentication per department for a manufacturing, production company, with an excel sheet inside the program that in each department they only have access to their column in excel sheet and everyday each department would edit the excel spreadsheet but they can only edit their department column and not other departments column.. but they can view all columns.... hard to explain it here but if you can contact me or message it would be easier,

  • $40 USD Today

    Refer to the EXcel file called FOLLOWUP_WORK_(CUSTOMIZE DETAILS COLUMN).xls appended at the bottom of this project. Left click twice on cell T1 and N1 to make the Remarks Menu and Details Setup Menu popup respectively.NOw, columns T and N are reserved for other use by my boss. So I have to use the last 2 columns ie W and V on my Excel table.I just need an Excel VB or VBA Expert to make those 2 actions get transferred to cell W1 and V1 respectively, and when left-clicked twice to each popup the 2 menus now to serve column W and V instead. Name W and V columns as &quot;Nature of Request&quot; menu and &quot;More info on Request&quot; column respectively. So shifting the same actions to last 2 columns of the EXcel table.

  • $83 USD Today

    HelloI have a excel sheet with some rows and columns that I need to transform to a diferent structure (somthing like unpivot).This is 50% of the first part of a project.Depending on cost and output, there will be a total 10 task like this one.Please take a look at the sheet &quot;Origin&quot;:There are 4 parts that should be combined to create a table.You will detect a value by a fixed cell or by a fixed text. The structure is fixed, you read and combine the data.I will explain in detail connecting with teamviewer. It is better to go step by step The output will be located in a new excel sheet.Thanks

  • $25 USD Today

    Due to limitations in the UDF of VBA in Excel I need inline code that I can put in a cell that would essentially do the following.If Cell D9 is empty, show &quot;&quot; otherwise show values from cell D4Thanks

  • ₹7222 INR Today

    this is about a billing excel sheet, it has three section1. STAY BILL : that includes DAY STAY charges, nursing charges, visit charges.2. DAILY CHARGES : that has all the activities done in the day, multiplied by the number of times we do it...3. SURGERY BILL (OPERATION THEATRE BILL)This third part has two part, OPERATION THEATRE BILL and DOCTORS BILL . Doctors bill contain charges of Surgeon, Assistant Surgeon, AnesthesiologistEXPLANATIONSTAY BILLWe will have fix BASE VALUE for stay, nursing and visit. We have also fix the ROOM GRADE RATIO based on the different types of room that is fix in the back end, the momment, we insert: check in and check out, and choice of room. The charges of room, nursing charges and visite charges are calculated based = base value x room gradeDAILY CHARGES :in backend we would enter all the activities and their respective charges. One just have to enter the room grade and number of times the activites were done and again based on ACTIVITY X ROOM GRADE X NUMBER OF TIMES = CHARGES would get calculated of all the activities on DAILY basis. so this has to be done daily by an accountantSURGERY BILLAs mentioned this has two parts, 1. OPERATION THEATRE CHARGES : It has many instruments and services we charge per hour. so each instrument and service will have the base value and it has to be calculated based on a formulate already mentioned on the excel i have sent 2. DOCTORS BILL , there are three types of doctor to be paid. Surgeon fee is calcluated quite similarly as OPERATION THEATRE CHARGES and the formula is on excelthe assistant surgeon gets 25% of the surgeon feethe anesthesiologist gets 25% of the surgeon feethe complete total of STAY BILL + DAILY CHARGES (ALL DAYS ) + SURGERY BILL should show up and also we should have the amount deposited by patient time to time and that gets deducted from the about total and should show the remainingand if the remaining is less than 2000, a RED FLASH BOX SHOULD APPEAR

  • $450 USD Today

    My company needs a mark up sheet that will fill in most the information when a salesperson enters a few numbers about a house. This will need to calculate different formulas to produce the total price. Once the mark up sheet is completed it needs to send the information to the material order form and proposal for services. These will also need to have room to add certain information. I have a a copy of the current excel sheet that is used for mark ups. The other 2 different sheets are manually put in, and they are adobe reader documents. All 3 sheets need to be modified with information added and taken out. It needs to be simple enough a 50 year old with low computer skills can do with a tablet as well.

  • [Sealed] Yesterday

    I have a database that contains approx. 30,000 records with each record containing 19 data fields. I need a utility that makes it very quick and easy to filter the records based on multiple specified data points, allows for easy editing and updating. One of the data fields contains a web address which I would need to open in order to view some of the data that required updating. Due to the number of records which requires updating on a regular basis it is critical that the utility function quickly, with the absolute minimum # of clicks/selects.I’m thinking the utility would either be:Mac based;Microsoft Excel based;Microsoft Access based;However, I’m open to suggestion. I’m looking to work closely with a select freelancer who will provide an optimal solution.

  • R2222 ZAR Yesterday

    Build a macro on a spreadsheet (specific format) to validate data on 20 columns that are being entered. The file is later used in an upload process (not part of this project). The user can copy/paste data into the excel sheet - once the button is pressed, each cell must be checked that it contains valid data, is of the correct data-type (not not, try and correct it) and if there are errors, each cell must be highlited to indicate to the user where errrors occured. When the macro ends, a summary pop-up must appear with a count of errors. When all errors are fixed and the macro runs, a save as dialog must be presented and the file be saved in either *.xlsx or *.xls format. Some columns will need extra validation against a certain algorythm to check for correctness. The algorythm will be provided. Also, one column (Passport Country of Issue) must be validated against valid country codes. The values are available. Important - This spreadsheet macro to be written in VBA, may not connect to online sources or have additional external add-ins added

  • $1234 USD/hr Yesterday

    As per my knowledge I can fulfilled my jobs as per your requirment

  • $1500 USD Yesterday

    Payroll for the company, Attendance details across all projects in the company

  • ₱7160 PHP Yesterday

    I need someone who does programming, need to make a simple program with user authentication per department for a manufacturing, production company, with an excel sheet inside the program that in each department they only have access to their column in excel sheet and everyday each department would edit the excel spreadsheet but they can only edit their department column and not other departments column.. but they can view all columns.... hard to explain it here but if you can contact me or message it would be easier

  • $8 USD/hr Yesterday

    I have an Excel spreadsheet with ~850 rows and 5 columns. The spreadsheet is a text export of products information from my website. Unfortunately, when exported, special HTML characters show up in the spreadsheet. I need you to go through every cell in the spreadsheet and replace the stray characters with the proper symbol. For example, &quot;Blanton&#8217;s Original Single Barrel Bourbon Whiskey&quot; should be changed to &quot;Blanton&quot;s Original Single Barrel Bourbon Whiskey&quot;.Additionally, there is a column that needs to be filled in/corrected based on a list of options. I can explain in further detail once you start.

  • $111 USD 2 days ago

    I would like to have an excel small macro/program to complete the following task:This will be used to make decision about moving inventory from one company between it&quot;s plants, based on historically usages (weekly basis),and on hands inventory, which plant will be the best to pull the inventory from based on lower and higher user and based on inventory on hands, also region on the plant.Information will be pulled from SAP, usage will be input in weekly or monthly basis, inventory will be pulled from sap and injected to the spreadsheet.I would like to have a cover page where you can make the input of the material number, and with a click of a button will display the best option based on: inventory on hands (based on historical usage) and region where it&quot;s being pulled

  • $30 USD 2 days ago

    Hi! Currently developing an excel sheet application and new some help.1. The value for a range object is dymamic and the cell area stands in a TableA, Cell A3 - how do I have to implement it? Range(&quot;Steuereinheit!D83&quot;).Select is not working.2. I have X excel tables each containing dynamic content. For a final reporting, I would like to have: Content of Table 1 -- two lines free space Content of Table 2 --- two lines free space etc. The number of tables that are filled is determined in a cell IMPORTANT: Each &quot;Content block&quot; has to be displayed completely on the page - not splitted over 2 pages. In case the content would be splitted, the whole content block shall be put onto the next page.3. There is general statis in which the values for each month are taken. Each each new month, the results shall be put in the next row that is currently not filled.Clear so far? Looking forward to your bids and will award asap.

  • $15 AUD/hr 2 days ago

    I need a excel workbook locked and adding further detail

  • $30 USD 2 days ago

    Data handling and maintaining the data sheets through Excel.

  • $160 USD 2 days ago

    I use excel and google docs. I need someone who knows both excel and google spreadsheets VERY well. I want to move some data from Excel to google docs but that is not the primary focus of this job. The primary job is an ongoing google spreadsheet/s design. I need to start with a spreadsheet that i can have all cost data input in a sheet for repairing houses. I will give the costs and need you to do the function and calculations. I need ongoing changes but I do NOT want to be charged for every little change. I am fair and do not expect free but the sheet/s will be a work in progress as I use it in the field and make changes. I think I need to have a template sheet that I then hit copy sheet and add the house address and save as a separate sheet. I think I need to be able to add photos to the sheet (maybe). I want the sheet to look user friendly ie if the house needs carpet I click a box beside carpet and the sheet brings in the amount I supply you with etc. I want to work with you on a long term basis not find someone new every month or so. This first bid is to build the cost categories with the text and amounts I will supply you. Probably 40 items like paint, carpet, toilets, cabinets, etc.Thanks Galen

  • $45 AUD 3 days ago

    Require some data on a spreadsheet to be emailed to the person on a particular line Eg. 1 2 3 4 5 6 7 person 1 email data1 person 2 email dataperson 3 email dataperson one should receive an email with the 1-7 column with the data1 underneath.person two should receive an email with the 1-7 column with data 2 underneath. Will provide spreadsheet to make a little but clearer.Needed this completed in the next 12 hours.

  • kr333 SEK 3 days ago

    I need a VBA code that does the following:If data from a drop down menu in cell C1 is VALUE1 then lock CELL A1If data from drop down menu in cell C1 is VALUE 2 then lock CALL B2

  • $200 USD 3 days ago

    Looking for a macro enabled excel file for the fleet management covering the below for a manufacturing company having 100 vehicles1. Vehicle Details - Type and sub type of vehicles with Asset Details / Purchase / Insurance/ Registration / location / driver assigned 2. Daily vehicle log sheet with KM / Time / Location / Driver / for which projects used3. Daily Fuel Consumption for location / projects 4. Drivers Time Sheet to be generated from Daily Vehicle Log Sheet.5. Maintenance Log and spare parts control6. Periodic Servicing7. Different REPORTS WITH CHARTS / DASH BOARDS / SCORE CARDS

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


[see more]



Database manager

Mar 1988 - Apr 2004 (16 years)


Developed and maintained a bidding database program for a construction company<br /><br />


Bachelor in Engineering

American University of Beirut



Bachelor Degree

Civil Engineering

College Degree


Commercial Program


CalendarCan is a commercial program that I created and published in 2001