Vba exel projectproiecte

Înregistrează-te sau Conectează-te pentru a vedea detaliile.

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.

J ai besoin de l aide pour le développement Saisie sur un user form du détail des facture pour alimenter une base afin de créer des tableaux

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!...

Tengo varios Excel que quiero unir en uno. Cada Excel va unido a un Grafico y lo único que quiero es tener un grafico y siete hojas y cada vez que quiera ver los graficos de una hoja cargarlos.

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...

...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