Vba exel projectKazi
Stage 1: Add columns and readjust VBA code
I have to connect a fairly old application and read from a postgresql database with certificates in SSL mode. I need assistance.
I'm looking for a skilled professional to help me automate an Excel spreadsheet that tracks government legislative bills. Data Requirements: - The Excel spreadsheet should update automatically with data about the legislative bills from a speci...Legislature's bills has been included for reference. - The spreadsheet should be structured to clearly display the different pieces of information and specifically update only for the bills that I select for tracking. A mechanism to easily select bills to include in the automatic update. An example of an Excel spreadsheet has been provided as an example. Ideal Skills: - Proficiency in Excel and VBA (Visual Basic for Applications). - Experience with data scraping or web automation tools. - Understanding of legislative processes ...
I'm looking for a low-cost system that connects my WhatsApp to an Excel spreadsheet. The system should be compatible with my existing macros and Python scripts. Key Requirements: - Th...Excel spreadsheet. The system should be compatible with my existing macros and Python scripts. Key Requirements: - The system should only send text based messages via WhatsApp. - The triggering of WhatsApp messages from Excel should occur at scheduled times. - Both my Excel VBA macros and Python scripts need to be compatible with this new system. Ideal Skills: - Proficiency in Python and Excel VBA - Experience in creating cost-effective automation systems - Familiarity with WhatsApp API or similar services This project is purely for personal use. Please ensure that the system...
Hi , i need someone to help me create a mail from an excel button and figure out some formulas in an excel report. Key Skills : 1. Familiar with outlook 2. In-depth understanding of Excel formulas and functions for complex calculations. 3. Advanced VBA Programming to write macros and automate repetitive tasks.
Create a Word document linked to populated Access tables. The project involves inserting data via bookmarks & VBA into a Word Template document that outputs a new Word report. This output report should have no bookmarks or VBA while maintaining the required table and text formatting & styles.
Proposal for Inventory Data Specialist for Excel Management Project Overview: As per the need of experienced Inventory Data Specialist proficient in Excel to manage, optimize, and analyze inventory data. The role involves organizing and maintaining inventory records, creating automated reports, and developing advanced Excel-based tools to improve accuracy and efficiency in inventory tracking. Scope of Work: Data Management: Maintain and update inventory records, ensuring data integrity. Advanced Excel Reporting: Develop and implement complex formulas, pivot tables, and dashboards to track stock levels, turnover rates, and trends. Automation: Automate routine tasks using Excel VBA (macros) to reduce manual effort and improve efficiency. Forecasting & Analysis: Assist in...
I have an Excel sheet that requires a VBA solution. The specific tasks that need automation include: - Data entry - Data analysis - Report generation Given the complex nature of the workbook, I need an expert with a strong background in data handling and VBA programming to streamline my Excel workflow. Skills and experience ideal for this job include: - Proficient in Excel and VBA - Extensive experience in automating Excel tasks - Strong background in data analysis - Previous experience with complex Excel workbooks
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 ...
Buongiorno, trattasi di uno sviluppo di excel per fornire anche un grafico di gunt. Ora io vorrei inplementarlo con un time tracker. Il codice vba è stato protetto chiaramente per vendere il prodotto, ma con un file contenete un apposito codice si slocca. Allego il file obiettivo, il file per sboccare il vba e un file che ho trovato di time tracker. Vorrei inserirlo nel file obbiettivo. Il time tracker deve includere sezioni di pausa, commenti delle sessioni di lavoro e riepiloghi giornalieri.
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.
Buongiorno, trattasi di uno sviluppo di excel per fornire anche un grafico di gunt. Ora io vorrei inplementarlo con un time tracker. Il codice vba è stato protetto chiaramente per vendere il prodotto, ma con un file contenete un apposito codice si slocca. Allego il file obiettivo, il file per sboccare il vba e un file che ho trovato di time tracker. Vorrei inserirlo nel file obbiettivo.
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
...dirección, etc que se asocie a esa cuenta de correo-e. Crear CSV para importar los contactos a la libreta de direcciones/contactos de Outlook. En Youtube, encontré este video, y logré que funcionara, siguiendo sus instrucciones, para el caso que él plantea. Lo que me pasa, es que yo tengo otros requerimientos y no se hacerlo, porque yo no programo en VBA...
Tafadhali Jisajili ama Ingia ili kuona maelezo.
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
