Filter

My recent searches
Filter by:
Budget
to
to
to
Skills
Languages
    Job State
    292 jobs found, pricing in USD
    VBA Excel Template Macro -- 6 6 days left
    VERIFIED

    Please read and bid exactly what you would like for this project, no time for negotiations We would like to revise the attached template to use for future reports: 1. Using the column A "Student_Number" from the first sheet labeled "Data" 2. date of the assessment (column W) from the "SR sheet" for the first assessment of the client by date to be listed in column i 3. scaled score (column Z) from the "SR sheet" for the first assessment of the client by date to be listed in J 4. we want the GradeEquivalent (column AD) from the "SR sheet" for the first assessment of the client by date to be listed in K 5. date of the assessment that is the last score by date, no matter how many assessments have been taken (column W) from the "SR sheet" for the last score by date of assessment of the client by date to be listed in column L 6. scaled score (column Z) from the "SR sheet" for the last score by date assessment of the client by date to be listed in M 7. GradeEquivalent (column AD) from the "SR sheet" for the last score assessment of the client by date to be listed in N Then... 1. Using the column A "Student_Number" from the first sheet labeled "Data" 2. date of the assessment (column W) from the "SM sheet" for the first assessment of the client by date to be listed in column O 3. scaled score (column Z) from the "SM sheet" for the first assessment of the client by date to be listed in P 4. we want the GradeEquivalent (column AC) from the "SM sheet" for the first assessment of the client by date to be listed in Q 5. date of the assessment for the last score by date after the first assessment, no matter how many assessments have been taken (column W) from the "SR sheet" for the last score assessment of the client by date to be listed in column R 6. scaled score (column Z) from the "SM sheet" for the last score assessment by date of the client by date to be listed in S 7. GradeEquivalent (column AC) from the "SM sheet" for the highest score assessment of the client by date to be listed in T

    $41 (Avg Bid)
    $41 Avg Bid
    10 bids

    Revise machine shop scheduling tool to track total quantity scheduled, made, and remaining for machines 1-19. The worksheet should automatically calculate the number of parts produced on the 'Template' Worksheet. As you can see, the machine shop supervisor adds the number of parts produced in the far right column, and it calculates a percentage at the bottom. The problem is that the number at the bottom considers all parts produced, even if they exceeded the production schedule. I need the total number at the bottom to only reflect what is on the original published schedule, and not overruns or other parts. I would still like to track these, but the program should not use them in the total calculation at the bottom. I need this to be added to the template that is created each time the schedule is "Locked and published". I would like Columns I,J,K to be part of the template when it is created They should only be able to enter the quantity made in column K. I and J should come from the schedule Correction. Made (column K) should track the column made as they enter the daily quantities complete through the week And the quantity in column K can never exceed the quantity in column I For Example, Machine 1 over built 119% for the week This causes the percent complete at the bottom to be higher than it should.

    $169 (Avg Bid)
    $169 Avg Bid
    4 bids

    Im working on a project that has a lot of excel calcualtions , sheets and formulas. I need to automate the process to make it a little more user friendly. I have some basic knowledge of VBA but am havign trouble figuring out the best way to streamline my project.

    $107 (Avg Bid)
    $107 Avg Bid
    30 bids

    I have Excel hotel meetings game created in .xls format (around 2006) and it now doesn't run, throwing up a runtime error everytime I open it in Excel 2016 on a Mac and PC. I need a VBA expert to review the macro's and VBA code and fix the game so it runs on both Mac and PC on in the latest versions of Excel.

    $154 (Avg Bid)
    $154 Avg Bid
    42 bids
    Automatize process 5 days left
    VERIFIED

    I need to automatize the execution of a XLS proyect. I have 3 files, 01, 02 and 03. In the ejecution of 02 I have to select an option to execute the calculation(I have 2 ways to make the calculate), the location file 01 by explorer, and the location file 03(give the route to the file). I think in an solution (Doc N4) Who insert the route to the file 01 and 03 in a Cell, and the route of 02 in a cell, and ejecute automaticly without interact with the user. The other request is this have to be dinamic, If I have 4 homes, each one have his file 01, 02, 03, and in one button i could ejecute all the process(Ejecute the 02 file in each home) secuencially. I Upload the files, and I can give an example of the N4 format to Only reduce the job to the programation of the web, no design.

    $38 (Avg Bid)
    $38 Avg Bid
    14 bids
    VB Expert for Excel work! 5 days left
    VERIFIED

    I have 2 separate Excel sheets, I need VB expert to populate data from one sheet to another sheet in form of drop down and auto populated format, it won't take more than 1 hour for an expert. apply only if you are expert.

    $18 (Avg Bid)
    $18 Avg Bid
    13 bids

    I NEED A PROGRAMMER IN EXCEL TO MAKE ME A PRODUCTION REPORT DAILY PRODUCTION, WEEKLY, MONTHLY ANALYSIS ETC.

    $113 (Avg Bid)
    Local
    $113 Avg Bid
    7 bids
    Trophy icon Correlation Tool 4 days left

    Hello everyone! The goal of this contest is to develop a tool/code that will be able to calculate the correlation between different time series and create a table with the results. In the excel file attached you will find the input DataBase, how the correlation is calculated and the format of the result table. Please feel free to use the coding language that you would prefer. Thank you for participating!

    $10 (Avg Bid)
    Guaranteed
    $10 Avg Bid
    3 entries

    I have a fIle that contains all my Sent Emails combined with Agenda. The files tells also the 1st and Last action of the day that could be an Email or Agenda event The goal was to define time worked every day starting with a sent Email or Meeting and ending the same way. I would like to convert the file into a calendar compatible file with Google agenda or Outlook. The fill will contain the whole Agenda and the 1st and last email of the day if it's the 1st or last action.

    $151 (Avg Bid)
    $151 Avg Bid
    16 bids

    I need a VBA expert for my current projects. If you have knowledge please bid. Details will be shared in message with the freelancers. Only one hour project.

    $8 / hr (Avg Bid)
    $8 / hr Avg Bid
    5 bids

    Why is copying worksheets running so slowly

    $124 (Avg Bid)
    $124 Avg Bid
    23 bids

    I am a design engineer working in Oil and Gas construction industry. I am working on a personal project where i have an excel sheet (call it input sheet) with 4 columns and several rows (not fixed). I need a program which on click can sort out rows in desired order (based on a key word in second column e.g. 'Design', Test', 'Material' etc. and desired format. Results shall be in new excel sheet (call it output sheet). Output sheet shall have a desired format with headlines for each group of rows (e.g. 'design' 'Test' 'Material' etc). Number of rows in input sheet are variables. Basically, input sheet is a data base which keep getting updated and output sheet is the communication log to be used in a project. Program shall be able to filter out duplicate rows within input sheet.

    $360 (Avg Bid)
    $360 Avg Bid
    55 bids
    Excel file improvement 4 days left
    VERIFIED

    I have developed an excel file to help managers enter budgets then for it to upload into our system. There is some conditional formatting and some Macros that do this. I want to make the file more efficient (Without losing too much functionality) to run faster and be smaller to email out.

    $15 / hr (Avg Bid)
    $15 / hr Avg Bid
    37 bids

    Requirements: -Excel expert who is preferably familiar with Excel-based Palisades DecisionTools [login to view URL] or similar risk analysis software -background or qualifications in risk analysis -ability to consistently produce and deliver high quality work Job is to update/input latest data into a risk decision analysis model (prepared using Palisades DecisionTools which is Excel-based) If you fulfill requirements above, please send: (a) CV (b) your best indicative price quote for about 8 hours of data update/ input. Budget is maximum $80

    $38 (Avg Bid)
    $38 Avg Bid
    8 bids

    Requirements: -Excel expert who is preferably familiar with Excel-based Palisades DecisionTools [login to view URL] or similar risk analysis software -background or qualifications in risk analysis -ability to consistently produce and deliver high quality work Job is to update/input latest data into a risk decision analysis model (prepared using Palisades DecisionTools which is Excel-based) If you fulfill requirements above, please send: (a) CV (b) your best indicative price quote for about 8 hours of data update/ input. Budget is maximum $80

    $122 (Avg Bid)
    $122 Avg Bid
    15 bids

    Automating equipment tracking, preventative and predictive maintenance tracking activities. Develop schedule that updates needed maintenance each time spreadsheet is opened. Reset maintenance schedule each time activities are completed. One click daily and weekly work assignments based on preset maintenance schedules. One click reports.

    $145 (Avg Bid)
    NDA
    $145 Avg Bid
    14 bids
    Trophy icon Fill Blanks 3 days left

    Hello Everyone, The goal of the contest is to develop a tool or a code which will be able to fill blank spaces with the true value. I am including an Excel file with two worksheets. On Worksheet 1 you will find the report that should be fixed. On Worksheet 2 you will find the table where you should look for the ID Number (Column H) of the row and find the true value for the column that is blank (highlighted in yellow in worksheet 1). *Please be aware that the code should be able to identify the blank spaces and only replace those cells with the correct value, as the other cells which are not blank may not be the same and should not be replaced. Thank you for participating! Cristobal

    $10 (Avg Bid)
    Guaranteed
    $10 Avg Bid
    11 entries

    I need a customized excel sheet where I can assign tasks to other staff with email tagging option, with email response creation for everyone tagged and a CC / BCC column. There should also be Current status column reflecting the status of tasks in percentage and colors. There will be assigned and due dates as well and in case of overdue, an automatic email will be sent to all the parties mentioned in the assignee, CC, BCC columns and myself. I need a comprehensive dashboard view of the status of tasks on a weekly, monthly and yearly basis. Column-1: Request# | Column-2: Request | Column-3: Requester | Column-4: Assigned To | Column-5: Action/Progress | Column-6: Start Date | Column-7: Due Date | Column-8: Charts and Dashboards. During Allocation a task row will be shown green but one day before due date it will change to Blue and after Due date it will turn into RED.

    $202 (Avg Bid)
    $202 Avg Bid
    25 bids
    Design a form using VBA 3 days left
    VERIFIED

    Hi... We would like to design a front end user form using the existing excel sheet. We have done all the formulae and calculations. You must able to convert this set of info using vba and design the form. Its manufacturing parts assembly form. Data will be shared during our discussion.

    $52 (Avg Bid)
    $52 Avg Bid
    59 bids

    I have a Python script which basically runs an Excel macro, but it is giving me a Runtime Error 1004. the macro basically refreshes Bloomberg formulas in the sheet. The macro runs fine within Excel but gives the above error when calling from Python.

    $22 (Avg Bid)
    $22 Avg Bid
    18 bids

    Background: We have approximately 60 separate excel files that contain approximately 50 tabs each. Each tab contains the same columns but different row data. Some files contain similar row data but not identical. The data relates to retail locations and the price of a product on a given date. Each tab on the file is a different state within the USA. The Desire/Intended Outcome: • Have a place/tab that calculates the past trend data for each row, on each tab, to allow us to see the median and mean price that was offered for this product, at each ‘location’ over the history of our data. Have the same data calculate the median and mean pricing over the most recent 12 weeks of data, the most recent 26 weeks of data, and the most recent 52 weeks of data. • Add data each week when new pricing comes out, and have that data ‘recalculate’ the mean and median pricing trend as listed above. Some simple method to paste or merge files to allow the new data to be imported into the master spreadsheet that contains the calculations and graphs. • Have a line graph that shows the past 12 months of pricing data for any location, by clicking that location from a drop down to allow for the line graph to be displayed, and then printed. • A version that allows us to print on one page the 12,26, and 52 week data trends for any one location. All of this should be done in Excel, not in another program. We should be able to drop in/paste in the latest weeks data to allow for the data to update A sample version of one of the 60 spreadsheet files is attached. Please see all of the tabs on the sample file.

    $194 (Avg Bid)
    $194 Avg Bid
    43 bids

    I have a process that needs be built using workfusion

    $717 (Avg Bid)
    $717 Avg Bid
    8 bids

    Hello, I Need to copy data from pdf to excel using macro. Pdf have some data including image form which need to be copied in excel . More details will be given to selected freelancer. Happy bidding. Thanks

    $17 (Avg Bid)
    $17 Avg Bid
    69 bids
    Mind Map-2 7h left

    Design a complex mind map for me using a particular software. Assume any marketing case and design a mind map.

    $8 / hr (Avg Bid)
    $8 / hr Avg Bid
    5 bids

    I need a Excel Macros expert for my current project. If you have knowledge please bid. Details will be shared in message with the selected freelancers.

    $31 (Avg Bid)
    $31 Avg Bid
    40 bids
    Project for Jake S. Ended
    VERIFIED

    Hi Jake S, We currently have a betfair bot that scraps [login to view URL] and looks for price movements before triggering a bet on Betfair. We are looking to extend this to read off TAB, Crownbet and place bets with other Corporates.

    $2788 (Avg Bid)
    $2788 Avg Bid
    7 bids

    There is data on which around 3 to 4 rules need to be applied using excel macros

    $26 / hr (Avg Bid)
    $26 / hr Avg Bid
    40 bids

    Convert a vba code to excel

    $67 (Avg Bid)
    $67 Avg Bid
    28 bids

    Build a multi-users (login password for each) software dedicated to market intelligence analysis. Forms to fill database, easily updatable. Aggregated view(market) and detailed view (1 competitor)

    $58 (Avg Bid)
    $58 Avg Bid
    1 bids

    Build a multi-users (login password for each) software dedicated to market intelligence analysis. Forms to fill database, easily updatable. Aggregated view(market) and detailed view (1 competitor)

    $231 (Avg Bid)
    $231 Avg Bid
    6 bids

    Hello, I'm searching for someone that can made for me an simple excel tool that runs an import job based on this api info [login to view URL] It must check every x min. If there is an bid higher then the one I have did on an specific advertising. When this is happening the tool must create an new higher bid where there are an few parameters like max bid amount and the steps the tool can use. Questions let me know it.

    $65 (Avg Bid)
    $65 Avg Bid
    14 bids

    Details of the project; 1-Everyday, Daily all matches we have in history must be transferred to excel. (Example = 09.05.2018) 2-All matches transferred to Excel must include the following conditions. a- Opening and closing rates of the first half of the matches. b- Bookmaker only Bet365 c- Get daily data with VBA. d- The picture of the sample excel format and website has been added to the announcement.

    $365 (Avg Bid)
    $365 Avg Bid
    15 bids

    Boa noite, gostaria de uma planilha bem trabalhada que atenda minha necessidade de forma rápida e inteligente. Registrar semanalmente os times, como também qual banco pagou, a quem pagou, qual a data do pagamento e no final um balanço financeiro de quanto foi recebido em cada banco.

    $102 (Avg Bid)
    $102 Avg Bid
    21 bids

    Our contact info (name, email, personalization data...) is in a Worksheet in Excel. We want to be able to click on a row, have VBA create a personalized email body, Stop and let us check the email and maybe add additional personalizaton, then Send. Then, track an open, click thrus to various links, forwards...

    $178 (Avg Bid)
    $178 Avg Bid
    22 bids

    i have xls wanted it open in excel file with groups and with sub totals and with design

    $20 (Avg Bid)
    $20 Avg Bid
    2 bids

    We have a environmental program that is based on an excel spread sheet. Its called an Environmental Management System which is a process including assessments, planning and checklists etc... The tool is not about 5 years old and looks very dated and unprofessional. We are looking for a talented innovative person to come to terms with how the process works and to improve the flow and efficiency for the user as well as making it look much more professional. We have a budget of about $500 to get this done but it it works out well we would also be looking for a more extensive review and improvement (possibly using a different platform). Do you experience in using excel to create user friendly and professional looking processes??? Also are you available to spend about 4 x half days to work with us on this

    $362 (Avg Bid)
    $362 Avg Bid
    44 bids
    EXCELL EXPERT Ended
    VERIFIED

    We have a data base in a spreadsheet in an excel file. We would need a program-app-formula that allow us to write a new data in our smartphone and update it automatically in that spreadsheet. Can you help?

    $28 (Avg Bid)
    $28 Avg Bid
    21 bids

    vba code causing memory leakage...program causes Excel to crash.

    $122 (Avg Bid)
    $122 Avg Bid
    40 bids

    I have a database that I use for my business and need help automating several aspects of this spreadsheet.

    $378 (Avg Bid)
    $378 Avg Bid
    59 bids
    Dashboard Re design Ended
    VERIFIED

    Freelancer should re-design the dashboard to make it more dynamic and easy to control

    $113 (Avg Bid)
    $113 Avg Bid
    33 bids

    Hi, I have an excel file I want to use advanced auto filter in it. If you can do it using VBA. It will be grate. Thank you.

    $4 / hr (Avg Bid)
    $4 / hr Avg Bid
    32 bids

    I need a Excel Macros expert for my current project. If you have knowledge please bid. Details will be shared in message with the selected freelancers.

    $45 (Avg Bid)
    $45 Avg Bid
    47 bids

    I need a Excel Macros expert for my current project. If you have knowledge please bid. Details will be shared in message with the selected freelancers.

    $23 (Avg Bid)
    $23 Avg Bid
    17 bids

    Hi I want the person who is good in excel tutoring and make good videos for excel and VBA. Before awarding atleast one sample is required. More details in message Only $2 per hour is the budget if you bid over than that you will not be selected we need 100 or more than that videos need to be created.

    $2 / hr (Avg Bid)
    $2 / hr Avg Bid
    5 bids

    I need to be able to use your excel VBA, or SQL, or other methods, to download any information about stocks that I want on the stock exchange. You need to create a solution that allows me to do so at a click of the mouse, whenever I want. I am not a programmer so you might know other better ways to do it. Please message me with details of how you intend to do so. I prefer it to be like a website that allows me to choose the fields I want to download.

    $30 (Avg Bid)
    $30 Avg Bid
    9 bids

    We are a company that provide design, fit out, refurbishment and furniture services for businesses and schools. ([login to view URL]) We need someone to build our quotation template in Excel into a cleaner and faster tool that we can use for producing quotes as efficiently as possible. Our quotes are very varied and very complex in construction. I would like to discuss in much more detail with interested freelancers. Prepared to pay good money for a smart, flexible and willing freelancer.

    $1669 (Avg Bid)
    $1669 Avg Bid
    29 bids

    I wish to provide aspiring and experienced models a platform to showcase their talent in print shoots, catalogues/magazine modelling, short films, web series etc.

    $250 - $750
    $250 - $750
    0 bids

    I need to be able to download all metrics possible from stocks exchange market at any time I want, so that I can do my own filtering. So you will need to write some VBA / queries / API that allow me to do so, by just running your macro / query / program. I’m not a programmer so my understanding of the requirement may not be the best way to do it. In any case, let me know only if you can create something that can support such a request. To prove your understanding and capability, please message me to show me a sample of the market that you have managed to download using your method. Cheers

    $40 (Avg Bid)
    $40 Avg Bid
    8 bids

    I want a macro that can be used to restrict each cell to only two lines of text and each line not exceeding a certain number of characters that can be specified for each selected group of cells. The macro should not allow the user to exceed those parameters during editing of the cell (as opposed to alerting the user after the fact).

    $29 (Avg Bid)
    $29 Avg Bid
    5 bids

    I want a macro that can be used to restrict each cell to only two lines of text and each line not exceeding a certain number of characters that can be specified for each selected group of cells. The macro should not allow the user to exceed those parameters during editing of the cell (as opposed to alerting the user after the fact).

    $33 (Avg Bid)
    $33 Avg Bid
    7 bids