offline
Last seen: Apr 06, 2014 10:22 AM EDT
Hire Me!
Rate: $25.00 USD/hour
Follow Invite to Project
 

nagybatonyi

Excel/VBA expert

Username: nagybatonyi

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

Location: Budapest, Hungary

Member since: June 2009

Reputation:

4.9/5

(53 reviews)

5.7
[see more]

No user has recommended this freelancer.

My skills:

My projects:

  • $10 USD
    5.0
    Profile image for Seller priyal1997

    priyal1997

    Feb 6, 2014

    Grate freelancer and highly capable of handling any excel project. Thanks for your great work!!!!!<br/>

    Project Description:Please convert bellow attached PDF file to excel tables I will offer and pay to the 1st person It will take only 5 minutes if you have the software
    [more]
  • $10 / hr USD
    0.0
    Profile image for Seller CS01

    CS01 [ Incomplete Report ]

    Feb 3, 2014

    The freelancer had worked for me before, and I was quite satisfied with the results and communication during the prior project.This project, however, was a disaster. It seemed that he first did not fully work for the project. Then he delivered an incomplete piece of work. Later he informed me that he got sick. This happens, of course, but as an employer I expect to get a brief information from time to time how he is doing, especially if I inform the freelancer that he/she is working on a time-critical project.After a while I approached the freelancer with several messages, geeting no feedback after he was online again. I send him a final note that I would cancel the project if I would not receive any piece of work soon - which I finally did after three days of no response. I am disappointed as I could not meet the deadline of a project myself since the freelancer failed to deliver his piece of the puzzle.<br/>

    nagybatonyi's reply:

    Sorry, I was in hospital for a long time with a disease much worse than a flu and had no access to the web. Very sorry again.

    Project Description:The Pivot table looks very much the same, but there is a major difference: while in the case you worked with there were just 1 or &quot;nothing&quot; in the cells, here, the values can be larger than one. But what counts is that there is anything in the cell (1 or 2 or 3 or ...) could be considered as one...
    [more]
  • $36 USD
    4.6
    Profile image for Seller CS01

    CS01

    Feb 3, 2014

    Professional freelancer, delivered high-quality work. Will hire him again.<br/>Overall, great work and excellent communication. I am negotiating with the freelancer for a follow-on project.

    Project Description:I am looking for an macro that calculates an index = 1 minus the Herfindahl Index for companies listed in a pivot table. More specifically, the index shall be computed based on the distribution of drugs across different classes...
    [more]
  • $950 MXN
    5.0
    Profile image for Seller corberanetw

    corberanetw

    Jul 22, 2013

    Profesionalism, expertise. I would hire him again for sure.

    Project Description:I need to calculate some stadistics and make some grafics on a spreadshet. Also some conditional color have to be applied. Attached, it is the file. The second tag contains details about the data processing...
    [more]
  • €88 EUR
    4.8
    Profile image for Seller tkrombac

    tkrombac

    Jun 26, 2013

    Great work, thank you very much!

    Project Description:We received several hundred Excel files from a client which represent individual invoices. In order to be able to do statistics on these invoices we would like to extract the relevant information (client number, date, client name, amounts) and list them in a separate aggregated file...
    [more]
  • $165 AUD
    5.0
    Profile image for Seller JRReynolds

    JRReynolds

    Jun 19, 2013

    I really appreciate your work istvan. I'll be in touch for any future work.

    Project Description:I have several large excel spreadsheets that have data going back 10 years for a 64 site caravan park in Brisbane Australia. The data has each site&#039;s details with names and charges for each week for the last 10 years...
    [more]
  • $2 USD
    5.0
    Profile image for Seller priyal1997

    priyal1997

    Jun 11, 2013

    This was a complex formula... Lots of ppl try to solve it. But nagybatonyi is the only person who solved that formula.. if you need anything to be done in excel don't go anywhere SOLUTION is here.. thank you very much!!<br/>

    Project Description:Help on attached formula Please send me the answer and i will pay to very 1st correct answer Budget is $2. Only take 5 minutes Thanks
    [more]
  • $41.25 USD
    5.0
    Profile image for Seller Jmackie

    Jmackie

    May 30, 2013

    Excellent person to work with. Good comprehension, he did it right first time and nothing was to much trouble. Will definitely use again!

    Project Description:OVERVIEW We require an excel expert to add a discount field to our price list which will automatically add the discount % entered on to the spreadsheet BACKGROUND We currently have a spreadsheet that...
    [more]
  • $45 USD
    5.0
    Profile image for Seller tbeevers20

    tbeevers20

    May 24, 2013

    An excellent freelancer. He is a genius with excel and it seems nothing is beyond him! He is quietly efficient and I ended up saving time versus a less experienced person because he understood what I was trying to do very quickly and delivered it promptly. This was worth a lot to me so I was glad I paid a little extra for him. I would definitely hire him again!<br/>

    Project Description:Have an excel spreadsheet that requires some tricky manipulation. I have two sets of data - one set is in columns C-F and one set in columns H-K Then there are 520 companies in rows with 4000 lines (i.e...
    [more]
  • $60 USD
    5.0
    Profile image for Seller superxl2007

    superxl2007

    May 11, 2013

    Excellent freelancer. very patient. Understood project for VB coding in excel. Would use again.

    Project Description:I need to extract the questions and answers from a PDF book (I converted it to TXT as you find this easier to manipulate the text from) and place the questions with their corresponding answers in an excel spreadsheet...
    [more]
    nagybatonyi has not completed any projects.
  • $61 AUD In Progress

    Hi, I need this work to be completed in the next 4 hours.I need to create a collapsible table on the Summary sheet with amounts found in Data sheet. The columns will come from the Stores sheet. And the rows from the Accounts sheet.These need to be dynamic macros as the Store and Account data will be loaded daily and may change.Accounts have levels (this is where they will sub total and expand/ collapse)Each store will have 5 (configurable) columns of data.Stores have levels (this is where they will sub total and expand/ collapse). Each store will be represented across the top of the reportThe Summary sheet will have some configuration data as well.Please let me know if you are able to do this job. I have a sample file ready to go, see attachment.Thank you

    [more]
  • $35 USD In Progress

    We have an exel file with 15.000 rows. In every row there is the Name of a City. We need someone who fill in a word before the City. Example: source data: citynew data: hotel city 1hotel city 2hotel city 3hotel city ...hotel City 15.000

    [more]
  • $19 USD/hr In Progress

    Hello, we require someone to assist with analyzing MS Excel spreadsheets. This work will range from basic requests such as computing outcomes from existing data (ranks, averages) through to more complex VB scripts and preparation of graphical reports. The work will be ongoing on a casual basis as needed. Immediate start.

    [more]
  • $30 USD In Progress

    i would like to talk to you about the data, i concerned about the security of our data base..

  • $15 USD/hr In Progress

    Create a workboook in excel with more advanced options. You will be required to compile into a master summary for the day. Will give you more information

  • $8 USD/hr In Progress

    I have a spreadsheet with two sheets. Each sheet has the same columns with the SKU column containing the unified identifier record. I would like sheet 1 to compare itself to sheet 2 and highlight new rows from sheet 2 (not currently present in sheet 1) in green and highlight rows no long present in sheet 2 (but still present in sheet 1) in red. Ideally I would like to copy and paste in data into each sheet every week so this spreadsheet needs to be set up to use continuously.Thanks!

    [more]
  • $35 USD In Progress

    I need someone to create an Excel spreadsheet to help me streamline my sports betting hobby. I would like to be able to paste a couple of tables with cities and values associated with these cities on a worksheet and then be able to type in these city names in &quot;Matchup&quot; fields where information will be extracted out of the pasted tables, that correspond with those city names. There will be some light math involved to get some predicted point spreads and winning percentages, but that can be found on the spreadsheet provided. The important thing is that the information in the tables will change everyday, including the order of the cities listed but the tables themselves will always be the same size. I just want to type in a city in a field and have selected info pulled from a table I will paste in everyday.

    [more]
  • $230 AUD In Progress

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

  • $140 USD In Progress

    We are looking to produce an excel worksheet to use for Print Estimating for our printing company. Print estimating requires estimating 4 to 6 different parts of the print job and then adding them all to produce a cost. Then adding a profit margin to produce the selling prices for a range of quantities. 1000 brochure, 2000, 5000, 10,0000 etc......We will tell you exactly how the formula that is to be used for every section and you just have to organize it , use the formulas and create drop boxes for different paper stocks , and calculations etc.... Its not a complicated job, but it needs a very good knowledge of excel. The project will require a lot of communication between us to make sure all the concepts are understood clearly. We want a clean project with easy to use date entry and drop boxes so we can use it easily and simply to produce printing quotes for our customers.

    [more]
  • $25 AUD Feb 2, 2014

    i urgently need a macro written. I need a macro to have lines duplicated one under another 10 columns across. 20000 rows long. I will send an example when the project is awarded.

  • $50 USD Nov 5, 2013

    We currently have an Excel data base of our products and pricing. We need a Quote Sheet template to enter item part number and the template will pull the price and description from the existing Excel data base that we have created.

    [more]
  • $277 USD Sep 17, 2013

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

  • $35 AUD Aug 10, 2013

    Hi, I would like some help with what is hopefully a simple excel project which could grow into a bigger project over time. We are a small company who manages investments on behalf of less than 50 clients. We buy and sell investments (in particular, shares/stocks) on behalf of each of the clients and record these transactions in a single excel spreadsheet. The project is to provide us with the ability to take the transactional data and transform it into a &quot;point in time&quot; report (eg. monthly) for each client so that we can see summary of their investments and other data at that point in time. Some example data is attached. We would like to avoid the use of macros if possible and want something highly flexible where we can add fields, columns, rows, clients, investments and other parameters over time. We are just focused on getting the excel logic right at the start then we can build it from there.

    [more]
  • $45 AUD Jun 3, 2013

    I have a spreadsheet to calculate rations for cows. It is very simple. I want to change the sheet so that one spreadsheet holds the reference data and another sheet does the calculations. The reference data can contain 50 or so different feed types. Each ration is made using 7 to 10 feed types. This should be quite simple to build for me. I&quot;ll send you the file I use know for modification.

    [more]
  • €30 EUR May 13, 2013

    Online-shophoz (fajdalomcsillapito tapaszok) csatoltan szeretnek egy olyan programotiratni, mely segit a betegnek(?) kivalasztani a neki legmegfelel&ouml;bb kombinaciot.&Ouml;sszesen kb.20 adatbol kellene kiindulni es ezekhez hozzarendelni-kivalasztani mintegy 10-15 lehetseges tapaszbol a legmegfelel&ouml;bb kombinaciot. Archivalas, k&uuml;l&ouml;nb&ouml;z&ouml; adatcsoportok visszakereshet&ouml;sege fontos.Nemet es angol nyelven kellene az egesz.Ha erdekli az egesz, akkor termeszetesen b&ouml;vebb leirast is adok.&Uuml;dv. Dani Arpad

    [more]
  • $330 USD Apr 29, 2013

    1. Develop a system that will allow me to import csv files from different providers and show which provider has the lowest price when looking up a location.2. Show that the prices provided from these providers are tracking according to data I input weekly.3. Set up a system that will allow me to enter an invoice and check it against the price provided from the providers csv spreadsheets to ensure the prices are accurate.4. The system will track the invoices so that I can provide an end of the month report along with any savings in numbers format &amp; graphical format.

    [more]
  • $60 USD Apr 5, 2013

    I want an Excel Macro that can be manually triggered from within a workbook that copies data from source workbooks to specified cells within the destination workbook. More details and the source and destination files are attached

    [more]
  • R2000 ZAR Mar 18, 2013

    I require a dental invoice system that uses excel. I have around 100 treatment codes, with each code representing a description and a price. Its simply an invoice with a recording feature that is required. There are around 20 different prices for each code. I would like a drop down box selecting which price list i want and be able to type the codes in column and the desciption and price should show.

    [more]
  • $40 AUD Feb 14, 2013

    A government department has posted PDF files full of historical performance data, but hasn&quot;t released the underlying data in excel format.I need all the data entered into Excel with 100% accuracy in order for me to conduct analysis.

    [more]
  • $50 USD Nov 4, 2012

    I need help in excel. I will provide more details in PMB.I need help in excel. I will provide more details in PMB.Thanks

  • [Sealed] Jun 3, 2012

    Hello!Our company is looking for an individual who is highly skilled in Excel VBA Programming. Some features of the programming required will include the Find function, loops, nested loops and other nested function statements. We have already inputted the data into a macros-enabled Spreadsheet. We just need some help programming how that data will interact with itself. Some of the programming is already done for you, we just need someone to help finish the project. This is a highly proprietary project and due to company policy will require you to sign, scan, and email a Non-Disclosure Agreement before being accepted to work on this project. We would request at least 2 reviews/revisions of the project before funds are transferred. This should be an easy project for someone who is experienced in Excel VBA programming. We want to develop a long term professional relationship with an individual for future projects and further adaptations to the current project. We are offering $100 base pay plus a $25 bonus for completion within 3 days of starting project. There is also another special bonus that will only be discussed with the winning freelancer. We will provide all of the detailed information, which includes the xlsm spreadsheet, ranges, instructions, and calculations to complete this project to the winning freelancer.We look forward to working with you!

    [more]
  • $250 AUD Jan 28, 2012

    I have a completed spreadsheet and merge document but the data just wont merge properly in one field. A fairly simple job for anyone with a bit more than basic Excel ability

  • $120 AUD Jan 6, 2012

    Repair macro&quot;s for simple data entry on the attached spreadsheet and create 2 other similar workbooks.

  • $35 USD Sep 22, 2011

    I&quot;m a total novice trying to cheat the system by patching in 2 codes, one to email Excel sheets from Outlook; and the second, to trigger the insertion of a new line automatically (retaining embedded formulas but no input data) when the user activates a given cell on the form. I was successful with the first patch using a program called RDBOutlook (RDBMailOutlook). But I can&quot;t get the second piece to work with any codes I have found that are supposed to add the line. The codes I&quot;ve tried generate &quot;Ambiguous..&quot; or &quot;Syntax Errors&quot; or just don’t respond and I can&quot;t resolve any. Need help with codes and testing. Thank you

    [more]
  • €60 EUR Aug 30, 2011

    I need a software to import a excel file and to use the values in it to calc some percentages.I&quot;ll give the full details to the interested freelancers.

  • $40 USD Aug 19, 2011

    I need a little calculator that could do the following:Convert binary numbers to decimal numbers and vice versa. Does calculations in decimal and binary, only + - * / needed.Input of the numbers should be possible with keyboard and buttons of the calculator.The calculator should have a clickable copyrightlink link like &quot;brought to you by website.com&quot;Binary files needed.Payment will be released when job is over.Rules:- No software that already exists- Runs on windows

    [more]
  • $90 CAD May 13, 2011

    Our accounting department is currently provided GL data in an Excel spreadsheet for multiple locations summarized into daily totals (see sample attached). Each month they need the data in each tab converted to a CSV format to import into their accouting system. Each tab in the Excel spead sheet has specific data extracted and reformated into a CSV file (sample attached)

    [more]
  • $1500 USD Mar 13, 2011

    I have a 16 page document which i need formatted into a MS excel document just following the 5 columns and rows layout of the pdf form. pls provide indication of max time req for this project. must be available for immed start [Removed by Freelancer.com Admin]

    [more]
  • $40 USD Feb 22, 2011

    Hi,I need an excel sheet that will read all the files from a given folder (and sub-folders too).The developed workbook should be able to create a list with the contents of the selected folder (an index).Thank you!

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

Portfolio

[see more]