Microsoft Excel Jobs

13 were found based on your criteria

  • Fixed-Price – Est. Budget: $5.00 Posted
    I already made an Excel file with 4 sheets 1st is Invoice 2nd is customer 3rd is products and 4th is Invoice register and commissions (for affiliates or salesmen) Most of the information I need to create my invoice I get it from the customer sheet using a dropdown list (in cell B13 ) for the information about the customer and a drop down list (located in cell B22)for the products .To do that I use mainly the Vlookup function ...
  • Fixed-Price – Est. Budget: $25.00 Posted
    Looking for a programmer with Excel and VBA experience who can work within our budget. I need you to fix and create an excel automation to transfer sales reports and then create some tools to generate reports and line graphs for us. Requirements: - internet with good connection - must have an attention to details
  • Fixed-Price – Est. Budget: $10.00 Posted
    I have datasets with roughly 5,000 cells of data. From these cells I want to match specific names, a list of roughly 100, and have them identified so that we can sort them and provide additional analysis on these results. See the attachment with three tabs. Tab A: Data to Search (This is my data where I want to find the specific names.) Tab B: Names to Find (This is a partial list of the names I want to ...
  • Fixed-Price – Est. Budget: $70.00 Posted
    We want a simple, fast and elegant solution for generating barcodes for our packaging process. The current process includes three Google documents: 1. spreadsheet containing the read barcodes of the items, in text form (MAC addresses and serial numbers of modems), 2. another barcode generating spreadsheet using a third party generator, which also adds the necessary content to the barcodes (type of modem, what codes are used, such as MTA MAC, S/N, etc.). However, its formatting cannot be used ...
  • Fixed-Price – Est. Budget: $5.00 Posted
    I already made an Excel file with 4 sheets 1st is Invoice 2nd is customer 3rd is products and 4th is Invoice register and commissions (for affiliates or salesmen) Most of the information I need to create my invoice I get it from the customer sheet using a dropdown list (in cell B13 ) for the information about the customer and a drop down list (located in cell B22)for the products .To do that I use mainly the Vlookup function ...
  • Fixed-Price – Est. Budget: $35.00 Posted
    we have our own standard CSV file and there are another 2 X-Cart formats one is for shopify and one for ECWID. we need to re shape tha data from our standard CSV to those files and the problem is not with regular fields such as product ID, Description, Name The problem with the Products Options such as Size, Color, etc. there are 4 options types can be added Drop Down menu, Radio box, Date Picker and Text Field, We ...
  • Fixed-Price – Est. Budget: $500.00 Posted
    Our clients use an excel document to input their products and inventory into. We then upload that file to our servers and onto their system. This allows them to streamline the process to import their inventory. The problem is, NOBODY fills out the document correctly. Nobody. SO! We would like to develop a tool that checks for them and makes it fool proof. Here is the desired flow: A button will be placed inside our system that says "Import Wizard ...
  • Hourly – Less than 1 week – Less than 10 hrs/week – Posted
    All within the same google spreadsheet. Fix # 1 : A reference to a 2nd sheet, creating a stock count of all rows in the 2nd sheet that match a reference number & also has a designation of 'active'. My current formula only counts all rows in 2nd sheet which matches the ref #: =countif('Serial Inv.'!W:W,B5) Fix # 2 : A reference to a 2nd sheet, identifying the earliest (smallest) expiration date of all rows which match a sku. My current formula ...
  • Fixed-Price – Est. Budget: $40.00 Posted
    I need a utility that will automate the editing and creation of .txt files. Possible an excel script -There will be one master .TXT file that is comma delimited. -I need this file split into separate files based on the first field "CompanyCode". -In the output file the "CompanyCode" will be removed. -The output file will be named the "CompanyCode". Ex."10095.txt" -This should be semi-automatic and create one output file for every "CompanyCode" in the Master file.
loading