Vba exel project jobs
I'm looking for a skilled professional with extensive experience in VBA and macros to assist with data manipulation on my Excel sheets. Your primary tasks will include sorting and filtering data, as well as combining and merging sheets. Ideal Skills and Experience: - Proficient in Excel, VBA, and macros - Strong data manipulation skills - Experience with sorting, filtering, and merging data in Excel - Ability to automate repetitive tasks to improve efficiency - Proficient in using and creating advanced Excel formulas - Experience in error handling and debugging VBA code - Ability to manage and work with dynamic data ranges - Experience in integrating Excel with external APIs - Proficiency in creating and customizing pivot tables - Strong skills in cleaning and p...
...Excel VBA professional to create a macro that can assist in handling scientific data from an analytical instrument. When we analyze a sample, we got a list of retention time (in minute) and data are associated with each retention time (name, %ID, value of area). 1 retention time = 1 molecule. From one sample to another one, the retention times can slightly differ but they both correspond to the same molecule (for example sample 1, retention time = 6.432min and for sample 2 = 6.438min). I need a macro to group all retention time that are close one with each other among different samples (we can use a constant value to define the range). For each group, I need to list the associated values for each sample. Raw data are in an Excel file. Key Responsibilities: - Develop an Exce...
I hope this message finds you well. I am writing to express my interest in providing MS Office and data entry services for your project. With [X years] of experience in using MS Office applications and performing data entry tasks, I am confident in my ability to meet your needs efficiently and with attention to detail. Services Offered: MS Office Services: Data management and analysis using Excel (formulas, pivot tables, data sorting, and graphs) Document creation and formatting in Word (professional reports, templates, and presentations) PowerPoint presentations design and editing Excel spreadsheet automation (using macros, VBA, and custom functions) Data Entry Services: Accurate and fast data entry into various platforms (Excel, Word, Google Sheets, etc.) Web scraping and ...
Description: We are looking for an experienced freelancer to help us design and implement a complete workflow for a testing process. Our requirements are as follows: Project Overview: Create Fillable PDF: Develop a secure, password-protected fillable PDF form. Include text fields, checkboxes, and radio buttons for answers. Enable users to save and submit their responses. This fillable pdf is a test, with around 100 Questions - Fields, MCQ, Drop down menu etc... Automate Data Collection: Collect completed PDFs via email or a shared cloud location (e.g., OneDrive). Extract the form data into a structured format. Data Processing in Excel: Transfer the extracted data into a prebuilt Excel template with predefined fields. ...
I hope this message finds you well. I am writing to express my interest in providing MS Office and data entry services for your project. With [X years] of experience in using MS Office applications and performing data entry tasks, I am confident in my ability to meet your needs efficiently and with attention to detail. Services Offered: MS Office Services: Data management and analysis using Excel (formulas, pivot tables, data sorting, and graphs) Document creation and formatting in Word (professional reports, templates, and presentations) PowerPoint presentations design and editing Excel spreadsheet automation (using macros, VBA, and custom functions) Data Entry Services: Accurate and fast data entry into various platforms (Excel, Word, Google Sheets, etc.) Web scraping and ...
I'm looking for an experienced VBA programmer to enhance my existing sports web scraper. This tool needs to be updated to collect odds from the correct score market for soccer fixtures on reputable betting websites, specifically William Hill and Ladbrokes. Key Requirements: - Modify the current web scraper to extract specific data from the correct score market. - Capture and distribute odds data into an Excel table. - Enhance web scraper to handle dynamically loaded content on betting websites. - Implement robust error handling and logging mechanisms. Ideal Skills: - Proficiency in VBA for web scraping. - Familiarity with soccer betting markets. - Experience in data distribution to Excel. Please note, the primary focus of this project is on capturing odds.
I'm in need of an Excel and VBA specialist who can create a formula for me. This formula should enable my Excel to send automatic emails through Outlook when specific cell values change. Key Requirements: - Expertise in Excel and VBA programming. - Experience with Outlook email automation. - Ability to understand and implement specific project requirements. The automatic email should include any comments or notes that I specify. Please only apply if you have relevant experience and can deliver quality work in a timely manner. Thanks!
Hi there - I've delivered the work as we have discussed. Thanks for your work again!!
I'm in need of an Excel expert who can create a VBA solution that enhances my Excel for project management purposes. Specifically, I need this solution to help generate custom reports. Ideal Skills and Experience: - Proficiency in Excel and VBA - Experience with project management tools - Ability to create custom Excel features - Prior experience generating custom reports in Excel - Strong problem-solving skills
...(pie charts). Key Responsibilities: - Develop an Excel form that updates circle graphs in real-time based on data input. - Implement specific calculations and formulas including sum and average, percentage growth, and trend analysis. Ideal Skills: - Extensive experience with Excel and its programming capabilities (VBA, macros). - Ability to create dynamic, interactive forms. - Strong understanding of sales data and relevant analytical techniques. The deadline for this project is December 1st. Please refer to the attached Excel file for detailed information. The data input should be done through a custom form interface. The Excel form should feature colorful charts. The Excel form should be designed to update circle graphs daily based on data input. The Excel form will...
I'm looking for a freelancer skilled in Excel VBA for a project. - The primary tasks will be creating scripts to automate processes within Excel. The ideal candidate for this project should have a strong background in developing advanced Excel VBA scripts and a proven ability to handle complex algorithmic challenges. Experience in data analysis and creating custom functions within Excel will be highly beneficial.
I'm looking for an Excel Macro expert to create an automated solution. The task is to convert Amazon's monthly sales reports into a specific Excel format ready for Tally accounting software.
I'm looking for an Excel VBA expert who can create a basic data summary form for me. Key Responsibilities: - Develop simple VBA code that links to a data summary form - Ensure the form can summarize a list of data points - Create a reusable form template for future data summarization tasks Ideal Skills: - Proficiency in Excel and Excel VBA - Experience in creating user-friendly data summary forms - Strong coding skills for simple VBA code development Please note, this project is focused on summarizing a list of data points. Freelancer with experience in creating such forms will be preferred. If you can meet the budget for a simple download - stand alone program then that is fine as well. Please do not request to go above these types, as the ser...
I need help refining my existing VBA code in Excel. The code is used to search for specific key words in longer text strings in one workbook, and to find corresponding terms in another workbook. It should return certain values if found. The main goal of this project is twofold: - Improve search accuracy - Enhance processing efficiency, given the large size of the database I prefer the use of a dictionary-based search for speeding up the process. there are 250,000 rows of data to search in one of the spreadsheets, so efficient logic required to minimize processing. Ideal skills for this project include: - Extensive experience with Excel VBA - Proficiency in implementing dictionary-based search methods - Strong understanding of search accuracy improvement tech...
...Key Skills: Accurate and efficient data entry with attention to detail. Expertise in Excel functionalities including Pivot Tables, VLOOKUP, Macros, and Conditional Formatting. Data cleaning, validation, and transformation to improve data usability. Creating detailed and actionable reports for informed decision-making. Streamlining processes by automating repetitive tasks using Excel formulas and VBA. Maintaining organized, error-free data records to support business operations. Strengths: Ability to handle large datasets while maintaining precision and meeting tight deadlines. Strong problem-solving skills to identify and resolve data inconsistencies. Collaborative and adaptable, ensuring smooth coordination with cross-functional teams. Looking for opportunities to leverage my ...
I need assistance with a VBA script that will delete the contents of a Google Sheets file and replace it with text data from a specified tab in an Excel sheet. Key Requirements: - The data to be transferred consists solely of text, which includes hyperlinks. - It is not necessary to maintain any specific formatting from the Excel sheet, so the focus should solely be on the accurate transfer of the content. Ideal Skills: - Proficiency in VBA - Experience with Google Sheets and Excel - Ability to create efficient data transfer scripts I'm looking for a professional who can provide a clean, working solution to this problem. The script should be triggered manually by the user.
I need an Excel add-in that can populate numbers from a raw data CSV file into multiple financial models (Profit & Loss Statement, Balance Sheet, and Cash Flow Statement) in a specified manner. Ideal Skills and Experience: - Proficient in Excel and VBA programming for creating add-ins - Experience with financial modeling - Familiar with CSV data handling - Strong problem-solving skills to understand and implement the required data mapping - Attention to detail to ensure accuracy in data population
I'm seeking a skilled developer with expertise in VBA and experience with Jade Database systems. Key Requirements: - Create VBA code that will copy data from Excel and paste it into corresponding fields in a Jade Database system. - The code needs to identify and match fields in the database with the data in Excel accurately. Ideal Skills: - Proficiency in VBA programming. - Prior experience working with Jade Database systems. - Strong knowledge of data matching techniques and database interactions. - Excellent problem-solving skills to troubleshoot any potential issues. Please provide examples of similar projects you've completed in your proposal.
Excel template report for generating Chart by VBA
I need a more efficient solution to my current cost ledger in Excel, which currently uses a dynamic dropdown box and an indirect formula. The current setup is slow and needs to be replaced with a faster, scalable solution that doesn't require VBA.
I'm looking for an experienced VBA and SQL professional to automate my daily data transfer from Excel to SQL Database. The purpose of this project is to enable comprehensive data manipulation to create tables and combine data. Key Responsibilities: - Automate the daily transfer of data from Excel to SQL using VBA and SQL queries. -Create Tables in SQL using query in Excel VBA - Perform data cleaning and transformation to ensure data quality. - Merge multiple tables seamlessly. - Aggregate data for summary tables. Ideal Skills and Experience: - Proficiency in Excel VBA and SQL. - Experience with data cleaning, transformation and manipulation. - Ability to merge and aggregate data from multiple tables. - Previous experience with automating data tran...
I'm seeking a VBA specialist to develop custom Excel files with macros to streamline my task automation needs. Key requirements: - Automation of data processing tasks using VBA macros - Implementation of data transformation and summary calculations within the Excel files Ideal candidates will have a strong background in: - VBA programming - Excel - Data analysis and processing The end goal is to significantly enhance my efficiency through automation. Note that proficiency in creating user-friendly, intuitive Excel interfaces is a plus. See requirements document in link
I'm looking for a software developer to create a program that speaks predefined questions and records user responses via voice input into an Excel sheet. The program needs to run on Windows, and ideally, it would be developed in Excel VBA, but Python is also acceptable. The software will need to ask between 1-5 questions. Ideal skills and experience for the job: - Proficient in Excel VBA and/or Python - Experience with voice recognition software - Knowledge in programming for Windows - Ability to create user-friendly software
...collaboration, applying version control, and formatting documents for both print and digital distribution. MS Excel: With MS Excel, I have developed and maintained complex spreadsheets for data analysis, reporting, and financial modeling. My expertise includes creating and managing pivot tables, applying advanced formulas (VLOOKUP, INDEX-MATCH, IF statements), and automating tasks with macros and VBA programming. I have also worked on creating dashboards and visualizations using Excel's charting and data analysis tools, enabling stakeholders to make data-driven decisions. MS Office Projects: In addition to my proficiency in individual applications, I have worked on multiple projects that integrate the various tools within the MS Office suite. For example, I have prepared c...
I'm in need of a freelancer with specialist skills in Excel VBA (or Excel Macro) and Excel Power Query. The goal is to fully automate a resource planning functionality in Excel. Key Requirements: - Automation of WBS structures in the summary page to manage start and end dates of projects, as well as the minimum and maximum dates based on WBS levels - Calculation of minimum and maximum utilization over a specified time period - Automation of reporting features to generate weekly or monthly summaries of project statuses and resource utilization I have an existing semi-automated template, but I need someone to fully automate it and streamline the Excel file, making it less bloated. Ideal Skills: - Proficient in Excel VBA and Excel Power Query - Experience with r...
...YouTube, social media, and professional use. Add transitions, special effects, and audio enhancements. Create promotional videos, ads, and cinematic edits. Optimize videos for different platforms to meet format requirements. Provide a quick turnaround while ensuring high quality. Excel and Data Analysis Create dynamic and visually appealing Excel dashboards. Automate tasks with Excel formulas, VBA macros, and scripts. Analyze data to generate meaningful insights and reports. Clean and organize large datasets efficiently. Build customized templates for financial modeling, tracking, and reporting. Assist in solving Excel-related challenges and teach advanced techniques. Feel free to contact me for a personalized solution to your needs!...
I need a single Access SQL query that calculates the total credits...- Proficiency in Microsoft Access - Strong SQL skills - Experience in data analysis and visualization - Ability to create adjustable queries Please note, the table contains all information related to the students' credits. I am looking for a freelancer who can deliver this project promptly and efficiently. I will provide an access db with only the relevant table and data for only the relevant fields and only a subset of records (eg. 5000). The actual table has 1.3 million records so efficiency is a requirement. A vba script that calls one or more sql queries is also fine. I have more needs if this works out. As in multiple additional queries. If it is not costly. This one is the most complex. T...
...create a comprehensive set of Excel tutorials, ranging from beginner to expert level. The tutorials should be recorded using screen capture (no voice-over required). This project is ideal for someone who has an in-depth understanding of Excel and can present the content in a clear, organized, and visually engaging way. Requirements: Content Scope: Tutorials should cover all levels: Beginner, Intermediate, Advanced, and Expert. The course should be divided into 6 to 8 main topics, with multiple subtopics under each. Examples of main topics: Excel Basics, Formulas & Functions, Data Visualization, Pivot Tables, Macros & VBA, and Advanced Analytics. Include practical examples and step-by-step demonstrations for each concept. Recording Specifications: ...
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 have this VBA that working well: Sub ImportDataFromExcel() Dim wb As Workbook Dim ws As Worksheet Dim filePath As String Dim openFile As Variant Dim vendorTemp As Worksheet Dim articlesSheet As Worksheet Dim magSitoSheet As Worksheet Dim pianoProdSheet As Worksheet Dim newWorkbook As Workbook Dim lastRow As Long Dim lastRowMagSito As Long Dim lastRowPianoProd As Long Dim i As Long, j As Long Dim searchValue As String Dim found As Boolean Dim saveFilePath As Variant Dim todayDate As String Dim uniqueCodes As Collection Dim tempWorkbook As Workbook Dim tempSheet As Worksheet Dim saveFolder As String Dim codeValue As Variant ' Usare Variant per For Each loop Dim tempRow As Long ...
I need a VBA script that can edit link sin word and transfer data from Excel to a Word document. The project involves: - Updating file and range links in word charts (linked to excel). - Pushing text from Excel to Word. -These are defined in a control panel config sheet within excel (attached) Ideal Skills and Experience: - Proficient in VBA programming - Experienced in Excel and Word integration - Attention to detail and good communication skills This stage 1 (of 4) will take a dev used to working with office object model (word charts, bookmarks etc) 8-10 hours Pls no placeholders, look at spec, review docs, make a real bid. see control panel and brief as primary doc. thanks
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...
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...
