nagybatonyi

My projects:

• Put Questions from TXT File into an Excel Spreadsheet

  $60 USD
  5.0
  

  superxl2007

  10 days ago

  “ Excellent freelancer. very patient. Understood project for VB coding in excel. Would use again.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]

• Small Excel project - combine two columns from two spreadsheets

  $36.25 USD
  5.0
  

  UDC

  13 days ago

  “ He completed the project before i knew that it was started, a real excel genius. 5 stars and would recommend any time.He completed the project before i knew that it was started, a real excel genius. 5 stars and would recommend any time. ”
  Project Description: This is an easy project for someone I just cant remember how to do it :) Ok so I have a spreadsheet with 15k rows and 10 columns on one spreadsheet. spreadsheet 1 - The column concerned sku and next...
  [more]

• Modification of an existing excel sheet

  [Sealed]
  5.0
  

  frankmax

  Mar 24, 2013

  “ Great excel professional.....Project well done...very good english communication skills.....would award to him again any project requiring excel skillsGreat excel professional.....Project well done...very good english communication skills.....would award to him again any project requiring excel skills ”
  Project Description: [This is a Private Project. You must be logged in to view the Project Description]
  [more]

• MS Excel - Copy and Paste (VBA and Macro required)

  $60 USD
  5.0
  

  victorpw

  Feb 22, 2013

  “ Nagybatonyi provided valued added solutions. Many thanks for your patience and guidance.Nagybatonyi provided valued added solutions. Many thanks for your patience and guidance. ”
  Project Description: I have financial data in one format which must be converted into another report format 1. Copy data from Report format 1 (Spreadsheet 1) and paste to Report format 2 (Spreadsheet 2) 2. Spreadsheet 2 is password protected for both file and worksheet 3...
  [more]

• macro or gui app to analyse spreadsheet of gambling results

  $110 USD
  5.0
  

  paulj4908

  Feb 18, 2013

  “ Excellent , knows his stuff 100% , and sorry for the delay my endExcellent , knows his stuff 100% , and sorry for the delay my end ”
  Project Description: Hello I need a macro or small app to analyse a gambling csv file. Each race has only one winner out of 4 possible winners. The macro needs to collect the following data. The 4 possible winners are a b c or d ...
  [more]

• Excel expert needed for simple tasks

  $32 USD
  5.0
  

  mujyhane

  Feb 2, 2013

  “ He has great ability. Also, he is very communicative and responses quickly. He is able to fix problems when they occur. He is honest and good-mannered.He has great ability. Also, he is very communicative and responses quickly. He is able to fix problems when they occur. He is honest and good-mannered. ”
  Project Description: I want someone who can deal virtually everything about excel functions and macro and other things. I also want someone who is creative enough to mix various functions and macros of excel to make a desired outcome...
  [more]

• Excel or Access - Provide solution to calculate Daily closing balance from a bank statement

  $60 AUD
  5.0
  

  claytonlee

  Aug 23, 2012

  “ Excellent work.Excellent work. ”
  Project Description: I want to calculate interest on an account. Interest will be calculated daily and compounded monthly. I have a statement of the account that gives me debits, credits and a running balance. Some day there will be multiple transactions, and some days there will be none...
  [more]

• CSV Product Create and Sort

  $40 USD
  5.0
  

  Kustomise

  Jul 4, 2012

  “ Great, would use again. Thank you.Great, would use again. Thank you. ”
  Project Description: We have a csv file with approx 48k products. In reality there are only approx 1600 unique products due to colour and size combinations. I need the group product created, with size in a field, with sizes...
  [more]

• Excel Macro

  $80 USD
  5.0
  

  eswaranfree

  Jun 25, 2012

  “ Very Good JobVery Good Job ”
  Project Description: I am getting some data in the form of excel as per attachment (A) from a PLC machine.We need someone who can develop a macro to give as a output as per attachment (B). But the output data can either be in excel or pdf but must not be editable...
  [more]

• create excel macro

  $40 USD
  5.0
  

  crbalcom

  Jun 21, 2012

  “ Excellent job, exactly what I needed. Very professionalExcellent job, exactly what I needed. Very professional ”
  Project Description: I am looking for a macro I can run that will reformat data I am receiving remotely, and populate the data into a new layout that I can then paste into a separate spreadsheet. I will be repeating this process exactly the same way every time...
  [more]

nagybatonyi has not completed any projects.

• Excel Automated Betting Worksheet

  $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 "Matchup" 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.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 "Matchup" 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]

• Stadistics on an Excell Spreadsheet

  $950 MXN In Progress

  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. Work mus be done quickly and reliable.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. Work mus be done quickly and reliable.

  [more]

• <font color="#694E5A"><b>Nonpublic</b></font> project #4006219

  $230 AUD In Progress

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

• Excel Programming for Print Estimating

  $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.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]

• Add formula to spreadsheet to highlight differences between two sheets

  $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!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]

• Excel (Spreadsheet)

  $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 informationCreate 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

• Excel Whiz

  $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.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]

• Custom Project Apr 02 2013 10:00:04

  $30 USD In Progress

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

• Combine several large excel spreadsheets with multiple pages of data that have common connecting data into one pivot table report or similar.

  $150 AUD In Progress

  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's details with names and charges for each week for the last 10 years. There is another page in the same spreadsheet that has all the payments made. For the last year a new payment system was introduced that used an external finance collection service. Payment files for rent and electricity are received every couple of days and these are copied and pasted into another spreadsheet. There data that connects all this data is the site number. What I would like is pivot table style report that combines all this data and filters on site number and occupier name.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's details with names and charges for each week for the last 10 years. There is another page in the same spreadsheet that has all the payments made. For the last year a new payment system was introduced that used an external finance collection service. Payment files for rent and electricity are received every couple of days and these are copied and pasted into another spreadsheet. There data that connects all this data is the site number. What I would like is pivot table style report that combines all this data and filters on site number and occupier name.

  [more]

• Add Formula to Excel Spreadsheet

  $35 USD In Progress

  OVERVIEWWe require an excel expert to add a discount field to our price list which will automatically add the discount % entered on to the spreadsheetBACKGROUNDWe currently have a spreadsheet that gives our trade price on all our products however some customers get a set % discount off these prices. We would like to enter in this discount % and it will update ALL the prices on the spreadsheet except for the prices marked N.DOVERVIEWWe require an excel expert to add a discount field to our price list which will automatically add the discount % entered on to the spreadsheetBACKGROUNDWe currently have a spreadsheet that gives our trade price on all our products however some customers get a set % discount off these prices. We would like to enter in this discount % and it will update ALL the prices on the spreadsheet except for the prices marked N.D

  [more]

• Convert and layout Excel file to PDF file

  $55 USD Today

  im looking for someone who can make a PDF with layout from an existing EXcel file,no data input needed, only layout of the Excel file and convert to PDF2 excel file will be providedi need 2 PDF files backcheck attacment as exampleim looking for someone who can make a PDF with layout from an existing EXcel file,no data input needed, only layout of the Excel file and convert to PDF2 excel file will be providedi need 2 PDF files backcheck attacment as example

  [more]

• Excel Work

  $8 USD/hr Today

  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-KThen there are 520 companies in rows with 4000 lines (i.e around 8 rows per company)I need to align the data from the columns so that column C matches with column H for each companyAlso I need to put a space inbetween each companyMore info provided on acceptance - please tell me how long you expect this to take. 5 hours is just an estimateHave 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-KThen there are 520 companies in rows with 4000 lines (i.e around 8 rows per company)I need to align the data from the columns so that column C matches with column H for each companyAlso I need to put a space inbetween each companyMore info provided on acceptance - please tell me how long you expect this to take. 5 hours is just an estimate

  [more]

• excel formula - repost 2

  $35 USD 3 days ago

  I need an excel 2010 if, vlookup formula written urgently.I need it to match the value of A1 (sheet 1) lookup sheet2 and return the value of B column sheet 2 into B column sheet 1.The example takes the value (content) of A1 of Sheet1, search in the range of A: B of Sheet2 and returns the value (content) of Sheet2 column B to column B of Sheet1I need an excel 2010 if, vlookup formula written urgently.I need it to match the value of A1 (sheet 1) lookup sheet2 and return the value of B column sheet 2 into B column sheet 1.The example takes the value (content) of A1 of Sheet1, search in the range of A: B of Sheet2 and returns the value (content) of Sheet2 column B to column B of Sheet1

  [more]

• excel formula - repost

  $35 USD 3 days ago

  I need an excel 2010 if, vlookup formula written urgently.I need it to match the value of A1 (sheet 1) lookup sheet2 and return the value of B column sheet 2 into B column sheet 1.I need an excel 2010 if, vlookup formula written urgently.I need it to match the value of A1 (sheet 1) lookup sheet2 and return the value of B column sheet 2 into B column sheet 1.

• need some to fix excelle macro problem, easy fix

  $13 USD/hr 5 days ago

  I have an spreed sheet setup to were I update some information then run the macro, but when I hit the button to process the macro it only processes one tab, when there are about 3 more pages that it needs to process the information on, this is a quick fix for someone who is experienced with developing macroI have an spreed sheet setup to were I update some information then run the macro, but when I hit the button to process the macro it only processes one tab, when there are about 3 more pages that it needs to process the information on, this is a quick fix for someone who is experienced with developing macro

  [more]

• Data Analysis Tool Required

  £166 GBP 8 days ago

  Create Interface to run extract of data held in .CSV file. File format is described in Table A.Interface will allow entry of search criteria described in Table B.Interface will include a 'Run Query' button that will execute extract of data based on the selection criteria entered.Two new files will be created as result of 'Run Query' action. In .CSV format.1) Data File in same format as Table A but with addition of fields added in Table C. NB Data will be ordered by Date and Time, (columns BG and B).2) Summary of Data File in format Table D.Please provide overview of your proposed solution. Can run on Windows 8 or Mac - (NB Mac preferred)Specification document attachedCreate Interface to run extract of data held in .CSV file. File format is described in Table A.Interface will allow entry of search criteria described in Table B.Interface will include a 'Run Query' button that will execute extract of data based on the selection criteria entered.Two new files will be created as result of 'Run Query' action. In .CSV format.1) Data File in same format as Table A but with addition of fields added in Table C. NB Data will be ordered by Date and Time, (columns BG and B).2) Summary of Data File in format Table D.Please provide overview of your proposed solution. Can run on Windows 8 or Mac - (NB Mac preferred)Specification document attached

  [more]

• Custom Project May 13 2013 10:15:42

  €30 EUR 9 days ago

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

  [more]

• Image Renaming

  £277 GBP 9 days ago

  I have 10,000 images in various folders which all need renaming for use on a website. I have an Excel sheet with 4 columns. Column A = Product CodeColumn B = DescriptionColumn C = BarcodeColumn D = New name for the imageNow, the existing name of the image could be a value in either Columns A or B or C. I am wondering if you can help create some script that will automatically scan the images in a folder and rename them by comparing the existing name of the image to either Column a or B or C and then renaming the image to the corresponding value in Column D?Please let me know if this possible or something similar and the cost.I have 10,000 images in various folders which all need renaming for use on a website. I have an Excel sheet with 4 columns. Column A = Product CodeColumn B = DescriptionColumn C = BarcodeColumn D = New name for the imageNow, the existing name of the image could be a value in either Columns A or B or C. I am wondering if you can help create some script that will automatically scan the images in a folder and rename them by comparing the existing name of the image to either Column a or B or C and then renaming the image to the corresponding value in Column D?Please let me know if this possible or something similar and the cost.

  [more]

• POS Cash Register in Excel for Antique Store

  $277 USD 12 days ago

  Basically, I own a Resale Store with multiple vendors. Each vendor has an ID# on their product. I need a cash register program in Excel that will operate like a regular register, print receipts for sales, and record the sale data which can be recalled later and sorted by vendor, daily sales, weekly, etc...The register needs tabs to access register, vendors list, sales dataThe vendor list will have links to individual vendor pages showing the sales for that vendorI know there are a lot of excel sheets out there that do this, but I need one specifically for me. We do NOT do inventory, so the register input will be (Vendor ID#) then (Product Description), (quantity), (Discount if any % or $ off), and automatically calculate sub-total, tax, payment received, and then change due.We do accept credit cards and checks, so payment type needs to be recorded as well.This job will obviously bring you MORE work as we develop and fine-tune the software for our growing needs.I have a very detailed description of everything I need, and communicate very closely with developers, so if you have the experience with excel and databases, you should be able to create this without a problem.Basically, I own a Resale Store with multiple vendors. Each vendor has an ID# on their product. I need a cash register program in Excel that will operate like a regular register, print receipts for sales, and record the sale data which can be recalled later and sorted by vendor, daily sales, weekly, etc...The register needs tabs to access register, vendors list, sales dataThe vendor list will have links to individual vendor pages showing the sales for that vendorI know there are a lot of excel sheets out there that do this, but I need one specifically for me. We do NOT do inventory, so the register input will be (Vendor ID#) then (Product Description), (quantity), (Discount if any % or $ off), and automatically calculate sub-total, tax, payment received, and then change due.We do accept credit cards and checks, so payment type needs to be recorded as well.This job will obviously bring you MORE work as we develop and fine-tune the software for our growing needs.I have a very detailed description of everything I need, and communicate very closely with developers, so if you have the experience with excel and databases, you should be able to create this without a problem.

  [more]

• Excel Macro to keep a record of members and create outlook message

  $277 USD 13 days ago

  I require a spreadsheet designing that will allow me to enter new members details into a spreadsheet, then allow me to press a button and all the email addresses get pasted into a New message window in outlook.Full instructions are in the attahcments.I require a spreadsheet designing that will allow me to enter new members details into a spreadsheet, then allow me to press a button and all the email addresses get pasted into a New message window in outlook.Full instructions are in the attahcments.

  [more]

• Excel Work and Mail Merge

  $11 USD/hr 13 days ago

  Hello;We are looking for someone who can help us with mainly some excel work. We receive Excel sheets, CSV files, Text Files from customers and they are not uniformed, so for us to upload them on our software we need to make them uniformed. Sometimes this task is done manually, sometimes you gona need to write your own macro, or VBA script, etc. What ever it takes to get it in the format we want. You need to be quick and available for work immediately once we get these files. You are proven to be committed, responsive and accurate, we might let you get long term projects cause these are on going tasks that we always do. For now we will try you for a month. You must be very accurate as you work on these files. Again availability is essential, once we email you files we expect you to be responsive and communicate clearly with us that you received it and that you know exactly what's needed to be done and start work on it immediately. I'm looking for someone who in the future will be willing to work during USA working hours to ensure quick communication.Hello;We are looking for someone who can help us with mainly some excel work. We receive Excel sheets, CSV files, Text Files from customers and they are not uniformed, so for us to upload them on our software we need to make them uniformed. Sometimes this task is done manually, sometimes you gona need to write your own macro, or VBA script, etc. What ever it takes to get it in the format we want. You need to be quick and available for work immediately once we get these files. You are proven to be committed, responsive and accurate, we might let you get long term projects cause these are on going tasks that we always do. For now we will try you for a month. You must be very accurate as you work on these files. Again availability is essential, once we email you files we expect you to be responsive and communicate clearly with us that you received it and that you know exactly what's needed to be done and start work on it immediately. I'm looking for someone who in the future will be willing to work during USA working hours to ensure quick communication.

  [more]

• Excel Macro Required

  $40 USD 16 days ago

  I need an excel macro written that can group rows in a spreadsheet where certain text shows up in a cell. I can provide a spreadsheet that will show how all the data looks before formatting and what it should look like after running the macro. I am currently formatting the spreadsheet manually.The data I'm working with can have up to 180 rows in a worksheet, with the following sub headings included:---------------------------------------------------------------TOTAL INCOMEEXPENDITURETotal Service PurchaseTotal Client ServicesTotal Corporate ServicesTOTAL EXPENDITURENET INCOME / (DEFICIT)---------------------------------------------------The headings shown above represent the way I need the worksheet to look after running the macro however the original format includes a number of various income and expense items under each sub heading. These all need to be condensed and grouped together.I need an excel macro written that can group rows in a spreadsheet where certain text shows up in a cell. I can provide a spreadsheet that will show how all the data looks before formatting and what it should look like after running the macro. I am currently formatting the spreadsheet manually.The data I'm working with can have up to 180 rows in a worksheet, with the following sub headings included:---------------------------------------------------------------TOTAL INCOMEEXPENDITURETotal Service PurchaseTotal Client ServicesTotal Corporate ServicesTOTAL EXPENDITURENET INCOME / (DEFICIT)---------------------------------------------------The headings shown above represent the way I need the worksheet to look after running the macro however the original format includes a number of various income and expense items under each sub heading. These all need to be condensed and grouped together.

  [more]

• Simple Excel macro

  $45 USD 20 days ago

  A simple macro that iterates through a defined number of times, appending the appropriate suffixes. There are two columns of data which need to be generatedA simple macro that iterates through a defined number of times, appending the appropriate suffixes. There are two columns of data which need to be generated

• Convert Addresses from PDF to Excel

  $330 USD 21 days ago

  Each page has 10 rows and 3 columns, each space has an address on it. I need each of these addresses organized in Excel. If you know how to convert from PDF to Excel, please post your bid. Needs to be completed by tomorrow morning. Thanks! HappY BiddingEach page has 10 rows and 3 columns, each space has an address on it. I need each of these addresses organized in Excel. If you know how to convert from PDF to Excel, please post your bid. Needs to be completed by tomorrow morning. Thanks! HappY Bidding

  [more]

• Excel spreadsheet design development

  $1650 USD 21 days ago

  I receive weekly sales data from multiple accounts that sell our various products. The output format is the same for each report each week and I need an excel spreadsheet/database that will allow me to drop in the sales data into the spreadhseet for the week and have the spreadsheet run autonomously to generate a tabulated sales overview of results. I would like to be able to add to the spreadsheet on a weekly bases, and be able to review per store, by product, monthly results, and have a running total for each of the products, with a overview page that outlines how the year was a success.I receive weekly sales data from multiple accounts that sell our various products. The output format is the same for each report each week and I need an excel spreadsheet/database that will allow me to drop in the sales data into the spreadhseet for the week and have the spreadsheet run autonomously to generate a tabulated sales overview of results. I would like to be able to add to the spreadsheet on a weekly bases, and be able to review per store, by product, monthly results, and have a running total for each of the products, with a overview page that outlines how the year was a success.

  [more]

• Fuel Consultants

  $330 USD 22 days ago

  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 & graphical format.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 & graphical format.

  [more]

• Needed an expert Excel developer

  $330 USD 24 days ago

  Need someone to develop a program in excel for me. I have the basics but I need to get it to where it needs to be. Heavy formula usage. So please contact ONLY if you are an expert in Excel.Need someone to develop a program in excel for me. I have the basics but I need to get it to where it needs to be. Heavy formula usage. So please contact ONLY if you are an expert in Excel.

• sumif by day of the year - repost

  $66 USD 26 days ago

  We have recurring expenses that are due on certain days of the year. If the payment date falls on a weekend or holiday the payment will occur on the next business day after the weekend or holiday. I need a formula that will sum all payments due for a certain day of the year that will conform to the rules above. Please see attached example.We have recurring expenses that are due on certain days of the year. If the payment date falls on a weekend or holiday the payment will occur on the next business day after the weekend or holiday. I need a formula that will sum all payments due for a certain day of the year that will conform to the rules above. Please see attached example.

  [more]

• Excel VBA form entry

  $55 USD 28 days ago

  I need an excel form to edit data in an excel spreadsheet. Rows hold metadata regarding files in a document library.What I am looking for is independent of of the actual content of the data, Except that you need a column to hold the file path and a column (or morre) to hold a flag regarding what needs to be happening with a particular row.Had this been MS access, this would be a 1 min project.All this needs to do is to enable user to edit rows in a form formata bit like thishttp://www.filedudes.com/images/screenshots/44203.gifThe only little issue is that not all fields need to be editable in the form. Therefore, you would some kind of config area to limit what fields are needed.so for example, clicking column A in a given row would load the editable fields of that row and allow and save it when done.Just so I know we are on the right track, let me know if you understand what I am describing and please evaluate how long it would take.Please note that I need this right away, therefore only apply if you can work immediately.Also make sure the first word of your reply is EX03 (otherwise I will not even read your application)I need an excel form to edit data in an excel spreadsheet. Rows hold metadata regarding files in a document library.What I am looking for is independent of of the actual content of the data, Except that you need a column to hold the file path and a column (or morre) to hold a flag regarding what needs to be happening with a particular row.Had this been MS access, this would be a 1 min project.All this needs to do is to enable user to edit rows in a form formata bit like thishttp://www.filedudes.com/images/screenshots/44203.gifThe only little issue is that not all fields need to be editable in the form. Therefore, you would some kind of config area to limit what fields are needed.so for example, clicking column A in a given row would load the editable fields of that row and allow and save it when done.Just so I know we are on the right track, let me know if you understand what I am describing and please evaluate how long it would take.Please note that I need this right away, therefore only apply if you can work immediately.Also make sure the first word of your reply is EX03 (otherwise I will not even read your application)

  [more]

• Excel Macro to copy/insert data

  $825 USD 29 days ago

  I need an Excel Macro Developer to create a macro that copies data from one spreadsheet any imports the data into another. The data being copied from one spreadsheet needs to be intelligently inserted into the other spreadsheet. The spreadsheets will have multiple worksheets within them. The macro will need to be able to find the data to be copied within any of the worksheets within the source spreadsheet. Please submit estimated time and project costs.I need an Excel Macro Developer to create a macro that copies data from one spreadsheet any imports the data into another. The data being copied from one spreadsheet needs to be intelligently inserted into the other spreadsheet. The spreadsheets will have multiple worksheets within them. The macro will need to be able to find the data to be copied within any of the worksheets within the source spreadsheet. Please submit estimated time and project costs.

  [more]

nagybatonyi does not have any open projects.

nagybatonyi does not have any work in progress.

Portfolio

Description

Related Work

nagybatonyi Portfolio