Vba emailnotify project jobs

I'm an advanced Excel user looking to deepen my expertise with an in-person tutor. I want to focus on: - Macros and VBA - Data Analysis and Pivot Tables - Complex Formulas and Functions Ideal candidates should have a profound knowledge of these topics, combined with excellent teaching skills. Experience in creating customized lesson plans and real-world examples will be a plus. The tutoring sessions should be 4-5 hours per week. The tutoring sessions will take place at my home. The preferred duration of the tutoring engagement is 1-3 months. Tutoring sessions should be scheduled on weekends. The tutor should provide a personal laptop during the sessions. I prefer individual tutoring sessions. Tutoring sessions should be scheduled on weekend afternoons. A focus on statistical...

Automated Pricing Model for CNC & Fabrication – Excel & ERP Integration Project Overview Impress Group is a precision engineering company supplying components globally. We specialize in laser cutting, bending, milling, turning, powder coating, welding, and fabrication and need a fully automated, accurate, and structured pricing model to improve efficiency and consistency in job costing. This project, called Project Alpha, aims to develop a dynamic, rules-based Excel pricing tool that: - Automates the quoting process using simple user inputs from technical drawings - Prevents incorrect quoting by restricting users from quoting parts beyond our manufacturing capabilities - Calculates accurate process pricing for all services - Generates time dec...

I am seeking a skilled VBA/Excel programmer to develop an inventory program within excel that will allow the following: 1) allow me to add products into a components inventory database using a form Fields are: Vendor, SKU, UPC, Status, QTY STOCK, EXP DATE, Category, Brand, Component Name, Component Description, Size, DIMS, Gross Wt, Case Count, Case Cost, Unit Cost, Component URL, Product Image 2) Bundle Design Tool - a graphical design form that allows me to add different components to build a bundled product. Fields are: Bundle Name, Bundle Desc, SKU, Theme Category, Inspired By, QTY STOCK, STOCK STATUS, Target MSRP, Target Cost Website URL, Shipping Weight, Dimensions Components List/Cost Analysis: in the form there will be a list that will show the added components SK...

...tables, charts, and dashboards for data visualization. Automate tasks using Excel VBA (Macros) and Power Query to improve workflow efficiency. Clean, structure, and analyze large datasets using data validation, conditional formatting, and Power Pivot. Troubleshoot errors in formulas and provide solutions to improve spreadsheet functionality. Collaborate with different teams to gather requirements and create customized Excel reports. Maintain and improve existing Excel models, ensuring accuracy and performance. Train and support team members on best practices for using Excel effectively. Required Skills & Qualifications: Proven expertise in advanced Excel formulas and functions. Experience in Excel automation using VBA Macros, Power Query, and Power Pivot. Strong analyt...

...alongside the tabular data. - Ensure the documents are correctly formatted and easy to read. Ideal Skills: - Proficiency in Microsoft Excel and Word. - Experience with automation and scripting. - Strong attention to detail. Please provide examples of similar projects you have completed in your bid. The developer should use provided templates for the Word documents. The automation should be done using VBA for Office. The automation will be set up to handle one Word document template. The automation should be designed to handle low volume generation, approximately less than 50 documents regularly. The generated Word documents should be named using certain values from the Excel data. Please include pre-defined guidelines as specific text descriptions in the documents. The text de...

I'm looking for an expert in advanced Excel to help me improve my skills specifically in using shared Excel sheets on Google Drive. Ideal Skills and Experience: - Proficient in advanced Excel, particularly with shared sheets - Excellent teaching skills - Extensive experience with Google Drive's collaborative editing features - Knowledgeable about Excel's advanced formulas, VBA and Macros, as well as data analysis and pivot tables - Good understanding of file permissions and security in a shared environment. Key Focus Areas: - Mastering collaborative editing in Google Drive - Learning to use advanced Excel features in shared sheets - Improving overall Excel proficiency.

I'm in need of a skilled professional who can create a dynamic PowerPoint presentation slide using VBA code and Macros. Key requirements: - The slide should be a part of a presentation - It will primarily contain images and visuals - The VBA code or Macro should automate transitions and animations Ideal skills and experience: - Proficient in VBA and Macros - Experienced in creating engaging PowerPoint slides - Able to effectively automate slide transitions and animations Please provide examples of similar work in your proposal.

...dynamic Excel models - Ability to visualize task dependencies in various ways - Experience in creating Gantt chart visualizations in Excel for task dependencies. - Ability to write macros and VBA scripts to automate task dependency updates. - Expertise in using pivot tables to dynamically filter and analyze task data. - Proficiency in using conditional formatting to highlight critical paths and dependencies. - Experience incorporating data validation to prevent incorrect task entries. - Experience in designing user-friendly interfaces within Excel for ease of use. The ideal freelancer for this project will be quick, efficient and able to comprehend my requirements without much guidance. Please note, I'm uncertain about the best way to visualize task dependencies in E...

...layout, header/footer, font style, spacing, etc.). Implement a solution (such as a macro or easy-to-use tool) that allows me to apply this template automatically with just one click to any document. Provide clear instructions on how to use the template or macro so I can apply it efficiently to new documents. Skills Needed: Expertise in Microsoft Word, including templates and macros. Familiarity with VBA (Visual Basic for Applications) for automating tasks (if applicable). Ability to create reusable templates that are easy to implement. Strong attention to detail and an understanding of formatting best practices. Additional Information: The template should work with Microsoft Word 2016 or later. It should be easy to update or adjust settings in case my formatting needs change in...

...dashboard's design for better readability, adding insightful analytics, automating processes using VBA where possible, and creating custom visualizations and interactive elements. Key Tasks: - Improve the design and layout of the dashboard - Incorporate more detailed and insightful financial analytics, with a focus on ratio analysis and cost-benefit analysis - Use your expertise in Excel to ensure automation where possible - Design and implement custom visualizations, such as graphs, charts, pivot tables, and trend indicators - Create interactive elements to enhance user engagement with the dashboard Ideal Skills and Experience: - Advanced Excel skills, including proficiency in Excel formulas and VBA - Strong accounting knowledge and experience in financial data ana...

I need a tailored Excel template to streamline my work checks. Currently, I have to manually copy and paste complicated formulas and use text replace functions to substitute keywords like LESS and PLUS with their mathematical counterparts. For examples sake, I want to put in "(25%LESS1/8LESS1/16 of 7/8) of 1/2 of 1/2 of 8/8" in A1, and have a Cell then automatically output that ...template that can process long form mathematical expressions and return values automatically, saving me the tedious work. - Ensure the template can handle mixed operations including addition, subtraction, multiplication, and division. Ideal Skills: - Strong expertise in Excel, especially in creating custom templates. - Experience with mixed operation formulas. - Familiarity with Excel's macro and...

...available credit line. The final solution must be compatible with both Microsoft Excel for Windows and Microsoft Excel for Mac. Project Requirements: Input Data: Loan start and end date Interest rate (%) Maximum loan amount (credit limit) Loan payment records (date and amount) Core Calculations: Interest calculation for each loan payment Cumulative interest tracking Available credit line (credit limit minus utilized loan amount) Yearly Overview Section: Loan amount on the first and last day of each calendar year Correctly calculated annual interest Available credit line at the end of each year Technical Requirements: The spreadsheet must use formulas and/or VBA automation to ensure accurate and dynamic calculations. Must be fully functional on both Windows and Mac version...

Need to analysis current select columns using ChatGPT API

I'm currently using a Selenium driver via Excel VBA to scrape a website, but I'm running into some issues that I need help fixing. The project involves a scrollable table where the link element needs to come into view before data can be extracted. Key Problems: - Extracting data from the table consistently fails. - Many elements are not found when trying to scroll the table into view. Methods Tried: - I have attempted using Execute JavaScript to scroll the table into view. I am happy to share my current code and provide access to the website so that you can see the problem first hand. I am looking for a freelancer who has experience with Selenium and Excel VBA and can help me fix this quickly.

I'm currently using a Selenium driver via Excel VBA to scrape a website, but I'm running into some issues that I need help fixing. The project involves a scrollable table where the link element needs to come into view before data can be extracted. Key Problems: - Extracting data from the table consistently fails. - Many elements are not found when trying to scroll the table into view. Methods Tried: - I have attempted using Execute JavaScript to scroll the table into view. I am happy to share my current code and provide access to the website so that you can see the problem first hand. I am looking for a freelancer who has experience with Selenium and Excel VBA and can help me fix this quickly.

Please Sign Up or Login to see details.

I'm looking for a freelancer to create an Excel workbook that consolidates data from 7 source sheets into a main sheet. The solution should dynamically update in real-time as the data in the source sheets change. PLEASE SEE THE ATTACHED PDF FOR A BETTER UNDERSTANDING. Key requirements: - Use either Excel formulas or Power Query. VBA and Macros are not allowed. - Summarize totals for each unique combination of columns A-D from the source sheets. Note : data both sheets could go up to 1000 + rows. Deliverables: - A fully functional Excel file where the main sheet updates in real-time. - Clear documentation or a short instructional guide explaining how the solution works. Ideal skills and experience: - Strong Excel skills and expertise in using Power Query. - Good understan...

I have an Excel workbook with 7 source sheets and 1 LV (Landing View) sheet. The task is to automatically consolidate data from the 7 sheets into the Main sheet using either Excel formulas or Power Query (VBA and Macros are strictly off-limits). Requirements: - The solution needs to be dynamic, updating the LV sheet in real time as data in the 7 source sheets changes. Deliverables: - A fully functional Excel file where the LV sheet updates in real-time based on data from the 7 sheets. - Clear documentation, or a short instructional guide, explaining how the solution works. Ideally, the freelancer will have strong Excel skills, expertise in using Power Query, and a good understanding of data mapping. Experience with creating dynamic Excel solutions will be highly advantageous.

I'm in need of a proficient Excel macro developer who can automate a series of tasks for me. The primary objectiv...usability. - Report Generation: Automating the process of report creation to save time and effort. - Complex Calculations: Building macros to perform intricate computations seamlessly. The macros will primarily interact with Excel files and Databases. As for triggering the macros, I would like to initiate them manually. Ideal skills and experience for this job: - Strong proficiency in Excel and VBA (Visual Basic for Applications). - Prior experience in developing macros for data cleaning, report generation and complex calculations. - Familiarity with databases and ability to integrate them with Excel. - Capability to create user-friendly macros that can be trig...

I'm looking for a skilled Excel VBA developer. I need a worksheet modification that will control data entry into cell H8 based on the status of cell D8, and enforce data type constraints. Requirements: - If cell D8 is BLANK: Allow user to enter data into cell H8. - If cell D8 IS NOT BLANK: Populate cell H8 with data from cell H12 and lock the cell from user changes. - Implement numeric-only validation for cell H8. Additional Information: - Cells D8, H8, H12 are unlocked and the sheet is password protected. - The functionality should persist for future users, even after data row 8 has been saved and cleared by an existing VBA script. Ideal skills include: - Proficiency in Excel and VBA - Experience with implementing data validation and conditional cell behavior ...

Create an excel file, with macros and forms (VBA development) to facilitate the folow up of work

I need a VBA script for Microsoft Word that will help me remove highlights from bullets and the space after in bulleted paragraph lists. The script should be manually executable by clicking a button. Ideal skills and experience for the job: - Proficiency in VBA (Visual Basic for Applications) - Strong understanding of Microsoft Word functionality - Prior experience creating Word scripts - Ability to write clear, user-friendly code Please note: The specific version of Microsoft Word this script will be used on has not been determined yet, so the script should be compatible with Microsoft Word 2016, 2019, and 365.

...exe program but will need to be triggered using a Windows batch command or VBA. Original source txt file is built from an excel worksheet, so an alternate solution can be building files as described via excel VBA from existing excel spreadsheet as long as it includes a PUT command to the FTP location for all built files. Ideal skills for this project include: - Proficiency in writing Windows batch files. - Excel VBA. - Experience with file handling and FTP in a Windows environment. I have an FTP location and credentials ready. Files should retain the original filename with a numeric suffix (e.g., , ). Will supply example of full source file and/or original excel file for a VBA solution. The header in the source file is a single line. The batch fil...

My macros are not functioning on my Mac and I need an expert to troubleshoot this for me. Ideal candidates for this job should have: - Deep understanding of Excel VBA - Experience with Mac versions of Excel - Problem solving skills to troubleshoot why macros aren’t running and resolve code, where required branch code into mac or pc subs/functions.

I need a skilled Excel VBA programmer to assist in automating tasks in my Excel workbook. The primary task involves sending data from a user form to the relevant worksheet. Key Requirements: - Proficient in Excel VBA - Experience in Excel workbook automation - Ability to organize data by category in the relevant worksheet. The ideal freelancer for this project should have a strong background in automating tasks using Excel VBA and can efficiently categorize data in Excel worksheets.

I am seeking a skilled VBA developer to help automate the generation of financial reports in Excel. Ideal Skills and Experience: - Proficiency in VBA with extensive experience in Excel automation - Prior experience in automating financial report generation is a plus - Strong attention to detail and ability to understand complex financial data

I need a professional Excel expert with strong skills in data analysis, macros, and VBA. You will be required to create a sophisticated Excel spreadsheet for analyzing trading data. Key Responsibilities: - Create an advanced Excel spreadsheet for trading data analysis - Incorporate real-time data updates into the spreadsheet - Implement advanced charting and visualization techniques - Design automated trading signals within the spreadsheet Ideal Skills: - Excel: Advanced spreadsheet creation and optimization - Macros and VBA: Proven experience in automating tasks and enhancing workflow - Python: Familiarity with Python for data analysis and Excel integration would be a big plus. Payment: - The designer will be compensated on a daily basis, with payment based on the number...

I am looking for a VBA expert who can develop a solution for generating detailed reports from Excel files for my business case. The primary objective of this project is to automate the report generation process, making it more efficient and less time-consuming.

I need an experienced Excel VBA programmer to modify my VBA Code macros. The job involves enhancing an Excel form and including a 'modify' function. Modify "Agency" file to be like "Testttt" file and include the Modify button. Key requirements: - Modify an existing Excel form - Include a 'modify' function in the form - Improve the overall performance of the form The ideal freelancer would have: - Extensive experience in Excel and VBA - Ability to optimize data modification processes - Skills in designing user-friendly forms The project also involves changing some aspects of the form's appearance: - Removing some fields from the form - Changing the layout of the form The successful freelancer will be able to deli...

I'm in need of a proficient VBA CorelDRAW programmer for the 2024 version. My project involves creating a VBA script that generates QR codes within a specific template of a certain size. The script should also arrange these QR codes for printing on various printer sizes, specifically a custom size of 48x96 inches. Ideal candidate should be skilled in: - CorelDRAW and VBA - Understanding of QR code generation - Experience with custom printer size arrangements - Ability to work with specific size templates (small, medium, large)

I'm seeking a proficient Excel VBA programmer to create a script for my Purchase Order workbook. This project involves both an existing workbook and the creation of a new one. The VBA script should be triggered automatically when the workbook opens. Key Tasks: 1. Implement filters at the top of the worksheet. 2. Adjust the width of Column C (Products). 3. Insert new columns with specified modifications: a. After Column I: Discrepancy (using formula: =I2-H2) b. After Column J: Reason (with a dropdown list sourced from the next sheet) c. After Column K: Notes (a free text column) 4. Apply specific formatting to the columns: a. Column A: 40 points b. Column B: 10 points c. Column C: 60 points d. Column D: 35 points e. Columns E-J: 15 points ...

...all extracted data is neatly organized and formatted for easy access within Excel. Provide clear, user-friendly functionality to paste or upload listings and automatically trigger the data extraction process. Skills Required: Strong experience with web scraping or API integration to pull data from Zillow, Redfin, StreetEasy, and other platforms. Proficiency in Excel automation, preferably with VBA or Python (pandas, openpyxl) to integrate the data extraction functionality. Familiarity with Zola NYC and NYC Open Portal to access zoning and building-related data. Knowledge of real estate terminologies and zoning regulations in NYC. Experience with data validation to ensure accurate and reliable data extraction. Ability to work autonomously and deliver high-quality, maintainable co...

Please Sign Up or Login to see details.

I'm seeking an Excel expert who can help me code a MACROS to automate a process in Excel. The task involves analyzing employee data and generating results related to loans and other similar dat...process in Excel. The task involves analyzing employee data and generating results related to loans and other similar data entries. Key Responsibilities: - Develop a MACROS script to automate data analysis on employee data. - The macro should be able to provide results for specific data entries related to loans and other similar metrics. Ideal Skills and Experience: - Proficient in Excel and VBA programming. - Prior experience in developing Excel MACROS for data analysis. - Understanding of employee data metrics. - Able to deliver efficient and effective solutions for data processin...

I'm seeking a proficient Excel developer with strong skills in VBA and Macros. The job involves creating an automated workflow to transform data from a single Excel file into three separate files. Key Tasks: - Importing data from one Excel file - Creating three files using VBA and Macros - Data cleaning - Data merging - Data filtering The data filtering will involve: - Applying numerical ranges - Text matching - Date ranges Ideal candidates should have a robust understanding of data transformation processes and extensive experience with Excel VBA and Macros.

Description: I am looking for a skilled developer to help deploy an existing solution that automates Word document text replacement using VBA and outputs a PDF file. I already have a fully functional VBA code and an HTML interface to generate the code. The project involves using this existing logic and expanding it to work seamlessly on a server-based environment. Key Requirements: PDF Output: The system should take user inputs through the existing interface (or an upgraded version) and automatically replace the specified keywords in a Word document. Once the replacement is complete, the system should generate and provide the user with a downloadable PDF file. Database Integration: Create a database to store keywords used for replacement. Provide an option to sele...

I'm seeking an Excel expert who can help me with a project needing to build a client pipeline excel sheet which provides the ability to multi select checkboxes from a drop down for certain columns. Also need to have the checkboxes grouped under a heading with indentation/ categorization The project requires the development of advanced macros and VBA scripts. Ideal Skills: - Extensive knowledge of Excel - Proficient in writing complex VBA scripts - Experience in creating advanced macros Key Responsibilities: - Develop an excel sheet with certain columns having the ability to list checkboxes and support multi selection. - this drop down multiselect checkbox list also will be categorized under a few main parent checkbox - upon multi selection and pressing o...

I'm looking for a skilled Excel VBA expert to create a macro that converts data from my Excel file into PDFs and sends them to multiple email addresses. The Excel sheet has several tabs, each corresponding to a different group of recipients. Key requirements: - The macro should be able to handle 4 or more separate groups of recipients, as per the different tabs in the Excel file. - Email addresses are provided in a comma-separated list format. - Each tab contains sales reports that need to be converted into PDFs. Ideal candidates should have: - Extensive experience with Excel VBA and macro programming. - Previous work with automating PDF conversion and email sending from Excel. - A strong understanding of handling and sorting data for different groups. Please note, th...

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.

I am a project manager handling diverse projects and need a professional Excel dashboard to track and manage my work efficiently. The dashboard should provide a clear, user-friendly interface and visual insights to monitor progress, timelines, budgets, and key metrics for the following: CSR Fund Tracking: Monitor inflows, outflows, and utilization of CSR funds across multiple initiatives. International University Collaboration: Track milestones, agreements, events, and communications with international universities. Hub and Spoke Model: Manage operations, performance, and data flow in this healthcare delivery model. Share4Care Online Fundraising: Track donor statistics, funds raised, and campaign performance. Ayurveda Marketing: Monitor marketing initiatives targeting both domestic...

I require an experienced VBA programmer to write a script for my Office 365 Excel workbook. The task is to automate the printing process of a specific worksheet based on a cell value in the 'Component Index' worksheet. Key Requirements: - The 'Component Index' worksheet contains the cell value that determines the number of pages to print. - The script should allow for changing the name of the workbook without interrupting the print process. - The automation should seamlessly integrate with Excel's regular print button. The ideal candidate for this project should be proficient in VBA programming and have extensive experience with Excel 2019 and Office 365. Knowledge of Excel's print processes and handling of workbook events is crucial. ...

I need a skilled VBA programmer to help me add a macro to my existing Excel file. The macro needs to automate some of my repetitive tasks, specifically: - Data entry: I want to streamline the process of inputting data into the spreadsheet to save time and reduce errors. - Data analysis: I need assistance with automating some basic analysis to derive insights from the data. The data for these tasks will primarily come from user input within Excel. Ideal skills and experience for this job include: - Proficient in VBA programming with a strong portfolio of Excel automation projects. - Excellent understanding of data manipulation and analysis within Excel. - Ability to work with user-generated input and create a seamless automation experience. I'm looking for someone ...

I need a VBA script in Excel that will help me to import data into Word. The main purpose of this script will be to merge data from Excel into a Word document. Key Features: - The Word template will include text data, tables and spreadsheets, as well as charts and graphs. - The imported data will need to be formatted with custom styles, not just standard formatting. Ideal Skills and Experience: - Proficient in VBA programming. - Strong understanding of Excel and Word integration. - Experience with creating custom styles in Word. - Able to work with diverse types of data.

Looking for a freelancer experienced in Excel and VBA to develop a tool that automates the creation of Sorare teams based on data from three sheets: "Sorare Bot," "Classifications," and "GW." The tool should: Generate valid 5-player teams for competitions following specific rules (positions, exclusions, etc.). Organize teams into blocks categorized by competition. Create a list of unused players with exclusion reasons. Include a button to update the "GW" sheet whenever the other sheets are modified. Skills Required: Advanced Excel and VBA expertise. Data processing and automation. Attention to detail for applying prioritization and exclusion rules.

- The data is easily selectable and copyable. - I want the final data saved to an Excel spreadsheet. - If possible, I would like the use of a VBA macro for ease of us

An excel file that will import images from a folder. According to a specified layout, and having a filter and sorting feature.

I need a talented individual to create a system for my Excel workbook that intelligently transfers mixed data (text and numbers) from one sheet to another. The data transfer should occur daily, triggered by updates to the data. Key Requirements: - Proficient in Excel with extensive experience in creating complex formulas and logic. - Familiarity with VBA or similar programming languages for automating tasks in Excel. - Ability to understand and manipulate mixed data types. - Experience with setting up systems for daily data tracking and transfer. Ideal skills include attention to detail, problem-solving abilities, and a strong understanding of data management. Please apply if you can help me streamline my data management process.

I need help with capturing data from a website. The data is displayed in a table format below a chart for a particular facility. I want to capture monthly data for a...need help with capturing data from a website. The data is displayed in a table format below a chart for a particular facility. I want to capture monthly data for all time periods for all facilities on the website. Key Details: - The data is easily selectable and copyable. - I want the final data saved to an Excel spreadsheet. - If possible, I would like the use of a VBA macro for ease of use. Ideal skills for this project include: - Proficiency in Excel, particularly with creating and using macros. - Experience with data extraction from websites. - Attention to detail to ensure all data is accurately capture...

Excel Data Cleaning: Removing duplicates, errors, and inconsistencies for accurate analysis. Excel Data Formatting: Organizing data into a clear and professional layout. Excel Dashboards: Creating interactive and visually appealing dashboards for data visualization. Excel VBA: Automating repetitive tasks and creating custom macros to save time. Pivot Tables and Charts: Summarizing and visualizing large datasets effectively. Data Analysis: Performing advanced calculations and trend analysis for insights. Conditional Formatting: Highlighting important data with rules and color coding. Formulas and Functions: Using advanced formulas (e.g., VLOOKUP, INDEX-MATCH) for dynamic calculations. Data Validation: Ensuring data accuracy with dropdown lists and validation rules. Excel Reports: Gen...

Hello. It's supposed to generate teams based on data from multiple sheets, but it doesn't work like I need. When I run the script it gives me an error and I can't solve it, can you help me?