Online now
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



(97 reviews)

[see more]

6 users have recommended this freelancer.

  • $175.00 USD
    Profile image for Seller axiaer

    axiaer [ Incomplete Report ]

    13 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


    16 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


    17 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...
  • $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.
  • $195.00 USD
    Profile image for Seller garycmg


    Jun 4, 2014

    Obviously very knowledgable about Excel. Will definitely hire again.

    Project Description:I need an Excel spreadsheet that will calculate resource (people) allocations over time for multiple projects. I have already started the spreadsheet by creating the data entry tabs and need someone to finish the spreadsheet by creating the analysis/calculation tabs...
  • $150.00 USD
    Profile image for Seller dsmith247


    Jun 3, 2014

    Another successful project with this dependable freelancer. Do not hesitate to work with zExcel. Thanks!<br/>

    Project Description:Similar to previous projects. VBA to find data and copy to additional locations. More infor available but chat needed to fully clarify scope.
  • $200.00 USD
    Profile image for Seller CorneliusWigmore


    May 31, 2014

    Great work again. zExcel was able to tailor the macro totally in accordance with my requirements.

    Project Description:Prepare a Macro that automates a routine document production in excel to save time and make completion more efficient
  • $140.00 AUD
    Profile image for Seller kav02


    May 28, 2014

    It has been a pleasure working with zExcel - Timely and professional and delivered quality work - I would highly recommend for any Excel work but especially the more advanced work. Good job.

    Project Description:Just wondering if you know much about scripting vb in excel macros to help with graph presentation. I am a macro “record” guy only and looking to make something a bit more dynamic. I need to be...
    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]

  • $30 USD Today

    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.

  • $40 USD Today

    I am looking for a guy who can realize the following as an Excel 2013 macro:- I have the several tables in an Excel map.- In each table, there are certain values- For a total reporting, I need the following created by macro:From sheet 1, content is taken and put into the final sheet X.There are two lines freespaceThen, content from sheet 2 is taken and put into the final sheet X.There are two lines freespaceATTENTION: The amount of content will vary from reporting to reporting, but the ACTIVE.SHEET area can be determined via excel file.

  • $35 USD Today

    Convert VB.Net Function to Excel VBA ModuleI have a short VB.Net function that converts text input to Code128 for printing with code128.ttf font. I need this function translated into a VBA macro. The function is listed here: need an excel speadsheet containing the macro so that I can copy and paste the macro into multiple other spreadsheets.I think this should be a very quick project for someone who knows and VBA...

  • $55 USD Yesterday

    Simple macro (VB/Excel) needed to translate BAI2 (BAI) file into readable Excel/CSV file.If somebody already has an existing tool - I am interested to purchase.

  • ₹9000 INR Yesterday

    i have data sheet in excel. I need to run customised report from time to time which presently i am doing by using filter- copy-past to another sheet. I want any VBA code / macro to do this for me.The criteias are like party name, delivery date, item type etc. which is available in my data sheet.

  • £140 GBP Yesterday

    I am looking for somebody with advanced excel skills to organise an excel spreadsheet and briefly explain how you have achieved it.I need the attached document and listed tasks to be completed within an hour today.

  • $130 USD Yesterday

    I have an EXCEL spreadsheet that allows you enter costs for a product. Spreadsheet is attached. You should have enough expertise with profit margin calculations and EXCEL to understand the current formulas and what the spreadsheet is doing. If you can&quot;t understand every aspect of the current spreadsheet DON&quot;T BID. I will not answer your questions. You aren&quot;t experienced enough.You must explain in the private message board your understaning of our requirements. If you do not explain what you are REQUIRED to do then how do I know you understand what we need. You also have to explain your expertise with VBA, EXCEL, Macros and GUI DESIGN.In some cases the costs are in two sections. Each section is the related costs for a feature. So there are two features and the related costs. Some products only have one feature and therefore on set of costs.The spreadsheet allows the user to apply different markup percentage rates to the costs to determine what the sales price would be for the product based on the markup values.There are 3 other cost recovery percentage entries that are applied. Profit is calculated and profit margin. Using a discount percentage a reseller price is also determined.An associated business receives a percentage of gross sales. This amount is also calculated based on the sales price.The spreadsheet is setup for 6 markup scenarios that you can see in the spreadsheet all at once. The spreadsheet also has a macro that enable you to hide the scenario(s) you don&quot;t want displayed.The spreadsheet is setup with all the cells visible.The requirements of the project is to use VBA to create a very user friendly, more aesthetically pleasing GUI for non-experienced EXCEL users to enter well labelled data inputs, variables, and a more visually appealing display of results.It looks too complicated with all the spreadsheet cell and data values displaying. It also needs to be user proof so that they can&quot;t accidently delete cell formulas, make an entry in the cell where no entry is permitted and it has to look very professional, an appropriate use of colours to help identify sections, clever ways to hide scenarios the user does not want to see and is very intuitive and easy to use.The other requirement is a reverse calculation. Currently costs and markups are entered to determine a profit margin. We would like to enter costs and desired profit margin to determine all the other values e.g. sales price.100% milestone will not be considered. Lowest bidder will have an advantage in getting the project.

  • $50 USD Yesterday

    According to the attached screenshot, we were supposed to be able to enter lots of options like checkboxes, textboxes, radio buttons (when we left-click twice on the cell position of N1), but we are now constrained by row height, and the error message is showing on the screenshot as attached below.The run-time error is &quot;1004&quot;. => The Excel file is appended below.Please also see if you could enable copy-and-paste of selected rows this way to another Excel spreadsheet all those options ticked.Rest of functions to remain intact and not tampered with on the Excel fileThe Excel file is appended below.

  • $35 USD Yesterday

    Clean up formatting and add to/rearrange current cells, add header and footer. Text not data.

  • $3 USD/hr 2 days ago

    We have 1300 titles in a column.. Whose character length is between 51 and 60... Remove a word or two from the titles and make them 50 or under 50.. The next column has a length formula applied to it.. So when you remove any word it will show you the current length of that title... Make sure you remove extra words... Not the actual product or keyword... I want them done in the next 2-3 hours....Example Magic Assist Rainbow Aluminum Handle Black Blade ComboEdge (length = 59)Make itMagic Assist Rainbow Aluminum Handle Black Blade ... (length = 48)No special skills required just common sense..Thanks

  • £70 GBP 2 days ago

    I am looking for somebody with advanced excel skills to organise an excel spreadsheet and briefly explain how you have achieved it.I need the attached document and listed tasks to be completed within an hour today.

  • ₹7440 INR 2 days ago

    Sir/Madam,We require a technical person to understand our excel working and automate the final preparation of excel sheet.

  • $160 USD 3 days ago

    This project is to enter information contained in two PDF files into one spreadsheet, &quot;Card cycles and yearly spreads&quot;.\r\n\r\nThe first PDF &quot;1. Card Cycles&quot; needs to be entered into the first five sheets of the workbook, these sheets are:\r\n\r\n1.1 Cards by planet position\r\n1.2 Cards by planet line\r\n1.3 Cards by result\r\n1.4 Cards by challenge\r\n1.5 Cards by year\r\n\r\nThe PDF file &quot;1E. Example data - card cycles&quot; contains how the relevant information corresponds to the sheets. The first card from the example has been entered for these sheets.\r\n\r\nThe second PDF &quot;2. Yearly spreads&quot;, has a number of years that need to be entered into the sheet &quot;2. Yearly spreads&quot;. The PDF file &quot;2E. Example data - yearly spreads&quot; contains an example of the first year which has been entered into the sheet.\r\n\r\nI have turned on data validation to assist with accuracy.

  • $750 USD 3 days ago

    I am an avid fantasy football player. During the NFL season for 16 weeks starting from Sept 4, there will be changes to the players on my approximately 80 teams, and these changes will occur a few times a week. I would like to send you the reports of the changes and then you can update the excel spreadsheet with the same. I would guess that you will make 6 changes per team per week (at different times). The biggest work would be typically required Wednesday and Friday evening&quot;s around 11 pm EST.. That&quot;s when I could send you the reports of the changes made. You would read the report, find my team&quot;s changes, and then update my team on the excel spreadsheet. The keys to success will be (1) spelling players&quot; names correctly, (2) making changes to the correct players/teams in the excel spreadsheet, and (3) timely turn around. There will be fewer changes as the season goes on and down to 3 per team or less the final 3 weeks. There will also be a few tables to refresh.

  • $750 USD 3 days ago

    I need help in various excel work. PLEASE DO NOT BID. I will invite freelancers to work on this project.

  • ₹9000 INR 4 days ago

    I want to convert notepad csv files into Excel ones please help me budget is 50$

  • $94 USD 4 days ago

    there is a small bug in the .xlsb file and need to fix it.there copy of working version also available;i need your guide to fix it on the non working version.could be very simple for the one who knows VBA programming.

  • $22 USD/hr 4 days ago

    Need some help in re creating excel sheet. Apply only if you are an excel guru.

  • $155 AUD 5 days ago

    Hi,I need a Project reporting Excel spread sheet developed to capture daily project data and auto populate into various monthly reports including a summary page for &quot;project to date&quot; information. The file will need to have graphs included for visual representation of project data.if you are interested, please contact me to discuss the details. The data is not complex, just needs to function smoothly from one source of continuous data input (Data hub within the file)thankyou

  • $250 USD 5 days ago

    We required person who have good knowledge and experience in Data Entry and can use Excel & related all programs\r\nAll work which will provided from us should need accurate and on time so please only apply who can give much time to\r\nWork and can communicate during the work there is no time after you submit the data for to check mistakes and resend to you.\r\n\r\nNote : Job detail is attach please check before apply to this job.

    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