VBA Program jobs

"I am looking for an experienced programmer to develop a logistics management program with integrated travel services. Key features: Inventory Tracking: The system must efficiently monitor our inventory in real-time, updating stock levels when items are added or sold. I also need assistance with travel-related services. Specifically, I need the system to manage: Travel details: When we load the goods, divide them by type of merchandise, recipient, and number of contracts. Delivery tracking: Keep track of shipments in transit, providing real-time updates on their status. Payment tracking: Indicate whether travel services have been paid for or not, allowing us to monitor outstanding payments."

Hi i-Tech Art , I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I'm new to the Medium Partnership Program and have been creating primarily creative writing content on a monthly basis. I'm looking to significantly increase my program earnings. - Ideal Skills and Experience: - Proven results in earning through Medium Partnership Program - Familiarity with creative writing on Medium Platform - Strategically increasing posting frequency to maximize earnings The objective here is not just to create more content, but to generate higher-earning content. Thus, if you are adept at understanding Medium's algorithms and reader patterns, that's a great benefit. Proven experience in boosting Medium Partnership Program income is a must-have for this project.

I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.

Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical kno...

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.

I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...

I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.

I'm in need of a skilled academic writer who can assist in developing a thesis (skripsi) on Education Research, particularly focusing on Curriculum Development. Requirements: - Knowledge in Education, specifically Elementary and Secondary levels - Skilled in Curriculum Development - Experience in academic writing Your main task will be to: - Create a comprehensive and well-researched thesis on the topic - Use a mixed methods research methodology - Pay attention to detail, ensuring the final product is of high quality and ready for submission. Ideal Skills and Experience: - Proven background in academic writing - Understanding of mixed methods research - Prior knowledge or experience in curriculum development - Education research expertise, especially in Elementary and Secondary ...

I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.

Input:- You will get an excel file as input. Step1- Sort the Excel file by site name and place data in sheet 1 Step2- Sort the Excel file by site address and place the data in sheet 2 Step3- Sort the Excel file by latlong and place the data in sheet 3. After Sorting and creating 3 different sheet, we need to apply the logic to find exact duplicate and high match. Example - means in sort by site name we will find exact duplicate and high match site(75%) match and print exact duplicate/ partial match. Then for exact duplicate and partially match we are going to compare all row and need to print what is matching like site city, site state, site country etc

...The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the give...

Tiktok Fake Recharge Page / Program I am looking for a developer to create a fake recharge for TikTok coins. The project requires mimicking the actual TikTok coin recharge process as closely as possible.

I am looking for an experienced developer to build a program to provide a program that increases the number of live views for both TikTok and Bigo Live. The program should be open source and have option that i can create a password for it and give it to others for specific time. Your application should include: - Detailed account of your experience in this field - Examples of any similar projects Once hired, I would want daily updates on the progress of the project, to ensure all milestones and deliverables are being met within the designated timeline.

As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.

I require a highly specialized freelancer to create a strategic marketing piece aimed to promote a 3rd party Medicare program. This marketing material is to be specifically designed to engage and encourage exploration from working professionals aged 25-65 Key responsibilities: - Developing an appealing marketing design that is aligned with the specifications and ethos of the program. - Ensuring the marketing piece resonates with our targeted audience, the working professionals (25-45). - Creating a marketing piece that not only informs but also convinces the target audience about the benefits of this Medicare program. Ideal candidate: - Proven experience in developing engaging marketing pieces. - Has a strong understanding of the target audience (working professional...

2 excel files with VBA macro as per customer requirement

One excel file with macro as per requirement

I am in need of an experienced AI developer with a strong background in machine learning, specifically in the context of developing algorithms for music programs. Key project details and requirements: - The primary goal of this project is to create an algorithm that can be integrated into a music program. - The algorithm should be able to perform beat detection and analysis, separate the voice from the music, and automatically generate lyrics as the song is played. Ideal candidate should have: - Proven experience in machine learning and AI development, with a specific focus on music-related projects. - Proficiency in developing algorithms for beat detection and analysis. - Skills in voice separation from music in real-time. - Capabilities in natural language processing for lyric g...

I require a comprehensive research on master's degree programs, with a specific focus on the fields of medicine and science. The main objectives of the project are: - Collecting relevant and up-to-date information on different master's degree programs in medicine and science. - Analyzing this data to highlight key features of each program. - Identifying any recent trends in this sector. The ideal freelancer for this job: - Should have experience in academic research and data analysis. - Must possess excellent organizational skills to present the information in an easily understandable format, such as graphs, charts, or clearly labeled spreadsheets. - Familiarity with the education sector or previous work experience related to medicine and science will be preferred.

One excel file with macro as per the customer requirement

I'm currently in dire need of a competent C++ programmer to fix a bug in my existing code. The timeframe is extremely tight and the task must be completed ASAP. Key Requirements: - Strong command of C++ programming language - Experience in debugging and fixing errors in C++ code - Ability to work quickly and efficiently, under tight deadlines Your primary task will be to identify the issue causing the bug and rectify it promptly, ensuring the software runs smoothly. Your understanding of the codebase and the C++ language is crucial in this. Please respond only if you're confident in your ability to deliver high-quality work promptly.

Simple e commerce cart with programs store

Qualitative research of 3000 words about physiotherapy clinical placements, I have already collected the data, 30 references needed. Should be done by 18 april

As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high quality and defect-f...

1. Classes in the package:  MainClass: Will have the main method:  It will control the flow of your program.  It will create an arraylist of patients (only one arraylist should exist in your program)  It will prompt the user to select one of the following options (these options will keep being displayed after each selection until we exit the program): 1. Admit a patient The program will ask if the PCR test result is negative or positive and that will decide what type of patient we have and what information we will ask for. 2. Print patient information It will print all the patient information using the toString Method 3. Submit a PCR test result It will ask for the patient id and update the pcr test value for that patient. Any regular patient who gets a posi...

I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.

I need an Excel...Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creating tools that can handle daily data updates would be ideal. If you have experience with similar projects, please provide example...

I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.

I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.

As the client for this project, I urgently require an expert in VBA.

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.

I'm looking for a professional who can help me set up my video coaching program on Digistore. The program I'm offering is designed for beginners in the subject area. Key requirements for this project include: - Setting up the course on Digistore as a seller - Providing a seamless download experience as the program includes downloadable resources Ideal candidates for this project should: - Have experience in setting up courses on Digistore - Be able to cater to beginner-level audiences - Be able to integrate and manage downloadable resources on the platform.

I'm seeking a capable programmer with expertise in using C and Atmel Studio and a good understanding of Atmel microprocessors. The project involves developing a Simple Program capable of: - Reading analog sensor values - Reading digital input signals - Controlling digital output signals Using a combination of analog and digital inputs and outputs is key to the project, so demonstrated experience in this area is required. Prior knowledge of Arduino would also be beneficial. The right freelancer should be proficient in microprocessors, specifically with Atmel typed ones, and comfortable using both digital and analog inputs and outputs. Familiarity with wireless communication protocols is an added bonus.

We manufacture shade sails which may be 3, 4, 5 or 6 sided shapes, mounted on poles of varying height. These are difficult to measure accurately so we need a measurement verification program where we can input the perimeter measurements of the shape, the pole heights and the diagonals. The program needs to mathematically check the entered measurements and indicate the % of error and which measurement(S) are most likely incorrect. There are two parts to the project: 1. A JavaScript or similar program created to run in an ecommerce website which has a product configurator interface which will be used to input the measurements. The interface will be built by another supplier. 2. A stand-alone app able to run on Android, iOS and Windows PC. ADDITIONAL INFO Th...

I'm looking for a solution to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Dat...based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on generating functional, standard QR codes. - Ease of use: The end-user will be working in Excel, so the implementation should be user-friendly and seamless within the Excel environment. Ideal Skills and Experience: - Proficiency in Excel: A deep understanding of Excel formulas and VBA scripting is essential for this project. - Experience with QR code generation: Prior experience with generating QR codes, especially within Exce...

Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time reporting is key. If you can meet th...

I have a proprietary program that was originally written in C# for Windows and I need a skilled coder to decompile it, incorporate some new features, and recompile it. The new features to be integrated are: - Paint Tool - Erase Tool - Selection Tool - Zoom in and out feature - Ability to resize the software windows The ideal freelancer for this job should have a strong understanding of C# and Windows programming. Proficiency in reverse-engineering and decompiling software is a huge plus. Strong communication skills are essential to ensure that the added features are seamlessly integrated into the software without compromising its functionality.

I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.

I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.

I am looking to develop a specialized program for the PN5180 reader with a focus on reading ID card data. This is a personal project aiming at making ID card management more efficient. The program just need joint with our team and help to code for read data from reade with scan time below 3 second. Reading the mifare ISO 14443 card, using mrz information and APDU command for selecting, reading data Ideal skills and experiences include: - Proficiency in programming the Esp32 platform - Experience with PN5180 reader - A good understanding of ID card reading procedures and requirements. Please ensure to provide relevant examples of your past projects.

Development and Enhancement of Excel VBA Project Tracker.

Description: We require a developer to create a program capable of joining video meeting platforms such as Zoom, Microsoft Teams, and BigBlueButton (BBB), capturing the audio from these meetings, and streaming it to a transcription engine. We prefer the Python programming language for both development and deployment on the AWS cloud. Requirements: Integration with Video Meeting Platforms: The program should connect to popular video meeting platforms including Zoom, Microsoft Teams, and BigBlueButton. It should support joining meetings as a participant and capturing the audio stream from these meetings. Audio Capture: The program must capture audio from the meetings in real-time. Streaming to Transcription Engine: Once the audio is captured, the program shou...

I'm on the lookout for highly skilled Excel VBA developers who can enhance my workbook's functionality and deliver efficient solutions. The scope of this project includes: - Automating data entry procedures to increase efficiency, reduce errors, and ensure accuracy - Designing custom Excel functions for a more streamlined experience - Producing comprehensive reports as per need Key Skills and Experience: - Proficiency in Excel 2013 and Excel 2016 is a must. - Strong knowledge of Excel VBA development - Prior experience with data automation and custom function creation - Expertise in generating powerful reports in Excel I am focused on seeing quantifiable improvements in efficiency and data accuracy through your work. If you have the required skills and experienc...

I need a program developed for a microchip aimed at controlling industrial machinery. - The program should focus on device control, ensuring seamless operation and management of the machinery. - The ideal candidate for this task should be proficient in microcontroller programming, particularly in the context of industrial applications. - Familiarity with industrial machinery and relevant safety standards in this field is highly desirable. - Candidates with a background in device control systems are strongly encouraged to apply.

• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to a...columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Book of T...

I'm in need of a VBA or VSTO developer who can assist with data validation tasks in Excel. You would be responsible for: - Validating numerical and textual data - Organizing validated data in a separate sheet Ideally, you should have experience in working with data validation, especially in Excel. You should also be knowledgeable about building or modifying VBA / VSTO for data validation. Specific criteria for data validation are available and will be provided. Your skills in understanding validation requirements will be instrumental. Familiarity with Excel functions and features is necessary, and proficiency in handling both numerical and text-based data will be of importance. Strong attention to detail will be crucial for successful output.

I need a freelancer well-experienced in VBA to automate the generation of reports for my business, specifically in Gmail. It's critical for this project to be completed as soon as possible, and here are the specific needs: - Develop VBA scripts that will automatically generate and send specified reports. - Must have a deep understanding of Gmail infrastructure in order to correctly implement the automation process. - Must demonstrate a proven track record in completing similar automation tasks. Your expertise in ensuring efficiency and accuracy is important. If you believe you're the perfect candidate and can deliver this project promptly, please reach out.

I'm in need of an expert in SQL and VBA who can assist with a one-time project. The job will entail: - Writing complex SQL queries - Automating tasks in Excel using VBA - Conducting data analysis and generating reports This will be performed on Microsoft SQL Server. As such, considerable experience with this DBMS is a requisite. Primary skills and experience for the role include: - Expert level proficiency in SQL and VBA - Extensive experience with Microsoft SQL Server - Familiarity with automating Excel tasks and data analysis - Previous experience in report generation This is a one-off project with the possibility of future collaborations for similar tasks. If you have the necessary skills and experience, I'd like to hear from you.

...quantities all the time. Requirements: **Data Synchronization**: The connecting should sync data between Excel and WhatsApp in background. - **Automated Messaging**: The Updated data values needed to send automated messages to one contact. These messages will be alerts, and The content of these messages will be generated by data within the Excel sheet. Very Important: Excel Formula/Script/Code/Macro/VBA Function or whatever you can call which is embedded in and compatible with excel. (You have to open the attachment to run a script on it). When the available quantity of a spare part reaches a certain value ( Minimum Stock Value or Less ), An automatic Notification Message including the data of I.N , S.P.D , and A.Q, Will be instantly sent into my what's app Number So I ...