Vba exel projectKazi
I'm looking for a VBA expert who can help me with data analysis and reporting using Excel. The main focus will be on data visualization. The ideal freelancer should be able to: - Automate tasks in Excel using VBA - Create custom functions or tools tailored to my data analysis needs - Design and implement effective data visualizations The data will primarily be sourced from Excel spreadsheets. Previous experience with data visualization in Excel is crucial, as is a strong understanding of VBA. It is a secret code game for family fun, not for resale. I will provide 11 lines of letters maximum 400 in each line. Lines 1 to 11. I need a dialogue box with. A multiplier selection box whereby I can put in a number from 1-400 coinciding with the letter in each cell fo...
Tôi muốn thiết lập 1 bảng lãi suất tham chiếu theo lãi suất có sẵn, theo công thức của bên tôi. Nhờ các bạn lập giúp tôi và dạy tôi cách lập.
I need a VBA expert to create a Word/VBA/macro which turns selections in a Word document into dynamic hyperlinks. Background - Valid links start wit-h [aA] followed by numeral's A1683123/ A1686786 A916753 A916753 more text A916753 more text - VBA convert a to A - Anchor:=r1, Address:= _ "url:objective://id:" + RTrim() + "@", SubAddress _ :="", ScreenTip:="", TextToDisplay:=RTrim() - The issue is, in word, sometimes double clicking "A916753" will select "A916753 ". The hyperlink cannot contain the space. The hyperlink and display text, must only contain the valid text "A916753". Below is code that doesn't really work: Dim r1 As Range Dim str1 As String Dim ...
I need a skilled Excel VBA programmer to enhance my current Excel workbook with new macros. The primary aim of these macros is to automate data entry tasks, specifically dealing with text data. Your responsibilities will include: - Modifying existing macros or creating new ones to facilitate the automation of data entry - Ensuring the macros can handle various forms of text data effectively Ideal candidates should have: - Proficient experience in Excel and VBA programming - Previous experience in creating or modifying macros for data entry purposes - Excellent understanding of handling text data within Excel Please provide examples of similar projects you've worked on, and your approach to tackling this task.
...promptly. - Knowledge of advanced Excel techniques and functions. - Understanding of data security and confidentiality. - Experience with similar data cleaning projects. - Accuracy in data entry to ensure all updates are correctly made. - Available references or a portfolio showcasing previous work. - Proficiency in VBA for automating repetitive tasks in Excel. - Ability to incorporate feedback and make iterative improvements. The Excel file contains between 1,000 to 10,000 rows. The project should be completed within 1 week. Perform data normalization to ensure consistency across the dataset. Phone numbers should be standardized to a consistent format. Please provide a report of the removed numbers for my records. Ensure that all phone numbers are standardized to E.164...
necesito obtener datos a diferentes hojas de excel desde la base de datos en msql de mi pagina web, tengo avances que funcionan hasta cierto punto, necesitan ajustes para lograr lo esperado.
Description: I need VBA and Excel automation expertise to integrate a new productivity KPI into an existing report. The POS vs. Opportunity report already contains automated VBA scripts and formulas, so this task requires enhancing the functionality without disrupting the existing structure. Project Overview: Integrate a Productivity KPI: Track registrations completed per team member and calculate registrations per hour. Data Source: Supervisors maintain a separate daily registrations report (Excel). Goal: Combine this KPI seamlessly into the current POS vs. Opportunity sheet. Requirements: Add columns for Registrations Completed, Hours Worked, and the calculated Productivity (Reg/hr). Maintain the current VBA automation and ensure no int...
I'm seeking an Excel professional to update an old worksheet. The task involves: - Adju...Optimizing existing formulas to improve performance - Generating visualization charts for better data representation - Automating routine tasks using VBA or macros - Updating cell formatting for consistency and readability - Linking to external data sources for real-time updates Ideal candidates should possess: - Proficient Excel skills - Experience with custom formulas - Strong data entry and correction abilities The task should be quick for an expert. The new data entries will be provided by me. Please include bar and line charts for the data visualizations. Include automation or macro integration as part of the updates. The deadline for this project is "no deadline."...
I'm in need of a skilled programmer who can create an Excel VBA plug-in for me. The primary function of this plug-in will be to detect user actions within Excel and display selected messages on the top corner of the screen. Ideal skills and experience for the job include: - Proficiency in Excel VBA programming - Experience in developing Excel plug-ins - Knowledge of creating and linking macros to buttons Please only apply if you can deliver a high-quality, efficient solution.
I'm in need of a macro for Outlook that can facilitate the downloading of attachments from a selected batch of emails. Key Requirements: - Manual selection by the user to determine which emails to download from. - Post-download, the emails should...can facilitate the downloading of attachments from a selected batch of emails. Key Requirements: - Manual selection by the user to determine which emails to download from. - Post-download, the emails should be moved to a specific folder. - All file types from the email attachments should be downloaded. Ideal Skills and Experience: - Proficiency in creating macros for Outlook. - Familiarity with VBA (Visual Basic for Applications). - Previous experience with email automation tasks. - Attention to detail to ensure all attachments ...
I need a VBA script that can extract specific data from my Outlook emails into an Excel spreadsheet. The data to be extracted includes the sender, subject, received date, received time, whether it's a new or follow-up mail, and if it's a follow-up, when the first revert on that mail was and when the last received mail was. Key Requirements: - The script should filter emails based on a specified date range. - The script should be able to extract data from both new and follow-up emails. Ideal Skills: - Proficiency in VBA programming. - Experience with Outlook automation. - Strong understanding of Excel. Please provide examples of similar projects you've completed in your proposal. The script should be run on a daily basis. The extracted data should be appende...
...promptly. - Knowledge of advanced Excel techniques and functions. - Understanding of data security and confidentiality. - Experience with similar data cleaning projects. - Accuracy in data entry to ensure all updates are correctly made. - Available references or a portfolio showcasing previous work. - Proficiency in VBA for automating repetitive tasks in Excel. - Ability to incorporate feedback and make iterative improvements. The Excel file contains between 1,000 to 10,000 rows. The project should be completed within 1 week. Perform data normalization to ensure consistency across the dataset. Phone numbers should be standardized to a consistent format. Please provide a report of the removed numbers for my records. Ensure that all phone numbers are standardized to E.164...
...promptly. - Knowledge of advanced Excel techniques and functions. - Understanding of data security and confidentiality. - Experience with similar data cleaning projects. - Accuracy in data entry to ensure all updates are correctly made. - Available references or a portfolio showcasing previous work. - Proficiency in VBA for automating repetitive tasks in Excel. - Ability to incorporate feedback and make iterative improvements. The Excel file contains between 1,000 to 10,000 rows. The project should be completed within 1 week. Perform data normalization to ensure consistency across the dataset. Phone numbers should be standardized to a consistent format. Please provide a report of the removed numbers for my records. Ensure that all phone numbers are standardized to E.164...
...promptly. - Knowledge of advanced Excel techniques and functions. - Understanding of data security and confidentiality. - Experience with similar data cleaning projects. - Accuracy in data entry to ensure all updates are correctly made. - Available references or a portfolio showcasing previous work. - Proficiency in VBA for automating repetitive tasks in Excel. - Ability to incorporate feedback and make iterative improvements. The Excel file contains between 1,000 to 10,000 rows. The project should be completed within 1 week. Perform data normalization to ensure consistency across the dataset. Phone numbers should be standardized to a consistent format. Please provide a report of the removed numbers for my records. Ensure that all phone numbers are standardized to E.164...
...professional with extensive experience in Excel and VBA programming to create two specific macros in my Excel 365 file. Task 1: - The first macro needs to process data by removing all spaces and special characters, while also converting all letters to lower case. It’s crucial that this macro retains leading zeros. For instance, the value '075 667 854' should be reformatted as '075667854'. - Furthermore, this data needs to be formatted as text. Task 2: - The second macro should identify numbers that appear in more than one cell in column A. - These repeated numbers should be placed in column B, with numbers that occur more than once being separated by a comma and a space. Ideal candidates for this project should have: - Proficiency in Excel ...
I'm looking for a seasoned Excel developer to create a macro that can sort and filter mixed data (both numeric and text) effectively. The macro should be able to fetch data from another spreadsheet. Ideal Skills: - Proficient in Excel VBA - Experience with data sorting and filtering - Ability to create efficient macros for repetitive tasks Definition: I have an Excel spreadsheet with Columns A-C, which can be seen in the Example.png. In the current format, the part level doesn't exist, so I created and colorized Columns J-M manually to show my need. But I want a macro to do this format automaticity
...promptly. - Knowledge of advanced Excel techniques and functions. - Understanding of data security and confidentiality. - Experience with similar data cleaning projects. - Accuracy in data entry to ensure all updates are correctly made. - Available references or a portfolio showcasing previous work. - Proficiency in VBA for automating repetitive tasks in Excel. - Ability to incorporate feedback and make iterative improvements. The Excel file contains between 1,000 to 10,000 rows. The project should be completed within 1 week. Perform data normalization to ensure consistency across the dataset. Phone numbers should be standardized to a consistent format. Please provide a report of the removed numbers for my records. Ensure that all phone numbers are standardized to E.164...
...with extracting production data from a plain text email into a custom structured Excel file. The ideal freelancer for this project should have: - Proficiency in Excel - Attention to detail - Experience with data extraction and organization. - Experience with scripting languages like Python or VBA. Please ensure you can work to a custom structure before bidding. The data volume is small and manageable. The Excel file needs to be updated with new data from emails weekly. The emails containing production data will be from an Outlook account. The data extraction process should be fully automated to update the Excel file weekly. The preferred method for automation is a VBA macro. The Excel file requires special formatting for certain fields. Special formatting include...
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.
...source for this project will be our cash flow data. - Calculations: I need the cash flow data to be analyzed in terms of comparing actual figures against our budgeted amounts. - Final Report: The completed report should be presented in an Excel sheet. Ideal candidates for this project should have: - Extensive experience working with complex Excel data - A strong understanding of BOQ and contract data - Excellent skills in financial data comparison - Ability to deliver a clear, comprehensive Excel report. - Proficiency in advanced Excel functions such as VLOOKUP, HLOOKUP, and INDEX MATCH. - Ability to clean and prepare data for analysis, ensuring accuracy and consistency. - Experience using pivot tables for dynamic data presentation and analysis. - Knowledge of macros and ...
I'm looking for an Excel expert to create a macro that helps me update my Bill of Quantities (BOQ) using an old list of glass panels. The goal is to efficiently identify and compare reusable materials. Specific Tasks: - The macro should identify reusable glass panels. - It should compare entries f...Tasks: - The macro should identify reusable glass panels. - It should compare entries from the old and new BOQ. - Finally, it should generate a report detailing usable materials. Report Structure: - The output report should be structured in an Excel spreadsheet. Data Format: - The old glass panels list is currently stored in an Excel spreadsheet. Ideal Skills: - Proficient in Excel macros and VBA. - Experienced in data comparison and reporting. - Able to deliver a well-structure...
I'm in need of an Excel developer who can help me automate repetitive tasks using macros. Ideal Skills: - Proficient in Excel, especially in creating and implementing macros - Strong problem-solving skills - Attention to detail - Previous experience with Excel automation - Advanced knowledge of VBA programming - Experience in data analysis with Excel - Ability to create and manage user forms - Skills in creating charts and graphs for data visualization - Proficiency in implementing error handling in macros - Experience integrating Excel with other software - Skills in optimizing macro performance - Ability to create macros for batch processing tasks Please note, the specific repetitive tasks to be automated are yet to be determined, so flexibility and a broad understanding o...
I'm looking for an Excel VBA expert to help me automate the process of populating a new sheet from an existing one. This project will focus on generating reports based on production data. Key Requirements: - Proficiency in Excel VBA - Experience in data handling and report creation - Familiarity with production data is a plus The existing sheet contains specific data fields that I want to include in the report. The new sheet will be used for report generation. Please note that the ideal candidate should be able to work with a pre-defined set of data fields.
I'm looking for an Excel expert to develop a production tracking spreadsheet. This will involve tracking specific Key Performance Indicators (KPIs) and automating data transfer to other spreadsheets using VBA. Key aspects of the project include: - Tracking KPIs: The spreadsheet should monitor production volume, as well as production and revenue per square foot by each harvest cycle. - Creating a Gantt Chart: A calendar or Gantt chart to visualize the production timeline is also required. Ideal skills and experience for this job: - Advanced Microsoft Excel skills, particularly with VBA and macros. - Experience in creating tracking spreadsheets. - Ability to create visual aids such as Gantt charts. Please provide a brief overview of similar projects you've ...
Create a VBA in excel to export an organization's structure from Excel to PowerPoint. Propose your template or format in Excel. Export aditional fields in excel to powerpoint as shown in the example attached. The presentation can follow a generic minimalistic style.
I'm looking for an Excel VBA whisperer to help enhance my productivity. Key Tasks: - Creating custom functions in Excel to meet specific needs - Automating data entry and clean-up tasks - Streamlining the process of importing and exporting data from/to CSV and Excel files - Debugging and resolving issues in existing VBA code Ideal Skills: - Proficient in Excel and VBA programming - Experience with creating custom Excel functions - Strong understanding of data entry and clean-up processes - Familiarity with CSV/Excel file handling
I'm looking for a skilled VBA expert to help me automate data entry and manipulation in Excel. Key tasks include: - Sorting and filtering data - Data validation and cleaning - Merging and consolidating datasets Please note that I will be running the VBA code manually, so it does not need to run automatically based on certain triggers. Ideal candidates should have: - Strong knowledge and experience in VBA and Excel - Proven track record in automating data entry and manipulation tasks - Excellent problem-solving skills - Attention to detail Please include examples of similar projects you've completed in your bid.
Tafadhali Jisajili ama Ingia ili kuona maelezo.
...(Advanced Reconcilition, not a basic bank recon) Key Requirements: - Proficient in accounting principles and practices. - Advanced Excel skills with experience in creating macros. - Able to complete the project within a 7-day timeframe. - Experience with VBA programming for advanced Excel macro creation. - High attention to detail to ensure accuracy in reconciliation. - Knowledge of data security best practices to safeguard sensitive financial information. - Proven track record of successful bank reconciliations. - Strong analytical skills to identify and resolve discrepancies. Task Details: - The project will primarily be executed in Excel. - I need the macros to specifically automate the bank reconciliation process. - The reconciliation report should be detailed...
I'm in need of an expertly built Excel file. This file should be able to track 100+ sea vessels and monitor various operational aspects. Key Data Points to Track: - Fuel consumption - Diesel usage - Cargo - Operation time ...consumption - Diesel usage - Cargo - Operation time - Castoff time - Distance traveled by the vessel per trip Primary Purpose: The main objective of this Excel file is to monitor the vessels' operations and maintain KPI tracking for castoff times. Operational Aspects to Monitor: - Loading - Offloading Ideal Skills and Experience: - Advanced Excel skills (including functions, charts, and possibly VBA) - Experience with logistics or sea operations - Ability to understand and incorporate KPI tracking - Attention to detail to ensure all data points ar...
...payroll, and preparing financial statements like P&L and Balance Sheets. Key Responsibilities: - Automate the creation of books of accounts, General Ledgers, Trial Balance, and P&L - Develop macros for Excel to streamline these tasks - Automate data entry, transaction categorization, and report generation in the books of accounts Ideal Skills and Experience: - Proficient in Microsoft Excel and VBA for macro development - Strong background in accounting - Experience in automating tasks in Excel - Ability to create user-friendly automated systems - Proficiency in advanced Excel functions like VLOOKUP, INDEX, and MATCH. - Experience in data analytics and visualization tools within Excel. - Certifications such as CPA or ACCA that demonstrate a strong understanding of accoun...
...payroll, and preparing financial statements like P&L and Balance Sheets. Key Responsibilities: - Automate the creation of books of accounts, General Ledgers, Trial Balance, and P&L - Develop macros for Excel to streamline these tasks - Automate data entry, transaction categorization, and report generation in the books of accounts Ideal Skills and Experience: - Proficient in Microsoft Excel and VBA for macro development - Strong background in accounting - Experience in automating tasks in Excel - Ability to create user-friendly automated systems - Proficiency in advanced Excel functions like VLOOKUP, INDEX, and MATCH. - Experience in data analytics and visualization tools within Excel. - Certifications such as CPA or ACCA that demonstrate a strong understanding of accoun...
As an accountant, I'm looking for an expert who can assist me in automating my m...payroll, and preparing financial statements like P&L and Balance Sheets. Key Responsibilities: - Automate the creation of books of accounts, General Ledgers, Trial Balance, and P&L - Develop macros for Excel to streamline these tasks - Automate data entry, transaction categorization, and report generation in the books of accounts Ideal Skills and Experience: - Proficient in Microsoft Excel and VBA for macro development - Strong background in accounting - Experience in automating tasks in Excel - Ability to create user-friendly automated systems No integration with external accounting software or databases is required. The automated system should have an intuitive and user-friendly int...
I am in need of a skilled MS Access and VBA Developer to assist in creating a new database from scratch, focusing primarily on data management and analysis. Key Responsibilities: - Database Design and Normalization: You will need to create a well-structured, efficient database that supports our data management needs. - Data Import/Export Functions: Implementing seamless data import and export functionalities is crucial for this project. Ideal Skills and Experience: - Proficient in MS Access and VBA - Strong background in database design - Experience with data management and analysis - Able to write and optimize queries - Competent in implementing data import/export functions. Your expertise will help us streamline our data management process, making it more efficie...
I am seeking a part-time financial modeler with advanced expertise in Microsoft Excel to assist with various financial modeling projects. The ideal candidate will have a strong understanding of financial analysis, forecasting, and Excel-based modeling techniques. Key Requirements: Proficiency in advanced Excel functions (pivot tables, macros, VBA, etc.). Experience in financial modeling, budgeting, and forecasting. Ability to analyze and interpret financial data. Strong problem-solving and analytical skills. Attention to detail and accuracy in work.
I am seeking a part-time financial modeler with advanced expertise in Microsoft Excel to assist with various financial modeling projects. The ideal candidate will have a strong understanding of financial analysis, forecasting, and Excel-based modeling techniques. Key Requirements: Proficiency in advanced Excel functions (pivot tables, macros, VBA, etc.). Experience in financial modeling, budgeting, and forecasting. Ability to analyze and interpret financial data. Strong problem-solving and analytical skills. Attention to detail and accuracy in work.
I'm looking for a highly skilled Excel VBA expert to assist with handling product data. YOU HAVE TO CHECK THE TASK DETAILS FIRST AND ONLY BID IF YOU CAN DO THIS. You need to make this pattern for Make Mode and Year and add it into excel coloumn. make=Nissan|INFINITI|Mini|Ford|Honda,model=Vibe|Prizm|Elise|Exige|xA|xB|xD|Celica|Corolla|Echo|Matrix|MR2|MR2 Spyder|Yaris,year=2004|2005|2006|2002|2003|1987|1990|1991|1992|1993|1994|1995|1996|2008|2009|2010|2011|2012|2013|2014|2015|2016|2017|2018|2019|2020|1997|1985|1986|1988|1989|2000|2001|1998|1999 SEE IMAGE ATTATCH WHERE YOU WILL EXTRACT MAKE MODEL YEAR FOR PART NUMBERS. Specific Tasks: - Creating custom formulas: You will need to develop advanced formulas that involve multiple functions to manipulate and analyze our product da...
I am seeking a part-time financial modeler with advanced expertise in Microsoft Excel to assist with various financial modeling projects. The ideal candidate will have a strong understanding of financial analysis, forecasting, and Excel-based modeling techniques. Key Requirements: Proficiency in advanced Excel functions (pivot tables, macros, VBA, etc.). Experience in financial modeling, budgeting, and forecasting. Ability to analyze and interpret financial data. Strong problem-solving and analytical skills. Attention to detail and accuracy in work.
NEED TO DEVELOP A MACRO WITH VBA SCRIPT TO CREATE AUTOMATIC PROCESSING OF PROCESS WHICH IS LINKED WITH AUTOCAD AND STAAD PRO ANALYSIS SOFTWARE, SAMPLE PROCES INTRODUCTION WILL BE PROVIDED WHICH ARE DONE IS INITIAL TRIALS.
I'm looking for an expert in Microsoft VBA for PowerPoint who can create custom macros and functions for me. The main objective is to streamline repetitive tasks, specifically formatting slides and inserting uniform content. I already have the code which I have integrated as an add-in to my PowerPoint Toolbar. I need some help troubleshooting to fix some errors. Ideal Skills: - Proficient in Microsoft VBA - Extensive experience with PowerPoint - Ability to create custom macros and functions - Understanding of slide formatting and content insertion - Experience in debugging and troubleshooting VBA code efficiently. The project needs to be completed within 1 week. The macros should also integrate with Outlook for email functionality.
I need an expert in Excel and VBA to develop a macros for me. This macros will match invoices from one set to another in the same Excel file and perform a reconciliation between both sets and highlight the difference way I want. Key requirements: - Highlight discrepancies in GST tax numbers even when party names are the same - Handle invoice numbers that are in different formats or of different lengths - Automate this process to reduce manual work The main focus for this project is to highlight tax number discrepancies. Currently, the invoice numbers are formatted in different formats. The ideal candidate should have extensive experience in Excel and a deep understanding of how to create and implement macros. Knowledge of tax number formats and invoice reconciliation proc...
I am seeking a part-time financial modeler with advanced expertise in Microsoft Excel to assist with various financial modeling projects. The ideal candidate will have a strong understanding of financial analysis, forecasting, and Excel-based modeling techniques. Key Requirements: Proficiency in advanced Excel functions (pivot tables, macros, VBA, etc.). Experience in financial modeling, budgeting, and forecasting. Ability to analyze and interpret financial data. Strong problem-solving and analytical skills. Attention to detail and accuracy in work. Application Instructions: Please attach your resume and include samples of your previous work in financial modeling. Applications without samples will not be considered.
A VBA project combining macros for importing files, comparing and formatting data across sheets and reporting based specific parameters
I'm in need of a developer with significant experience in ZATCA Phase 2 E-Invoicing. The main task will be creating a toolkit in MS Access VBA to generate and sign XML invoices compliant with ZATCA standards. Key Responsibilities: - Develop a toolkit that generates and signs XML invoices. - Ensure the toolkit can integrate seamlessly with my existing system. - Provide video tutorials demonstrating how to use the toolkit. Requirements: - Extensive experience with ZATCA Phase 2 E-Invoicing. - Proficiency in MS Access VBA. - Strong knowledge of REST API integration. - Ability to create clear, concise video tutorials. The project will be considered complete when the XML invoices generated by the toolkit pass validation on the ZATCA testing platform and return a &qu...
I have a vba project to complete and need someone to do it with me and also tutor me at the same time. I need tutoring for 2 hours.
Hi AlbertoBarberoIt, Ho bisogno di un lavoro in VBA per fare copy trading. Ti spiego il mio problema. Ho realizzato un codice in VBA che fa queste cose: va su un block Explorer per controllare se un wallet di cui voglio copiare l'operatività ha fatto una operazione e, in caso affermativo, la copia e usando Postman manda a Binance l'ordine buy/sell; in caso negativo, riprende il ciclo e così via, no stop. Questo codice girava da poco tempo in test, quando il block explorer ha messo il cloudflare e cosi non riesco più ad accedere con powerquery. Ho cercato altri block explorer ma chi per un motivo, chi per un'altro, non riesco a scaricare i dati che a me servono, anche se ce l'hanno. Quindi ritengo che la soluzione definitiva sia di us...
Cần 1 file excel có VBA (Macro) tự động link các thông tin: Định mức nguyên liệu - Kế hoạch sản xuất - Tiêu hao / Tồn nguyên liệu.
I'm looking for an experienced VBA developer to handle a project that involves importing data from three distinct sources, applying filters to this data, and subsequently generating detailed reports and visual graphs. The final product should be user-friendly and presented within Excel using advanced VBA techniques. The report needs to be as detailed as possible, capturing intricate insights from the filtered data while ensuring accuracy and efficiency in process execution. Timely delivery by the end of this week is crucial.
I'm looking for a professional with expertise in VBA and Excel to help automate data analysis. Task Overview: - Primary focus will be on analyzing customer data for trends. - This will involve developing a set of macros to carry out the analysis automatically, saving time and effort. Ideal Skills and Experience: - Strong proficiency in Excel, particularly with VBA and macros. - Relevant experience in trend analysis, particularly with customer data. - Ability to deliver a user-friendly automation solution.
