Excel macros jobs


My recent searches
Filter by:
    Job State
    279,370 excel macros jobs found, pricing in USD
    Help with Excel 6 days left

    I would like some minor formatting of a project management excel spreadsheet and some help to auto-generate a report from data. Task 1: I want the MMV timeline sheet to 'read' information from the corresponding data input sheet (in yellow). Where there is no value I want the cell to be blank and not contain a 0 value. Complete the formatting for the Samford site as an example (rows 9-18 in MMV timeline sheet) Task 2: I want a 'monthly report' to be auto-generated similar to the table currently in sheet entitled "monthly report Feb 21'. I will need a macro that generates a report like this each month containing data from sheet "MMV timeline" using columns B for site name and C for the theme and then the corresponding activity from the corres...

    $17 (Avg Bid)
    $17 Avg Bid
    9 bids

    i need the excel automation expert for multiple jobs. Details will be discussed.

    $7 - $72
    $7 - $72
    8 bids

    I have an excel sheet with two long columns (call them Column F and Column S) of text data with possibly upwards of 5000 rows. I need the first 80 pairs of data each transformed in one cell of an 10x8 matrix with "S" centered on the first line, then a blank line and then "F" centered on the third line. Once the first 80 cells are filled with transformed data, the next 80 pairs are then transformed onto the second sheet and so forth through the entire length of the input data. The cells are 94 pixels wide by 156 pixels high. Each cell has a border of the thinnest line available in excel. The 10x8 matrix will fill a standard 8 1/2 x 11 sheet of paper. Some rules: If data starts with leading blanks, then skip the blanks and start where there is actual...

    $107 (Avg Bid)
    $107 Avg Bid
    10 bids

    - Required a person who willing to support in valuation companies which is listed in stock market - Also should support me for Excel and virtual assistance activities. - Accounts students looking for part time also can apply. - Necessary training can be provided. - Should be good in browsing and get the right things in web. - Tamil Speaking would be added advantage. - Preference given to (Students also can apply)

    $93 (Avg Bid)
    $93 Avg Bid
    12 bids

    General Description of Task. Using the attached spreadsheet and the information provided in the attached document. The job is to enhance the attached excel file by creating a dynamic and interactive radial heat map, org hierarchy chart, strategic goals list, and organizational risk management monitoring tool. This will include creating multiple input forms, advanced macros, and calculations. The product should be delivered in macro-enabled MS Excel file but I will consider other formats as well. If you do not think excel is the best tool for this, please recommend a different tool and explain your approach and I will decide before awarding the work. Delivery Time I need this product done as soon as possible. Awarding this work will be dependent on speed as...

    $527 (Avg Bid)
    $527 Avg Bid
    17 bids

    data input online store management excel edit YOU CAN DO, see the attached for details

    $1951 (Avg Bid)
    $1951 Avg Bid
    16 bids

    Need to do right now. I cannot provide you with the website user/password so I show you with photos what i see.

    $68 (Avg Bid)
    $68 Avg Bid
    16 bids

    Hi Cristian S., Pablo gave me your contact. He created a series of Excel files and a few of them need updating so I can add more years of information. I put a $50 fixed project so we can discuss

    $50 (Avg Bid)
    $50 Avg Bid
    1 bids
    Professionalize my Site 6 days left

    ... 2. Be able to use my updated excel spreadsheet which contains book titles, book summaries, and book cover images. This will be updated over time and needs to be easily incorporated into the active Web Site, with some setup. Typical additions will be new book entries. 3. Provide a rotating selector which allows for easy selection of a book by title or possibly by book cover image. 4. Selection of a book title takes you to a page which displays the full book cover, summary of the book, and a link to where the book is available for purchase. Also on the page is a home link and a Blog link buttons. 5. Future addons to the selected page will include more material from the book, and an oral download of the text. These could be fields in the excel spreadsheet. 6. The B...

    $1156 (Avg Bid)
    $1156 Avg Bid
    19 bids

    To calculate trading probability, I need someone that summorizes & visualizes the parameters in an excel sheet. - - A ranking for probability - Drop-down fields to adjust different parameters

    $35 / hr (Avg Bid)
    $35 / hr Avg Bid
    20 bids

    One of our old employees created an excel file with 47 tabs, all linking back to a sales report. All we really need is to input the daily sales, and daily pending values, and have the report show the Sales and Pending for the day, as well as the sales and pending on the same day (6th of december for instance for previous 5 years). Every time we change the month or the year we have to spend hours recalculating the formulas. I need someone who can take this report and find an easier way to do it so the report autopopulates and also forwards to a new year. Will take an Excel / Database export to do. And probably some time, can pay hourly or bid on project.

    $163 (Avg Bid)
    $163 Avg Bid
    27 bids

    I have a large excel sheet that is already pre-formatted with some documentation based on inputs on a "data" tab. However, I also import tables from my metabolic cart and a separate heart rate variability app. Once imported, I need to manually work with the data to create the charts because some athletes go shorter and others go longer, so I'm always adjusting the input row length based on their test duration. I'm looking for a solution where I can paste these CSV tables into one excel document, set a few parameters (e.g., I want the "time" column auto-split into 3 minute segments, or 4 minute segments, etc.) and then I want that data pulled so I can get a minute by minute average, plus stage average for every 1, 3, or 4 minutes, whatever time...

    $418 (Avg Bid)
    $418 Avg Bid
    28 bids

    just ran into an issue that I need repaired immediately. i am certain that it is a simple issue but need somebody who knows VBA Please respond only if you can address the issue immediately. It is a minor project but if you are successful, i will discuss a much bigger project with you after it is running getting Runtime error; subscript out of range when I click 'debug' it says ""

    $28 (Avg Bid)
    $28 Avg Bid
    20 bids

    Can you automate your task using PAD? Example. Open excel, update month, unhide tabs, change data in a cell, copy values in a column paste it as value to a column in another cell, click on hyperlink inside excel, input variable on browser field, wait till data loads, extract as excel, copy data from extract to open file?

    $15 / hr (Avg Bid)
    $15 / hr Avg Bid
    10 bids
    Copy Data from Sites 13 days left

    In an excel file, enter the name of the journal from the list of publications. The links for the publication are already reported in the excel file. Each publication must click on the link, find the name of the journal where it was published, and copy and paste it into the excel file. The sheet "literature" contains a list of publications. NOTE: You have carefully read all of the job descriptions and have not bid copy-paste proposals. You must provide us with a screen shot of the below link indicating that you have subscribed to this channel so that we can understand you read and understand what is required.

    $17 / hr (Avg Bid)
    $17 / hr Avg Bid
    38 bids
    Tex convert 6 days left

    My project name bank reconcilliation . Bank statement text formate convert to excel and sepret debit credit entry with macro

    $24 (Avg Bid)
    $24 Avg Bid
    20 bids

    Data Excel and pdf sumited take work

    $9 / hr (Avg Bid)
    $9 / hr Avg Bid
    39 bids

    Please refer to the website or pdf and create Excel Document according to the sample. Sample:

    $18 / hr (Avg Bid)
    $18 / hr Avg Bid
    51 bids

    ...device 7. Additionaly if he wants to change the backcover of the device The price should show up already in the dropdown menu when you select the repair and if you want the additional battery change. Its an german website, i will need this in german but there are only 5-6 german words in this project. i Can give you detailed informations about the different repairs and prices, i already got and excel sheet on my website with all the repairs. The pricelist is attached in this project, please feel free and check it. (nicht verfügbar = not availalbe)/(auf anfrage = on request) At the end he should be able to select on 3 pictures if he wants to send it to us (10€ fee), he wants that we pick it up at his home (1€ per km), or if he wants to bring it to us. (without fee...

    $506 (Avg Bid)
    $506 Avg Bid
    7 bids

    Need to fetch data from a public website to an excel file using web scrapping

    $264 (Avg Bid)
    $264 Avg Bid
    30 bids

    The question should solve using excel and make the report.

    $22 (Avg Bid)
    $22 Avg Bid
    44 bids

    Need someone to enter data from my client receipts to an excel sheet. about 4000 entries

    $76 (Avg Bid)
    $76 Avg Bid
    102 bids

    I want to add an interactive calculator to my website. It is simply to work out how much revision a student is likely to do between starting revising and their exams. PLEASE READ BEFORE REPLYING. I DO NOT RESPOND TO GENERIC BIDS, NO MATTER HOW LOW! The calculation is based on a simple formula that I use in excel. It works out available time between one date and a future date, taking into account a limited number of parameters that the user can determine and change. In creating this for the website, I am looking to manage those parameters through an admin panel and also allow users to change them on the front end. The function should also include an optional data capture element that will create a subscribed user. The attached explains what I am looking for. And talks through...

    $216 (Avg Bid)
    $216 Avg Bid
    58 bids

    I'll give you excel sheet for everything required

    $10 (Avg Bid)
    $10 Avg Bid
    1 bids

    Having 7 plus of experience in developing macros

    $321 (Avg Bid)
    $321 Avg Bid
    11 bids

    I need someone to scrape data from a website I-n-d-i-a-m-a-r-t(dot)c-o-m (remove - ) I need to scrape data of Three States Each GST number will take you to a page with details there in i.e Company Name GST Number Address Phone number I want all these details in row for each GST number. I will require 3 files, each for Delhi, Haryana, Uttar Pradesh with full data in it.

    $27 (Avg Bid)
    $27 Avg Bid
    59 bids

    I want to build an excel dashboard

    $17 (Avg Bid)
    $17 Avg Bid
    28 bids

    Looking to further develop a daily report that calculates 3 different rates, as the daily hours are input. Also to calculate a hidden PO ££ and calculate as a % remaining on PO ££. I have made a start on it.

    $124 (Avg Bid)
    $124 Avg Bid
    65 bids

    Compile a list of all tour operators and travel agencies in the UAE that work for outbound tourism. Create a spreadsheet in Excel with company name, phone number, email address, website. To search for information, you will need to know Arabic, and to compile a tablet in English

    $307 (Avg Bid)
    $307 Avg Bid
    9 bids

    I need a VBA excel expert for an advanced job need to be done in 3 weeks and it basically extracts all codes and function done in an excel sheet and converts it into python functions job deadline: maximum 3 weeks salary: 500-750$ for not wasting time only experts bids

    $526 (Avg Bid)
    $526 Avg Bid
    33 bids

    ...inventory get updated on my website as well as the other two websites for that product. Third, order invoice and shipping receipt much be fetch and generated on my website for each sold product for future reference also in receipt it should show website name where product sold. Fourth, Earning logs and reports based on websites, month, week etc.. these can be exported in pdf and Excel. Fifth, Product import using CSV or Excel Sixth, Errors triggers. If any error occurs during any operation then it must be explained with an error code with an pop up alert. I open in budget so bid accordingly, do not time waste if you don't know this. No payment in advance only payment through freelance. You can discuss or ask any question. Reply with time and cost estimation. I wi...

    $814 (Avg Bid)
    $814 Avg Bid
    20 bids

    Hi! I have 4 files...4 databases. step 1- merge all 4 databases into one step 2- exclude all the members that show up more then one time. Each member should be shown only once step 3- only leave one member that has the same address and same city in the datababe (example: John Smith and Merry Smith both have addres New Street 1, city: New York ---> leave only John Smith in database) step 4- Prepare a file in word where we can print out labels to put them on envelopes. The document has to be A4 format (portrait). It is most important that The labels are Avery 3652 format (3 horizontal x 7 vertical - with no border) !!! The labels must be in this form: "Lastname" "Name" "Address" "ZIP" "City" "Country" Font must be Times Ne...

    $22 (Avg Bid)
    20 entries

    This isn't a really tough one I guess, but I am not able figure out how to do this as I am not an excel expert. I need to create a Pivot which looks like the table in the "Requirement" tab of the excel sheet uploaded on the below link I managed to add my Pivot table in the "Data and Pivot" tab, but I am struck at the below step - request you to help. Adding "% pending" column as an additional column Note that I tried "Calculated Field" option, but since the "Completed" and "Pending" columns in the Pivot are not the actual columns themselves but are column cell values represented as columns, I am not able to add the "% Pending" column as "Calculated Field" I am able to "Show Value a...

    $10 (Avg Bid)
    $10 Avg Bid
    17 bids
    List Data Entry 6 days left

    I have 4 photos of inventory list and i want it in excel

    $18 (Avg Bid)
    $18 Avg Bid
    63 bids
    Excel convert tool 6 days left

    I’m looking for an external Excel sheet that is able to use the source Excel that is filled with batch info that must be filed in single Excel sheet based on an template and store it with the name of the first coulomb in the source list and save it on the same location as the source file. So you have the next folder overview in this case: Name Name Name Name Name etc

    $39 (Avg Bid)
    $39 Avg Bid
    33 bids

    Tally, Microsoft office, Microsoft Excel, microsoft world, Hindi typing Gujarati typing Hindi typing

    $335 (Avg Bid)
    $335 Avg Bid
    1 bids


    $124 (Avg Bid)
    $124 Avg Bid
    8 bids

    I am working on Hydraulic Design Engineering in excel. I need interconnections between all of my excel files and sheets. 1) Page Numbering continuity for differnt files if I insert at different Locations. 2) Shortcut Formula for picking Some Values 3) Other Details will explain once awarded

    $15 (Avg Bid)
    $15 Avg Bid
    16 bids

    For travel company back end work, we need automation of excel sheet that can capture data in form of different components to calculate total cost. I have attached excel sheet that we use to calculate the tour cost...we feed different rates like hotels, transport, meals, guides etc etc to calculate per person cost. doing manually takes time, so if automation is possible by uploading the data in form of cvb files..and then we can just choose what is needed.

    $310 (Avg Bid)
    $310 Avg Bid
    20 bids

    Experience : 3+ Years Educational Qualification: M Pharm, PhD, MBBS ,BDS or any other life sciences degree. Role & Responsibility: To write clinical summaries/news for patients and physician audience, bringing them the latest updates from various sources like clinical research publicat...both oral and written Independent and innovative self-starter Strong organizational skills Meticulous attention to detail •Ability to quickly distil complex information into essential elements relevant to clinicians at the point of care Excellent medical literature retrieval and evaluation skills •Ability to manage multiple projects in a fast-paced setting •Proficient knowledge of MS Word, Excel, PowerPoint We are looking to hire a long term working partner and not on a...

    $366 (Avg Bid)
    $366 Avg Bid
    7 bids

    A client of ours is looking for an application to use in house to be used by every department for entry and database purposes. So far they have been doing all this work on excel. So whenever seniors have to check the status, they have to see it from different -2 files and cross department check was a herculean task for them. So he needs an application for him. The application flow chart will be like this. Total 8-9 internal department 1-IQC (internal quality check of raw material) 2-Cutting 3-Printing 4-Preparation will have more departments HF (high frequency) / Laser cutting / Fuzzing / Embossing / Re cutting / Repackaging ) 5- Stitching 6-Assembly 7-Packing (A grade / B Grade / C grade) 8- Finish Goods (Sold/Unsold in stock at go down) (A-Grade ,B-Gr...

    $998 (Avg Bid)
    $998 Avg Bid
    15 bids

    I have account statements in excel for local accounts with debits that need to be reconciled to the credits received in headquarters accounts. I want an algorithm or code built (on the Fly or Database) to reconcile transfers, flag questionable debits from local accounts, and also create logs for the results. Only experienced developers. Complete job 3 days or less. More details and sample files would be provided to the chosen developer.

    $141 (Avg Bid)
    $141 Avg Bid
    17 bids

    looking for an excel expert who can make a monthly report for both billing and status on demand

    $429 (Avg Bid)
    $429 Avg Bid
    53 bids
    Excel translator 6 days left

    The Excel tool translates texts from column D to column E. The languages are entered in cells B2 and B3. The translation is done with DeepL. Unfortunately, this Excel tool does not work since yesterday. I need someone who can fix this tool again.

    $23 (Avg Bid)
    $23 Avg Bid
    21 bids

    For travel company back end work, we need automation of excel sheet that can capture data in form of different components to calculate total cost. I have attached excel sheet that we use to calculate the tour cost...we feed different rates like hotels, transport, meals, guides etc etc to calculate per person cost. doing manually takes time, so if automation is possible by uploading the data in form of cvb files..and then we can just choose what is needed.

    $342 (Avg Bid)
    $342 Avg Bid
    26 bids

    I have a required to upl...research and do by yourself! The info is easily available on web! 7. Your quote MUST include HOURLY rates for similar future work! 8. I need this job completed within Maximum 7 days and full payment will be released only after the job is completed to my satisfaction! 9. The IMAGES & PRODUCT DESCRIPTION must be Unique, should not be copied from other sites! Avoid Plagiarism! I will need source in Excel (with link) to source of royalty free images, so that I can ascertain that these are not copied from other sites! YOU need to ADD 5 new categories Spices & Pulses, Groceries, Leaves, Dry Fruits and Groceries , total of 150 products Just for me to be sure that you have read my brief in Detail please type the word “Star” at the beginning of ...

    $186 (Avg Bid)
    $186 Avg Bid
    21 bids

    Hi, I am looking for an expert in Microsoft Excel who can reconfigure fields in a spreadsheet of 36,000 entries using a formula (not manually). The list is currently sorted to have an entry with a name, school and then subject. An individual may have multiple subjects that they have completed below their name and school from a separate entry. If they do multiple subjects, I would the subject to be featured in the next field of an entry....For ease of explaining, I have provided a sample of the work. I have added additional comments in some of the fields in the spreadsheet for clarification. Are you able to complete this?

    $85 (Avg Bid)
    $85 Avg Bid
    71 bids

    To extract data from a website for my academic research paper

    $12 / hr (Avg Bid)
    $12 / hr Avg Bid
    75 bids
    Wordpress Custom Table 6 days left

    We need a custom table created that has input drawn from an excel spreadsheet (this can be adapted to an online plugin). The graphics are created (see attached) and will sit behind with the numbers overlaid. There are 2 views, one is a mobile view and the second is a desktop view, both have the same information.

    $400 (Avg Bid)
    $400 Avg Bid
    148 bids

    Greetings of the day! I have a project related to AI basic application, the function of this applicationis to read basic large number of PDF files (academic articles) and extract same data from them into table (Automated PDF Data Extraction). this table is basecally 15 - 20 columns. example...the study, country of the study, theories used in the study, summary of the findings.....etc. One of the outcomes will be the confidence level of the extracted data (from 0% to 100%). Also, as some of the trained data might not be highly accurate, I need to have the option of re-train the application in various dataset in future so i can add more column or delete them if i needed. *attached is excel screenshot for the expected data extraction and sample of the PDF files Time frame 1 t...

    $115 (Avg Bid)
    $115 Avg Bid
    12 bids

    Top excel macros Community Articles