Progecad vba jobs
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 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: - 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 is low...
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.
...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 demand forecasting by analyzing historical data and identifying trends. Data Quality Assurance: Identify and address discrepancies to ensure accurate reporting. Key Skills Required: Advanced Excel (formulas, pivot tables, Vlookup) Strong attention to detail and data integrity Familiarity w...
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...
...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 data collection Conversion of PDF to Excel or Word formats Database management and entry (CRM, Excel) Organizing and cleaning data for seamless integration into your system Why Choose Me: Attention to Detail: I ensure all data is entered ac...
...secure, fillable PDF forms. (Might need few forms with minor changes in each) A reliable workflow to extract and transfer data to Excel. Automated scoring in Excel based on predefined rules. Clear documentation for the process. Skills Required Experience with PDF form creation (e.g., Adobe Acrobat). Proficiency in automation tools . Excel automation expertise (formulas, VBA, or scripts). Knowledge of cloud storage integration (e.g., OneDrive). Budget: Flexible based on the solution provided. Timeline: Suggest me your achievable timeline How to Apply: Please submit your proposal with: A brief outline of your approach to solving this use case. Relevant examples of similar workflows or automation projects you’ve worked on. Your esti...
...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 data collection Conversion of PDF to Excel or Word formats Database management and entry (CRM, Excel) Organizing and cleaning data for seamless integration into your system Why Choose Me: Attention to Detail: I ensure all data is entered ac...
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
...should convert inputted data into total values represented by dynamic circle graphs (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 de...
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 server the...
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 techniques Please...
...Key Skills: Accurate and efficient data entry with attention to detail. Expertise in Excel functionalities including Pivot Tables, VLOOKUP, Macros, and Conditional Formatting. Data cleaning, validation, and transformation to improve data usability. Creating detailed and actionable reports for informed decision-making. Streamlining processes by automating repetitive tasks using Excel formulas and VBA. Maintaining organized, error-free data records to support business operations. Strengths: Ability to handle large datasets while maintaining precision and meeting tight deadlines. Strong problem-solving skills to identify and resolve data inconsistencies. Collaborative and adaptable, ensuring smooth coordination with cross-functional teams. Looking for opportunities to leverage my ...
I need assistance with a VBA script that will delete the contents of a Google Sheets file and replace it with text data from a specified tab in an Excel sheet. Key Requirements: - The data to be transferred consists solely of text, which includes hyperlinks. - It is not necessary to maintain any specific formatting from the Excel sheet, so the focus should solely be on the accurate transfer of the content. Ideal Skills: - Proficiency in VBA - Experience with Google Sheets and Excel - Ability to create efficient data transfer scripts I'm looking for a professional who can provide a clean, working solution to this problem. The script should be triggered manually by the user.
I need an Excel add-in that can populate numbers from a raw data CSV file into multiple financial models (Profit & Loss Statement, Balance Sheet, and Cash Flow Statement) in a specified manner. Ideal Skills and Experience: - Proficient in Excel and VBA programming for creating add-ins - Experience with financial modeling - Familiar with CSV data handling - Strong problem-solving skills to understand and implement the required data mapping - Attention to detail to ensure accuracy in data population
I'm seeking a skilled developer with expertise in VBA and experience with Jade Database systems. Key Requirements: - Create VBA code that will copy data from Excel and paste it into corresponding fields in a Jade Database system. - The code needs to identify and match fields in the database with the data in Excel accurately. Ideal Skills: - Proficiency in VBA programming. - Prior experience working with Jade Database systems. - Strong knowledge of data matching techniques and database interactions. - Excellent problem-solving skills to troubleshoot any potential issues. Please provide examples of similar projects you've completed in your proposal.
I ordered the incorrect size, and I tried to fix it with my rudimentary skills. I need to hire you again to resize these from their current size to 1920x1080. I totally missed the proper size. I also needed the progeCAD Logo the same size as the current "logo" on our website.. I was hoping to get a file the same size as the file that I uploaded during the last project. You can get this image yourself by going to and right clicking the logo, and then save image...
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 transfer pr...
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 resource...
...YouTube, social media, and professional use. Add transitions, special effects, and audio enhancements. Create promotional videos, ads, and cinematic edits. Optimize videos for different platforms to meet format requirements. Provide a quick turnaround while ensuring high quality. Excel and Data Analysis Create dynamic and visually appealing Excel dashboards. Automate tasks with Excel formulas, VBA macros, and scripts. Analyze data to generate meaningful insights and reports. Clean and organize large datasets efficiently. Build customized templates for financial modeling, tracking, and reporting. Assist in solving Excel-related challenges and teach advanced techniques. Feel free to contact me for a personalized solution to your needs!...
I need a single Access SQL query that calculates the total credits gained by university students in 5-week periods. The query should also identify students who earn more than 60 credits in...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. Time is ...
...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: Use screen recording software of your choice. High-quality video with clear resolution (minimum 1080p). No background noise or voice-over—just screen activity. Structure: Tutorials should be modular, allowing users to easily follo...
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
...new data is added. Use Excel features like tables, Power Query, or even VBA (if needed) to simplify data updates. Provide instructions or documentation on how to update the data and dashboard efficiently. Additional Features: Filters: Allow users to filter by plant, month, or KPI for more detailed analysis. Performance Benchmarks: Optionally include benchmark lines in charts to compare actual performance against targets. Deliverables: A well-organized, fully functional Excel dashboard with interactive charts and summaries. Documentation or guidance on how to update the dashboard with new data for future use. Skills Required: Advanced proficiency in Microsoft Excel (charts, formulas, conditional formatting, Power Query, VBA if needed). Strong understanding of data visualiza...
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 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 qualifying candidates.
...for maintaining confidentiality while analyzing financial data. Key Responsibilities: - Analyzing financial data using MS Excel - Hiding specific 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 fi...
I would create dynamic flow chart and gantt kind of chart using vba which would update according the data updated in the reference sheet.
