Progecad vba jobs
Do analysis and create data visualize for company product
I'm looking for an advanced Excel expert who can create a roster maker fo...shifts per day: The roster maker should be able to accommodate AM, PM, and ND (night) shifts. - User Inputs: The sheet will need to take in employee names and IDs, shift totals, and contracted hours. - Complexity: This isn't a simple roster maker. It will need to use a range of formulas and conditional formatting, along with the automation through macros. Ideal Skills: - Expertise in Excel and VBA for Macros - Experience with creating complex scheduling tools - Ability to understand and implement conditional formatting and formulas The goal is to have a functional, user-friendly Excel sheet that can simplify the task of roster creation. Please provide examples of similar projects you have complet...
I’m looking for an experienced Excel VBA developer to create an Excel-based tool to manage my properties, units, tenants, payments, and maintenance tasks. The solution should allow multiple users, each with their own access or passwords, so not everyone can edit the same data. I have limited technical knowledge, so this must be very user-friendly. === Project Requirements 1. Single Excel File (.xlsm) • All data (properties, units, tenants, payments, maintenance) and the dashboard in one macro-enabled workbook. 2. Multi-User Access & Password Protection • Ideally, have basic password protection or user-level access within Excel: • For example, an initial login form that requests username/password. • Different roles (e.g., admin vs. read-only) woul...
Hi. It’s supposed to generate teams based on data from several sheets, but it’s not working as I need. Additionally, I would like to have a button to update the data for each game week. I’m attaching the code so you can review it and help me out if possible. Thanks in advance!
I need an expert in Excel VBA to breathe new life into my project. The enhancements will involve: - **Data processing and automation**: Improving the efficiency and speed of data handling processes. - **User interface enhancements**: Making the project more user-friendly with better forms, buttons, and navigation. - **Integration with external systems**: Ensuring seamless connectivity with other platforms and systems. The user interface improvements will focus on: - **Forms and input fields**: Streamlining data entry and enhancing usability. - **Buttons and navigation**: Simplifying the user journey through the project. - **Report layouts and visuals**: Upgrading the presentation of data for better comprehension. Visually, the reports will need: - **Better formatting and stylin...
I'm looking for a skilled VBA programmer to enhance my existing code. Around 75% of the code is already written to read data from CSV/Excel. The enhancements should facilitate the generation of summary reports, creation of various types of graphs and additional data processing functionalities. Key Responsibilities: - Modify existing VBA code to create summary reports. - Develop functionality to generate Bar charts, Line graphs, and Pie charts. - Implement additional data processing capabilities including data filtering, sorting, and aggregation. Ideal Skills: - Proficiency in VBA - Experience with Excel and CSV data processing - Strong understanding of data visualization techniques - Ability to create comprehensive summary reports Please note, the final output...
I'm looking for a VBA developer who can create a code for my Microsoft Excel. When I copy/cut a cell, the previous 5 cells should be blocked from being copied/cut as well. This restriction should apply only to the active worksheet. Ideal Skills: - Proficient in VBA programming - Deep understanding of Microsoft Excel - Previous experience in creating Excel macros
I'm looking for an Excel VBA expert who can help me generate financial reports using VBA macros. The final reports should be delivered in Excel format. Key Requirements: - Strong expertise in Excel and VBA - Experience in generating financial reports - Ability to automate report generation process - Delivering final reports in specified Excel format Your bid should reflect your experience and capability to deliver this project on time.
CREATE DATA BASE AND PROJECT WITH POWER BI ANALYSIS PROJECT WILL BE 1 DASHBOARD + 1 VBA CODE TO COLLECT DATA + ANALYSIS REPORT
Multiple analytical works and updating of codes and VBA
I'm looking for a skilled Excel VBA programmer to create a script that will automate the process of copying and pasting data from multiple emails in a specific Outlook folder into an Excel worksheet. Key Requirements: - The VBA code should be able to handle multiple emails, efficiently copying and pasting the relevant data from each. - The code needs to target emails located in a specific folder in Outlook, so familiarity with Outlook's structure and VBA's capabilities in interfacing with it is crucial. - The data from the emails should be pasted into the Excel worksheet in an organized manner. Ideal Skills: - Proven experience with Excel VBA programming - Familiarity with Outlook and its folder structure - Ability to write clean, efficient, and well-...
I'm seeking a skilled Excel VBA programmer to create a macro for me. The primary function of this macro is to send automated email reminders based on due dates in my spreadsheet. Key Requirements: - Automate email Notifications: The macro should send out reminders as deadlines approach, helping me stay on top of my tasks. - Data Validation: The macro should also check for missing data in my Excel file and notify me accordingly. Ideal Skills: - Proficiency in Excel and VBA - Experience with creating macros for email automation Thank you!
I'm in need of a skilled Excel VBA developer to create a macro that transfers numerical data from one Excel workbook to a second one on a daily basis. The macro should be designed to bring over all data from the source workbook. In addition, I would appreciate written instructions on how to recreate the macro in the event of a break. This project requires a clear understanding of Excel, VBA programming, and the ability to write clear and concise instructional material. Must speak good english as best we do a zoom / teams meet to review workbooks.
...Skills and Experience: - High level excel macros and VBA experience is required... Project scope: Prepare a banking Neft challan for bulk transfers and payrolls. 1. A database for vendor banking details ( infinite data feed required) 2. A database for employee banking details (infinite data feed required) 3. A payroll database , ( considering attendance , ESI & PF calculations, Salary advance, other deductions, Allowances, HRA, Salary) 4. Banking NEFT challan for vendor - button for creating print page in A5/A4 data on a company letter head based on data size 5. Banking NEFT challan for Payroll - button for creating print page in A5/A4 data on a company letter head based on data size This needs to be developed using excel macros and VBA. Those who are able...
...and contractors, and support client management. Work independently on tasks such as document creation and organization using G-Suite, Microsoft Office (Word, Excel, PowerPoint). Organization and Reliability: Stay organized, meet deadlines, and provide dependable support with minimal supervision. Additional Expertise (Preferred but not required): Experience with SuiteDash, advanced Excel (e.g., VBA, financial modeling), QuickBooks, Etsy, web design, and graphic design is a plus. Requirements: Language Skills: Excellent verbal and written communication in English. Proficiency in additional languages (e.g., Spanish) is a plus. Tech Skills: Proficient in G-Suite, Microsoft Office, Canva, and social media platforms. Reliable internet connection for seamless communication and ...
I'm looking for an Android-based mobile application to load jobs in our maintenance logbook and a Windows desktop management to manage our maintenance logbook. The database will be a spreadsh...such as issue descriptions, locations (from a dropdown list), their names (from a dropdown list), estimated and actual completion dates (using a date picker), maintainer's names (from a dropdown list), and notes (in a text box). - A checkbox for staff confirming job completion. Ideal skills for this project include: - Mobile application development, specifically for Android - excel development in VBA - Experience with creating user-friendly interfaces - Familiarity with integrating applications with OneDrive - Knowledge in using dropdown lists, date pickers and check buttons in mob...
Hi there - I'll deliver the file as we've discussed by VBA in Excel. Thanks for your trust!
I'm in need of a bot that can take info from an Excel spreadsheet and cross-reference it with another spreadsheet to calculate job pricing. The bot needs to handle: - Mixed data: The spreadsheets will contain both numeric and text data. The bot should notify me by: - Directly updating a new spreadsheet with the calculated job pricing. The bot should perform the tasks: - On-demand: I should ...notify me by: - Directly updating a new spreadsheet with the calculated job pricing. The bot should perform the tasks: - On-demand: I should be able to trigger the calculations whenever needed. Ideal skills for the job include: - Proficiency in Excel and understanding of spreadsheet functions. - Experience in creating automation bots for Excel. - Programming skills, preferably in Python...
I'm looking for a VBA script that will help me manage my schedule more efficiently. The script should take a list of appointments from an attached file and do the following: 1. Insert the appointments into my Outlook calendar according to the specifications in cell B3. 2. Send the appointments to the email addresses listed in column M. The script should be set to run manually, not automatically. I also need assistance deciding on the format for the email notifications. The options are Plain text, HTML, or Rich text. Ideal skills for the job include: - Proficiency in VBA - Experience with Outlook - Knowledge of email formatting Please let me know if you need any further information to give a bid.
Multiple analytical works and updating of codes and VBA
I'm seeking an expert in financial analysis to assess our operational efficiency using historical data. The primary goal of this evaluation is to inform our performance review processes. Key Requirements: - Proficient in Excel, including Excel VBA for complex data manipulation - Experienced in Business Analysis and Data Processing - Able to present findings compellingly using PowerPoint - Skilled in developing pragmatic Business Plans based on the analysis The focus of this project is to evaluate our operational efficiency through specific financial metrics. A deep understanding of performance evaluation techniques is crucial. Please only apply if you can deliver high-quality analysis and clear, actionable insights.
I'm looking for a VBA expert to create an automation script for me. The script needs to perform the following tasks: - Open a SharePoint Excel file (Excel1) from online and copy a specific Excel sheet to my local drive. - In a local file (Excel2), delete 3 specified columns and copy all rows except the header row to the clipboard. - Open another SharePoint Excel file (Excel3) from online and paste the clipboard information. This project requires a deep understanding of VBA and experience with SharePoint PnP PowerShell. Familiarity with Office 365 is also essential since that's the version of Excel I'm using. Please, bid only if you can meet these requirements.
I need a proficient Excel expert who can modify an Excel sheet with macros created by a previous employee. The job entails adding new features, correcting existing issues, and updating the data. Key tasks: - ...proficient Excel expert who can modify an Excel sheet with macros created by a previous employee. The job entails adding new features, correcting existing issues, and updating the data. Key tasks: - Add new calculations and formulas - Set up automated reports - Fix incorrect calculations - Troubleshoot and rectify data updating issues Ideal skills and experience: - Strong proficiency in Excel and VBA - Experience in creating and modifying Excel macros - Ability to set up automated reports - Aptitude for accurate calculations - Problem-solving skills for troubleshooting d...
I'm looking for an experienced Excel VBA developer to create a custom Customer Relationship Management (CRM) add-in for Excel. The add in should provide licence validation similar to XL padlock - https://www.xlspadlock.com. Also when validating the license each time the product is used, it should save the current copy to a cloud based location that can accessed by the user from our website. Each validation should also provide any feature updates from the latest template in a cloud location. Key Features of the CRM Add-in: - Comprehensive Customer Data Management: The add-in should allow for efficient management of customer information, including but not limited to contact details, purchase history, and customer interactions. - Robust Sales Tracking: The add-in should include ...
...construction projects, designed exclusively in Microsoft Excel. The tool must be based on a Work Breakdown Structure (WBS) and include task and activity management, rather than focusing solely on resources. Required Skills: • Expertise in project management (ideally with a PMP certification or equivalent). • Strong proficiency in Microsoft Excel, including advanced formulas, pivot tables, macros, and VBA. • Experience in developing Excel-based tools for complex projects. • Understanding of construction projects and their unique requirements. Expected Deliverables: • A practical and intuitive Excel-based tool that allows: • Budget planning and tracking based on WBS, tasks, and activities. • Monitoring expenses against the budget. •...
Option Explicit Type Authvalinterval Lower_Val As String * 40 Upper_Val As String * 40 End Type Type AUTHVALINTERVAL_TAB wert(1 To 10) As Authvalinterval End Type Type AUTHFIELD_VALS fieldname As String * 10 fieldvals As AUTHVALINTERVAL_TAB End Type Type AUTHORIZATION_TAB AUTHORIZATION(1 To 10) As AUTHFIELD_VALS End Type Type AUTHORIZATION_FOR_OBJECT xuobject As String * 10 AUTHORIZATIONS As AUTHORIZATION_TAB End Type Global IT_ROLE_AUTHS(1 To 100) As AUTHORIZATION_FOR_OBJECT Global sapSystem As Object Global sapFuBa As Object Global sapLogon As Object Global sapConn As Object Global sapReturn As Object Sub RolleAnlegen() Dim wert As Object Dim rolle As Object Dim sapObjekt As Object If InitConnection Then Se...
I'm in need of a proficient Excel VBA developer to create a high-performance data logger for me. The primary function of this tool is to log data from a wireless barcode scanner, record weight, and convert that weight into quantity. Key Requirements: - The logger must access conversion data from a sheet that could have over 200k lines. - A more efficient version is needed compared to an existing sample I have. The current version is sluggish due to file size. - It should support multiple users on a local network, compiling all results into a single sheet without missing any lines. - The project has a fixed budget, which is not based on hourly rates. Ideal Skills and Experience: - Extensive experience with Excel and VBA, particularly in creating userforms. - Previous wo...
I'm seeking an experienced Excel professional to create a comprehensive balance sheet for tracking my business financials. The Excel sheet should include the following financial statements: - Income statement - Cash flow statement - Statement of changes in equity While there are no specific financial metrics or ratios required...my business financials. The Excel sheet should include the following financial statements: - Income statement - Cash flow statement - Statement of changes in equity While there are no specific financial metrics or ratios required at this moment, the ability to easily incorporate them in the future would be a significant advantage. Please ensure the design is user-friendly and intuitive. Excel VBA skills could be beneficial for automating some part...
Excel VBA Macro for Data Capture & Email **Job Title:** Excel VBA Developer Needed for Automated Screenshot and Email Generation Task **Description:** We are seeking an experienced Excel VBA developer to create a macro that automates the following tasks: 1. **Country-Based Data Selection**: - Read a country name selected in one sheet (e.g., "CountrySelection" sheet). - Locate the corresponding row in another sheet (e.g., "Data" sheet) where the country is listed. 2. **Dynamic Data Range Capture**: - Identify the relevant row and its associated columns dynamically. - Capture this data as a screenshot or export it as an image. 3. **Email Integration**: - Embed the screenshot/image into the body of an em...
I'm seeking an experienced Excel professional to create a comprehensive balance sheet for tracking my business financials. The Excel sheet should include the following financial statements: - Income statement - Cash flow statement - Statement of changes in equity While there are no specific financial metrics or ratios required...my business financials. The Excel sheet should include the following financial statements: - Income statement - Cash flow statement - Statement of changes in equity While there are no specific financial metrics or ratios required at this moment, the ability to easily incorporate them in the future would be a significant advantage. Please ensure the design is user-friendly and intuitive. Excel VBA skills could be beneficial for automating some part...
I'm looking for a VBA expert to create a macro that connects data fields from Tab 1 (blue-shaded) to corresponding row columns in Tab 2. The two tabs share the same column/field headers where relevant. Key Requirements: - Create a single button macro that generates a new row in Tab 2, based on inputs from Tab 1. - The macro should prompt for confirmation before updating Tab 2. - All fields in Tab 1 should be completed before the update. - The macro should not overwrite existing rows in Tab 2. Ideal Skills: - Proficient in VBA programming. - Excellent understanding of Excel macros. - Able to create intuitive and user-friendly macros. This project necessitates a professional who can write clean, efficient code and ensure seamless operation of the macro. Please include e...
I'm looking for a skilled Python developer to create a script in PyCharm for me. The script needs to load a CSV file with specific headings: Brand, Product Name, Price, EAN/UPC/ASIN. Key Requirements: - The s...Output: - The final report should include: Brand, Product Name, Price, and Number of Bought Items. Ideal Skills and Experience: - Proficient in Python and familiar with PyCharm. - Prior experience with web scraping, particularly from Amazon, is a big plus. - Understanding of CSV file handling in Python. - Ability to deliver a clean, well-documented script. Issues i have faced while doing this in VBA: - amazon dont like more than 50 pings to their website - i made it stop once it get the error screen - sometimes no item identified , so i just skipped it as its not pr...
I want to list a product using sp-api in VBA. You must have your own credentials for development
I'm looking for an experienced Excel VBA developer to create a macro that will help me automate repetitive tasks, specifically report generation and data consolidation from my inventory data. Key aspects of the project: - The macro should be able to automate the generation of reports from the data - It should also assist in consolidating data efficiently - The macro will primarily be working with inventory data, so understanding of this type of data will be beneficial Ideal skills for this project include: - Proficiency in Excel and experience in creating macros - Strong understanding of inventory data - Ability to automate tasks efficiently - Experience in report generation and data consolidation
I'm seeking a highly skilled Excel professional to help me with an Arabic Excel file. The project primarily involves: - Automating tasks with VBA: I want to streamline our processes, so your VBA expertise will be key to helping us work more efficiently. - Data cleaning and transformation with Power Query: The data we have is not entirely clean, so your experience with Power Query will be vital in preparing our data for analysis. This Excel file is primarily for business use, so a strong understanding of inventory data is beneficial. The ideal candidate will be fluent in Arabic and have extensive experience working with Excel, Power Query, and VBA.
I'm in need of a professional who can help debug our existing VBA program that interfaces with our internal Excel database. The original creator of the program has passed away, and we're currently trying to get it to work without any expertise in VBA. Ideal skills and experience for the job include: - Proficiency in VBA and Excel - Experience in debugging and troubleshooting complex programs - Ability to explain technical concepts in a simple, understandable way - Patience and understanding working with a team with limited technical knowledge
create analysis in power bi and VBA for a company the analysis will include report for weak point and strengths needed to improve prefomance
### Description: I have an Excel file with a scatterplot chart located on the "Graph" sheet. This chart is powered by the worksheet "Calculation" and contains VBA code and ActiveX form controls. I need this functionality replicated online with the following requirements: 1. **Interactive Scatterplot Chart:** - The scatterplot chart should display on a publicly accessible webpage. - Users can interact with dropdowns and selection boxes to customize axes and data shown dynamically. 2. **Multi-User Support:** - Multiple users should be able to access the "Graph" sheet simultaneously. - Each user should have their own settings defined by the dropdowns and selection boxes, without interference with other users' sessions. 3. **B...
I'm looking for an expert in VBA Macro Or Python to create a dynamic script that will inject a specific row of data into my dataset. Dynamic VBA Macro or Python Code To Do the below : Inject a row of data structured as follows Coulmn 1 include a reference number, Column 2 include a company names, Coloumn 3 include prices, Coloumn 4 Include results. Attached Photo show an example, Note the row data are almost 10K Rows.
In Microsoft Access database, I need some VBA to attach 3 forms to 3 SQL queries that already exist. I've started the forms, but they are not complete. Each query requires input from the user. I want the input to be captured on one form with the input fields required. On click of the button causes an Event that triggers the SQL with using the data input from the form. Key Requirements: - User Input: dropdown menus, checkboxes, and text fields. - Dropdown Menus: 3 or more dropdown predefined. - Event Triggering: SQL query using the data input from the form. Skills and Experience: - VBA - Microsoft Access - User-friendly forms - SQL (not required, but could be helpful)
I'm seeking a VBA expert to help me extend my current data collection project. The task involves: - Collecting soccer fixtures from Coral, including odds for home, draw, away, over/under and both teams to score markets. - Integrating this new data into my existing Excel file, which currently collects the same data from two other sports websites. The data from Coral is similar to the other sites, so no special handling is required. The ideal freelancer should have extensive experience with VBA and data collection, as well as a keen attention to detail.
I need an expert in Excel VBA to create a tool for me. Requirements: - Import specific row fields from a CSV file. I need to import Names and Addresses, Product IDs and Descriptions, Dates and Amounts, and other general things. - The import should be triggered by a menu option in the Excel toolbar. - There should be a print button to print the new sheet with the imported contents. Ideal Skills: - Proficiency in Excel VBA. - Experience with CSV file manipulation in Excel. - Ability to create custom toolbar options in Excel.
I'm seeking a professional with extensive experience in MS Access to assist me in creating a robust database. Ideal Skills: - Proficiency in MS Access - Experience in database design and creation - Strong understanding with data analysis, query building This is an urgent task, please bid if you are available to support immediately. Communication in English is must.
I need an Excel macro developed that can extract digital signatures from multiple PDF files and record them in an Excel file. The PDFs I am working with are digital PDFs with selectable text this files are saved in Microsoft one drive. Requirements: - The macro should capture the sign...file. The PDFs I am working with are digital PDFs with selectable text this files are saved in Microsoft one drive. Requirements: - The macro should capture the signer’s name and the time and date of the signature - The data should be organized in Excel with one row per document, and all signatures from that document in separate columns. Ideal Skills and Experience: - Proficient in Excel and VBA programming - Experience with PDF data extraction - Strong attention to detail to ensure accurat...
...an expert in Microsoft 365 with strong skills in Excel, PowerPoint, and VBA programming. My goal is to create a PowerPoint macro that automatically generates a slide for each participant of a course, inserting their name and course date from an Excel file. Project Details: - Software: The project will be conducted using Microsoft 365. - Data Source: The macro will pull data from an Excel file, specifically participant names and course dates. - Template: I have a specific PowerPoint template for the slides; the freelancer will be provided with this template. Key Requirements: - Advanced knowledge of Microsoft 365, particularly PowerPoint and Excel. - Proficiency in creating and implementing macros. - Experience with VBA programming. - Ability to work with provided templa...
I have an Excel macro that needs updating. It currently processes text strings and I need it to add zeros to the beginning of each string to even out their lengths. Ideal skills for this project include: - Proficiency in Excel, particularly with macros - Strong programming skills, preferably in VBA - Experience with data manipulation, specifically with text strings Please bid if you have the relevant experience and can complete this project in a timely manner.
I need a VBA script that pulls historical stock data and option data from Google Finance into Excel. Requirements: - Historical stock data should include Adjusted Close prices. - Option data should include: Strike price and expiry date, Volume and open interest, Implied volatility. Ideal Skills: - Proficiency in VBA - Experience with data extraction from Google Finance - Knowledge of stock and option data parameters Please provide examples of similar projects you've completed. Thank you!
