Vba exel projectงาน

Project Title: Comprehensive Excel KPI Dashboard for 20 Power Plants (12-Month Data) Project Description: I am looking for an experienced Excel expert to design and build an advanced KPI dashboard to monitor and analyze the performance of 20 power plants over a 12-month period. The dashboard should be capable of handling large datasets and provide clear, intuitive visualizations and summaries for easy analysis. Requirements: Data Structure: The dashboard should accommodate data for 20 power plants (including both gas and steam turbines) and cover performance metrics for each month over a 12-month period. Organize the data efficiently to enable quick updates and filtering for specific plants or months. Dashboard Components: KPIs Summary Section: Monthly and annual summaries fo...

I need an app for a farming business that documents work done by each employee by assigning a tag/wristband to them that they can tap each time an activity is done. The tag/wristband must be easily bought on Temu/Takealot. The home page must contain : Date, Field no (Drop down list), Type of task (Drop d...task by the foreman. Every step must be time stamped. A sound must sound when the tag was read correctly. The app must be able to work remotely and sync when getting signal/data again. Report : Must be ready per task opened and closed by foreman. It should show number of units done/harvested per employee. Information must be accessed at any time on a remote desktop and must be able to export to exel. As this task must be performed by very low skilled people the design should be ve...

I'm in need of an Excel report designed to track sales performance. The Excel sheet includes columns such as Dealer Type, Region, Account Owner, Account Name, Financial Category, and monthly data from January to December. Dealer Types include Direct, Independent, Government, Branch, and Joint Venture. Each Account Owner can be associated with one or more Dealer Types. For instance, the Account Owner "ABC" may have Dealer Types "Direct" and "Government," while "XYZ" could have all five Dealer Types (Direct, Independent, Government, Branch, and Joint Venture). The report's goal is to aggregate data based on the Account Owner's Dealer Type. Specifically, it involves reading the financial data (e.g., January to December values) for each ...

I need an Excel VBA script that can interface with the Pushbullet API. This script should allow me to send both text messages and images (specifically photos) through Pushbullet, all from within Excel. Ideal Skills and Experience: - Proficient in Excel VBA - Familiar with API integration, specifically Pushbullet - Experience with multimedia messaging Please note, I don't need any special features for handling photos, such as automatic resizing or photo compression. The purpose of this project is strictly to enable both text and photo sending via Pushbullet through Excel. and I do have a excell sheet that does everything so just need to modify and allow me to add images in the text

I need a VBA expert to create a script that extracts data from and organizes it into Excel. Key requirements: - The script should visit the 'Upcoming Fixtures and Results' page and for each completed match, extract data from the 'Final Results' table. - The specific data points to be collected are goals scored by each team, possession percentages, total shots on target, and xG. - Data should be organized with one match per row. - The script should automatically update the Excel sheet with new data daily. Ideal skills and experience: - Proficient in VBA programming. - Experience with web scraping. - Familiarity with Excel. - Understanding of football statistics will be a plus.

I'm seeking a skilled VBA developer with experience in SAP automation. My current scripts handle executing specific transactions, but I need assistance with: - Automating the login process with credentials - Handling input into the username and password prompt popup boxes I have SAP S/4 Hana, SAP GUI7.70 and Microsoft 365.

Create a VBA script that extracts all available data from emails and calendar events in Outlook desktop and stores it in a local MySQL database. The script must efficiently handle email and calendar data, ensure all records are logged, and provide the ability to call its core functions with custom parameters. Requirements Overview 1. Data Sources: o Emails: Extract all available data from each email, including metadata like date/time, subject, body, sender, and recipients. o Calendar Events: Extract all available data from each calendar event, including recurring events that need to be treated as individual instances. 2. Time Storage: o All date/time fields must be converted to and stored in UTC. o Attachments do not need to be saved. 3. Database Schema: o All data must be stored...

I have an excel file that needs some modifications, primarily using a Pivot Table. The main purpose of the project is to analyze data, create reports, and summarize information. file imports all files in a folder via data query (this is already done) but we need to pass a path to teh query that user selects (selection done, passing to query not done) then add sorting and minor to the pivot) pls look at the main file, i will send data files to you when you start. its 2 hours +- if you know data connections and pivots well.

I need a skilled Excel programmer to create a comprehensive billing software for our V-Belts an...measurement. For instance, a belt priced at 1.5 Rs/inch for section A and 2 Rs/inch for section B. - It needs to accommodate different per-inch rates for each client. - The ability to generate detailed invoices is a must. - The software must automatically calculate and apply relevant taxes based on the customer's location and tax status. Ideal Skills: - Advanced proficiency in Excel, including VBA and complex formula usage. - Previous experience in developing billing or inventory software. - Good understanding of manufacturing processes, specifically in the context of V-Belts and Fan Belts. I look forward to receiving your bids. Please include client-specific reports in the repo...

I need a custom Excel sheet that fetches financial data from a specific API (URL and port will be provided) and summarizes it in an...be provided) and summarizes it in an accessible format. The raw data should be stored in a hidden sheet, while the summary is displayed in the main view. Key Requirements: - Use of VBA programming for custom functionality - Integration with a financial API - Creation of table-based forms within Excel that allow for dynamic row/column addition via a custom button - Implementation of various data validation checks (data type, range, custom logic) - Use of dropdowns and other Excel features for data input in the forms Please include examples of your previous Excel customizations with your proposal. Exact project scope will be provided to quali...

I require expert assistance with MS Excel, specifically for maintaining confidentia...columns in the spreadsheet to maintain confidentiality - Implementing data encryption techniques to protect confidential information - Creating summary reports to present analyzed financial data - Automating data processing tasks using Excel macros and VBA Ideal Skills: - Proficient in MS Excel with a strong understanding of data analysis techniques - Experience working with financial data - Attention to detail and ability to maintain confidentiality - Able to execute specific instructions to hide data Please note, the primary aim of this project is to ensure confidentiality while working with sensitive financial data. The Excel file should be encrypted to ensure the highest level of data...

...proyecto está orientado a la contratación de una persona que pueda proporcionar asistencia cada vez que se necesite, especialmente en: Creación y optimización de fórmulas avanzadas en Excel. Automatización de procesos mediante macros y VBA. Diseño de hojas de cálculo personalizadas y funcionales. Análisis de datos y generación de reportes complejos según requerimientos específicos. Requisitos: Experiencia Avanzada en Excel: Debe tener habilidades avanzadas en Excel, incluyendo conocimientos profundos en fórmulas, tablas dinámicas, macros y programación en VBA. Disponibilidad Flexible: Necesito que el candidato esté disponible para asistir durante el horario de E...

I would create dynamic flow chart and gantt kind of chart using vba which would update according the data updated in the reference sheet.

I'm seeking an Excel VBA expert to automate my data entry tasks. This project primarily involves compiling data from multiple files into a single spreadsheet. The data source is strictly Excel, and the destination is also Excel. A TEST TASK MAY BE GIVEN TO YOU. Only bid if you have work in excel VBA. Key Requirements: - Proficient in Excel and VBA - Experienced in automating data entry tasks - Able to compile data from different files - Familiar with Excel to Excel data manipulation Ideal Skills and Experience: - Strong understanding of Excel’s functionalities - Previous experience with similar data compilation tasks - Excellent attention to detail - Ability to meet deadlines

I need an Excel 365 VBA script that fetches, extracts, or web-scrapes minute-by-minute chart data (Time, Open, High, Low, Close, Volume) from a chart. The data extraction needs to start at 4:00 PM on the previous trading day and continue up to 3:59 PM of the current trading day for each minute displayed on the chart. Pre-market, during open market, and after market. The script needs to: ·        Log each minute's data in real time, maintaining a continuous and orderly sequence of entries. ·        Store the data in a structured format (e.g., a column or table). ·        Fetch data from a specified URL associated with my TradingView data ...

I'm seeking an expert proficient in Web Excel to assist me in creating a system that timestamps when a row is modified and logs the username in a new column. This needs to be accomplished without utilizing VBA, as our team exclusively operates on Web Excel. Ideally, we would employ Excel Scripts for this task. Key Requirements: - The system should be adaptable to both existing and new spreadsheets. - It should operate within the OneDrive cloud storage platform, where our Web Excel files are located. - The system needs to trigger automatically upon any change made to the spreadsheet. Ideal Skills: - Expertise in Web Excel and Excel Scripts. - Experience with cloud storage, specifically OneDrive. - Proficiency in creating automated tracking systems within spreadsheets.

I require expert assistance with MS Excel, specifically for maintaining confidentia...columns in the spreadsheet to maintain confidentiality - Implementing data encryption techniques to protect confidential information - Creating summary reports to present analyzed financial data - Automating data processing tasks using Excel macros and VBA Ideal Skills: - Proficient in MS Excel with a strong understanding of data analysis techniques - Experience working with financial data - Attention to detail and ability to maintain confidentiality - Able to execute specific instructions to hide data Please note, the primary aim of this project is to ensure confidentiality while working with sensitive financial data. The Excel file should be encrypted to ensure the highest level of data...

I am looking for a skilled Excel/VBA developer to build a tool that replicates the core functionality of an old program I use. This tool should primarily focus on data analysis and calculations, specifically comparison analysis. Key Requirements: - Proficient in Excel and VBA - Experience in building automated tools for data analysis - Ability to understand and replicate the functions of existing software The tool should facilitate: - Data analysis and calculations - Comparison of different sets of data Please note, we will not be comparing different datasets from the same period or data from different departments. Instead, the primary focus will be on comparing historical data vs. current data. I am open to suggestions on how to best implement this tool, and I am looki...

I'm in need of an experienced Excel macro coder who can help me automate some of my repetitive tasks, specifically around data analysis. Key Responsibilities: - Develop a macro in Microsoft Excel that automates my data analysis tasks. Ideal Skills and Experience: - Proficiency in Microsoft Excel, particularly with creating and implementing macros. - Prior experience in automating tasks in Ex...Microsoft Excel that automates my data analysis tasks. Ideal Skills and Experience: - Proficiency in Microsoft Excel, particularly with creating and implementing macros. - Prior experience in automating tasks in Excel. - Strong understanding of data analysis techniques. - Ability to work independently and deliver high-quality work on time. - Deep understanding of Visual Basic for Application...

I'm in need of an experienced Excel macro coder who can help me automate some of my repetitive tasks, specifically around data analysis. Key Responsibilities: - Develop a macro in Microsoft Excel that automates my data analysis tasks. Ideal Skills and Experience: - Proficiency in Microsoft Excel, particularly with creating and implementing macros. - Prior experience in automating tasks in Ex...Microsoft Excel that automates my data analysis tasks. Ideal Skills and Experience: - Proficiency in Microsoft Excel, particularly with creating and implementing macros. - Prior experience in automating tasks in Excel. - Strong understanding of data analysis techniques. - Ability to work independently and deliver high-quality work on time. - Deep understanding of Visual Basic for Application...

I'm in need of an Excel template designed to handle traffic flow data, specifically tracking various types of vehicles. I require a skilled coder who can create a VBA/Excel macro to automate the creation of this template based on my specifications. Key Requirements: - Crafting a macro/VB code to create the Excel template - Working with traffic flow data pertaining to different vehicle types - Implementing functionality for data summarization - Presenting summarized data in tables Ideal Skills & Experience: - Proficient in Excel and VBA programming - Previous experience with data-heavy Excel templates - Understanding of traffic flow data is a plus - Excellent attention to detail and ability to follow specific requirements

...player to think and engage with the subject matter. Dynamic Interaction Feature: The wheel should be able to spin and stop randomly, displaying specific content (question or activity) for each section. Special Feature: Once a section is selected and completed, it should be hidden or disabled to prevent repetition in subsequent spins. This can be achieved using PowerPoint’s interactive animations or VBA coding (for designers experienced in PowerPoint programming). Full Customization: The game should be designed so that users can easily edit the questions or tasks for each section directly within PowerPoint without requiring advanced technical skills. Provide a simple and flexible interface, allowing users to tailor the wheel’s content to fit different lesson ...

I'm seeking an Excel VBA expert to automate my data entry tasks. This project primarily involves compiling data from multiple files into a single spreadsheet. The data source is strictly Excel, and the destination is also Excel. A TEST TASK MAY BE GIVEN TO YOU. Only bid if you have work in excel VBA. Key Requirements: - Proficient in Excel and VBA - Experienced in automating data entry tasks - Able to compile data from different files - Familiar with Excel to Excel data manipulation Ideal Skills and Experience: - Strong understanding of Excel’s functionalities - Previous experience with similar data compilation tasks - Excellent attention to detail - Ability to meet deadlines

I'm in need of a diligent professional to assist with data cleaning and validation. The data in question is a mix of text and numbers, so attention to detail and accuracy is paramount. Ideal Skills and Experience: - Proven experience in data cleaning and validation - Proficient in handling mixed data (text and numbers) - Exceptional attention to detail - Strong manual typing skills - Previous experience in data entry

I'm looking for a skilled Excel professional, particularly proficient in VBA, to help me link two Excel sheets. These sheets have the same structure and contain mixed data (text and numbers). The task involves counting entries marked "Completed" in the first sheet to update the second sheet. Key responsibilities include: - Developing a VBA script to automate the counting and updating process. - Ensuring the script runs efficiently and correctly across the entire data set. The ideal freelancer for this job should have: - Extensive experience with Excel and VBA. - Strong attention to detail to ensure accurate data linkage. - Ability to deliver the project in a timely manner.

I need help modifying an existing Skyline Chart in VBA. The main task involves changing data ranges in the chart. Ideal Skills: - Advanced knowledge of VBA - Proficiency in handling Skyline Charts - Experience in modifying charts based on changing data Please only bid if you have the relevant experience and can demonstrate your ability to deliver quickly and efficiently.

I'm looking for a skilled Excel professional, particularly proficient in VBA, to help me link two Excel sheets. These sheets have the same structure and contain mixed data (text and numbers). The task involves counting entries marked "Completed" in the first sheet to update the second sheet. Key responsibilities include: - Developing a VBA script to automate the counting and updating process. - Ensuring the script runs efficiently and correctly across the entire data set. The ideal freelancer for this job should have: - Extensive experience with Excel and VBA. - Strong attention to detail to ensure accurate data linkage. - Ability to deliver the project in a timely manner.

I'm looking for a skilled Excel professional, particularly proficient in VBA, to help me link two Excel sheets. These sheets have the same structure and contain mixed data (text and numbers). The task involves counting entries marked "Completed" in the first sheet to update the second sheet. Key responsibilities include: - Developing a VBA script to automate the counting and updating process. - Ensuring the script runs efficiently and correctly across the entire data set. The ideal freelancer for this job should have: - Extensive experience with Excel and VBA. - Strong attention to detail to ensure accurate data linkage. - Ability to deliver the project in a timely manner.

...have a to-do list PowerApp created which has the following functionality. I think this could be pretty widely useful, so feel free to utilize it as you see fit afterward. Reasons for a PowerApp: while still intended for personal use (no broad deployment), it still needs to to function on both desktop and mobile devices within a work environment that exclusively uses the Microsoft suite. While a VBA macro enabled Excel file could achieve much of this functionality for desktop use, the macros would not be compatible with the iOS version of Excel. **Main Function** * The main screen of the PowerApp should display a Microsoft list which contains to-do items. * The user should be able to decide which columns of the list are displayed. * I’m thinking this would be a combo b...

Hi Gaurav, I need your support in fixing an issue I have caused in the solution you completed last week. I have removed one of the columns in the "Combined Calc" and added a new column...... Now all the tables "BCDIJ" have no rows as the column names / position have changed.

I'm seeking an Excel expert to enhance my salon shop's revenue and shares calculation sheet. The focus is on correcting formula inaccuracies and upgrading data visualization components. Key tasks include: - Improving accuracy of formulas to ensure reliable calculations. - Enhancing data visualization with more intuitive charts, graphs, and Pivot tables. - Utilizing conditional f...transparency and fairness. The ideal freelancer would be someone with: - Strong expertise in Excel, particularly in using and creating complex formulas. - Proven experience in data visualization, making use of charts, graphs, and Pivot tables. - Skills in conditional formatting to highlight significant data points. I look forward to your proposals. No need for automation features such as macros or...

I'm seeking an Excel programmer who can create a tool for me to download 5 years of historical data from Y...ASX stocks. Key Requirements: - The data should be downloaded in daily increments. - Whenever new data is being fetched, the old data should be erased and overwritten. - All data should be saved in a worksheet labelled "rawdata" within the workbook. - The tool should allow for manual input of stock codes in a designated cell. Ideal Skills and Experience: - Proficient in Excel programming and VBA. - Familiarity with Yahoo Finance's data structure. - Previous experience in creating similar data extraction tools will be highly regarded. Please note, I do not require any additional data processing or calculations post download. The primary focus is on the...

I need an experienced VBA developer to update my web scraper. The project involves extracting specific match details from a soccer fixtures website and enhancing the overall performance of the scraper. Key Requirements: - Update data extraction methods to capture important match details such as dates and times - Optimize the performance of the web scraper to ensure it runs smoothly and efficiently Ideal Skills: - Extensive experience with VBA coding - Proven track record in web scraping - Strong understanding of soccer fixtures and match details

Review and fix the VBA code in existing Excel file

Excel VBA Macro to extract data from the website dynamically

I'm looking for a proficient Excel VBA expert to help me automate some tasks. This project primarily involves: - Automating the generation of financial reports on a monthly basis. - Setting up email notifications to be sent out with these reports. Ideal candidates will have significant experience in automating tasks, particularly in Excel VBA, and have a good understanding of financial report generation. Please provide examples of similar tasks you have completed in the past.

...the table mentioned above by assuming that the hypergeometric distribution represents the observed values and the binomial distribution represents the expected values. Show that the result strongly depends on the sample size used for the test. Interpret these results, also with reference to the bar charts. To submit: A written report on the topic, including graphics and tables. An Excel program (VBA is welcome) covering all the steps mentioned above. A Mathematica program for all the steps mentioned above....

We're looking for a developer to automate our shipping label creation using EasyPost API from Excel and update tracking information in Shopify. We manage orders in Excel and want a streamlined way to generate labels and send tracking data back to Shopify without manual steps. Project Requirements: Shipping Label Creation via EasyPost API: Develop a macro/function in Excel to create shipping labels using EasyPost API based on order data in the spreadsheet. Customizable label fields: order number, recipient, address, package type, and quantity. Labels should ideally open in the same tab or print directly without additional tabs. Validate data to avoid formatting errors. Shopify API Integration for Tracking Updates: Automatically update tracking info in Shopify by using the Sh...

Adjust VBA code in existing Excel workbook

I'm looking for a proficient Excel VBA expert to help me automate some tasks. This project primarily involves: - Automating the generation of financial reports on a monthly basis. - Setting up email notifications to be sent out with these reports. Ideal candidates will have significant experience in automating tasks, particularly in Excel VBA, and have a good understanding of financial report generation. Please provide examples of similar tasks you have completed in the past.

I need an automation solution for sampling from a mixed-data Excel file. The sample size should be random, based on specific conditional criteria. Ideal freelancer should have: - Strong proficiency in Excel and Macros - Experience with data sampling - Ability to create automation scripts in Excel (VBA or similar)

We are seeking a proficient developer with expertise in Excel and VBA/Macro development to create an automated system capable of fetching ISIN and SEDOL codes for investment funds directly within Excel. The system should handle partial fund names and manage variations due to different share classes, ensuring that all possible ISIN/SEDOL codes for each fund name are retrieved and populated in the spreadsheet. The goal is to automate the retrieval process to enhance our investment operations while eliminating the need for external platforms and maintenance fees.

I'm in need of a Google Sheets and App Script expert or VBA who can assist me in automating some tasks. Specifically, this project involves automating the generation of reports and sending out email notifications on a monthly basis. Ideal Skills: - Proficiency in Google Sheets and App Script/ Excel VBA - Experience in task automation - Knowledge in report generation and email notifications setup. Please provide examples of similar tasks you have completed in the past.

I'm looking for an expert in Excel, particularly skilled in using macros and VBA scripting, to create an automated Excel sheet for tracking room occupancy at an event. Key Requirements: - The sheet should calculate the per day room nights occupied from the total inventory and a retention list. - When I enter a guest's name, check-in and check-out dates, it should automatically calculate and show the occupied rooms and the pending rooms available. - It should generate a daily room occupancy report. - No email notifications are needed. Ideal Skills and Experience: - Advanced Excel skills, particularly in using macros and VBA scripting. - Experience in creating similar automated Excel sheets. - Ability to create clear and concise daily reports from the data.

Hi Gaurav, I have some additional enhancement work for the VBA table manipulation solution you completed for me a few months ago. The existing Power Query needs to be updated to have multiple select criteria from the main data sheet and an additional Power Query created to also filter on a 3rd parameter. This is explained in design doc provided. Thanks, Steve.

I'm looking for an experienced VBA programmer to write a query that checks whether values of parameter2 are within a specific range, in relation to parameter1. The query should apply an outlier removal technique (either Z-score, IQR, or Modified Z-score) that is easiest to handle the data. Key Requirements: - Write a VBA query to assess parameter2 values against parameter1. - Use one of the outlier removal techniques: Z-score, IQR, or Modified Z-score. - The output data must match the data present in the "Data sheet". - Deliver the results in an Excel sheet. In this project, you do not have to consider missing or incomplete data; it can be assumed that all data is complete. Ideal candidates should: - Be proficient in VBA programming. - Have ex...

I'm looking for an expert in Excel VBA who can help me automate my price comparison Excel sheet. This will be used for comparing prices from PDF quotes we receive from suppliers, which contain tables. Key tasks include: - Automating the process of extracting data from PDF quotes and aligning it in Excel for comparison - Implementing a system for price comparison that reflects my current manual process Ideal skills and experience: - Proficient in Excel VBA - Experience with data extraction from PDF - Able to understand and replicate manual comparison process in an automated system This project should significantly reduce the time I spend on price comparison while increasing accuracy.

Looking for Excel VBA expert to construct easy to use Excel spreadsheet that automates engineering calculations. The ideal freelancer for this project should very proficient in Excel VBA, macros with experience in automating mathematical calculations/formulas in Excel. Key Requirements: - Proficient in Excel VBA - Strong understanding of intermediate mathematics - Experience in automating mathematical calculations & formulas in Excel

I need assistance to convert 3 Excel documents (two are attached and third to follow) that are currently functional on a Windows laptop to be compatible ...are currently functional on a Windows laptop to be compatible with a Mac. These documents are essential for data entry and processing, and they contain VBA coding. The primary requirements of this project include: - Ensuring all existing VBA coding continues to operate seamlessly on Mac Excel - Retaining all functionalities associated with data entry and processing The Excel documents do not use any external data sources or connections, simplifying the task. The ideal freelancer for this project should have: - Expertise in Excel and VBA - Experience with cross-platform Excel compatibility - A Mac av...

I'm looking for a skilled VBA developer who can write a script for Excel that will copy cells from specific ranges based on their color. Requirements: - The script should identify and copy cells of custom colors that I will specify. - It should be able to copy cells from specific ranges, not entire rows or columns. Ideal skills for this project include: - Proficiency in Excel and VBA programming. - Experience with writing scripts for Excel. - Ability to understand and implement custom requirements. Please provide examples of similar projects you've completed in your proposal.