Visual Basic Jobs

For my growing customer base of 10-50 clients, I need a competent Excel specialist to design a complex, customer-friendly workbook. - The workbook will need to track and organize three main types of data: Contact Information, Order History, and Communication Log, for each customer separately. - I'm currently unsure whether calculations or formulas will be necessary for any automated tasks within the workbook. This is something that can be explored as the project progresses. The perfect freelancer for this job would have solid experience in Excel, especially in creating complex workbooks. They'd also be able to advise on the use of calculations and formulas. Attention to detail is paramount, as is a commitment to creating a user-friendly layout.

I'm seeking an Excel expert to create a user-friendly data entry workbook. The job is straightforward and requires the following: - **Data Entry:** The workbook should mostly focus on simple data, like names and dates. I am not looking for any intricate calculations, formulas, or pivot tables. The main focus is on creating an Excel workbook that streamlines the process of entering simple data in a structured and efficient way. Experience in creating user-friendly UX within Excel is a plus. No integration with external systems or services is needed - this is a standalone project. I look forward to collaborating with an experienced professional who can deliver an effective, easy-to-use data entry solution within Excel.

I am looking for an expert in Excel to design a dynamic spreadsheet for project tracking. This spreadsheet will focus on monitoring task progress and deadlines. Key Features: - Daily updates: I will be updating task progress and deadlines daily, and so I need the spreadsheet to be user-friendly and efficient. - Task highlighting: If a task is falling behind schedule, I need it to automatically become highlighted in red. This will help me prioritize tasks and ensure no deadlines are missed. - This will need to show throughput for every phase and also provide an average through in volume. Skills and Experience: - Proficient in Excel - Experience in creating dynamic spreadsheets - Understanding of project management principles. I look forward to working with a detail-oriented, reliable ...

In search of a competent Excel specialist adept in Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Access, extensive experience in automation via macros, and strong...

You can see in this google drive folder: I have two spreadsheets: municipalities and duplicates. The duplicate spreadsheet contains all of the records in the municipalities spreadsheet that are considered a duplicate. I don't need any help determining a duplicate, that has already been determined. What I need is for someone to go through the rows in the duplicates sheet, and find those rows in the municipalities sheet, and highlight them. You can see an example of what I mean in the two images attached here. the 'duplicates_examples' image shows a series of duplicate lines, and the municipalities_duplicated image shows those lines highlighted in yellow. That is exactly what I am looking for here - take all of the rows in duplicates sheet, find them in...

I need a reliable freelancer to assist with data input. Here's a breakdown of the project: - **Task:** Your primary job will be to input data from online forms into either Microsoft Excel or Google Sheets. - **Experience Required:** It is necessary for you to have prior experience with both of these tools. This will ensure you're able to work efficiently and accurately. - **Attention to Detail:** Given the nature of the task, it's crucial that you have excellent attention to detail. Even the smallest mistake can have significant implications. If you have the experience and skills mentioned above, I would love to hear from you.

I am experiencing a problematic error with my Excel sheet. An error message keeps popping up and the sheet becomes protected every time I enter a price. Ideally, instead of locking the entire sheet, only specific columns should be locked when a password is triggered by clicking a button. Key issues: - Error message arising upon entering a price - Automatic sheet protection following action Work Required: - Identify and fix the error triggering the message pop-up - Adjust VBA codes to lock specific columns upon password entry: - Columns A to L - Columns Y, Z to AK - Columns CW to DH - Columns DO to DS - Columns DT, DV, DX, DZ, EB, ED For this task, I need a freelancer proficient in VBA and Excel, specifically with experience with sheet protection issues. A thorough understand...

I'm seeking an expert in MS Power Automate, well-versed in implementing unique flows using different AI Chat APIs - particularly Chat GPT API and Cohere AI API. The primary task is to create a power flow capable of running batches of prompts effectively. Key expectations are: - Expertise in MS Power Automate, API integration, and AI-oriented applications. - Background in working with Chat GPT API and Cohere AI API. - Ability to deliver results on a web excel sheet. Please note that an understanding of additional AI Chat APIs is highly valuable for this project.

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.

We have an excel with macro script which converts a PDF (FFE 1a, 2a, 3a) to EXCEL (FFE) that allows us to be able to read all information we need. Unfortunately it is not working due to some changes in PDF (FFE 1b, 2b, 3b) as an extra page in the front has been added, so we are looking to hire someone that can fix this issue, so that excel can ignore this extra page.

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 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 Data" Cloumn B into A11 as a QR Code Need Text Data from "Sheet Data" Cloumn C into G1 as QR Code The data will be manually pasted into "Sheet Data" I need this for 50 Sheets Pages to ignore Coverpage, Inside and Page Breaks Key Requirements: - Ability to generate QR codes in Excel: The end product should be an Excel script or add-in that can create QR codes 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 ...

I'm searching for an experienced programmer who is well versed in both MS Access and Visual Basic. Your Responsibilities: • Assist with MS Access / Visual Basic programming and tutoring sessions • Work without a pressing deadline, allowing us to focus on quality learning and product creation Skills Needed: • An extensive background in programming, specifically with MS Access and Visual Basic • Optimal: Solid understanding of Datanorm and ZUGFeRD • Exceptional patience and communication skills to aid in the tutoring portion of this project. Though there isn't a deadline, we should strive for steady progress. If you're an expert in these areas, I'd love to learn from you. You should solve individual tasks alone, but also with me online using...

I'm seeking a professional who can make an Excel page from a word document and then make it auto organize for our department. This job requires an ability to create a code to organize and automatically count values in certain columns. The code should be designed to recognize and count based on column values. Unfortunately, I'm uncertain about which specific columns should be counted; clarification will be needed later. Key skills would be proficiency in Excel, programming, and an eye for design. Experience in data organization and tracking is a must.

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.

We required to develop some requirements to be done on Excel macro using office 365.

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 seeking an expert in Excel who can help me with three key areas. Tasks include: - Data entry: I have an Excel spreadsheet with around 100-1000 rows and columns that require data input. - Data analysis: Extracting meaningful insights and patterns from the data provided. - Spreadsheet formatting: Ensuring the data is presented in a clear, professional manner which is easy to interpret. Specific functions and formulas required include: - Basic operations like Sum, Average, and Count. - Conditional formatting, to highlight key data points. - Pivot Tables, to present the data in a clear and organized manner. The ideal candidate should have a strong track record in data handling, analysis, and visualization using Excel. Great attention to detail and the ability to stick to deadl...

Create a form in Excel following the pre-determined options. The results of the answers must be recorded in a second tab

I am seeking a skilled coding expert to upgrade the EXIF metadata of my project's images to enhance data integrity. Key tasks include: - Strapping the project onto VB.Net 2019; - Enhancing EXIF metadata features for date, time, location, and camera make & model. - Insert image EXIF data to .jpg, jpeg, bmp, gif, tiff Substantial experience with VB.Net and EXIF metadata manipulation is a must. The objective of this project is to ensure the integrity of data linked with images and as such, potential freelancers should demonstrate a keen understanding of data management and integrity-validation techniques.

I intend to streamline the process of document submission and verification in relation to EDPMS entry and BRC, with a focus on customs or trade-related documents. The ideal candidate will ensure proper documentation is submitted and will run stringent checks for validation purpose. Key Responsibilities: - Submission and verification of customs or trade-related documents - Verification and correction of any errors found in the documents Experience & Skills: - Experience in the customs or trade sector is essential - Proficient in Excel/CSV - Strong attention to detail and high accuracy in document handling - Previous exposure to EDPMS and BRC is advantageous.

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 seeking a skilled professional to create a web application which automates the extraction of simple tables from word documents and the transfer of this data into a macro-enabled Excel sheet. Key Requirements: - Extraction of simple tables from Word documents - Transferring the extracted table data directly to a macro-enabled Excel sheet - Ensuring the data transfer is accurate and error-free Ideal Skills & Experience: - Proficiency in Web App Development - Strong experience in data extraction and manipulation - Proficiency in working with Word and Excel documents - Familiarity with macro-enabled Excel sheets - Attention to detail to ensure data accuracy and error-free transfer The final product should be a user-friendly, efficient, and reliable web application. Please incl...

I'm seeking an experienced video editor to take my YouTube content to the next level. Essential tasks include but are not limited to: - Adding suitable GIFs - Incorporating relevant pictures - Highlighting key words The ideal candidate has a keen eye for details and a knack for improving video content. Please note that the videos are generally less than 5 minutes long. Expertise in captioning, trimming and audio enhancement will also be beneficial. Please share relevant samples of your work along with your proposal.

I want to get a extension which can send messages and images from whatsapp web using numbers and other data from excel sheet

Hola, necesito hacer una base de datos en excel que me permita generar fichas de costos por proyecto con indicadores de rendimiento y que se impriman automáticamente

Utilizing my knowledge of Excel and APIs, I need a freelancer to exceed Power Query's data size limitations. This is to compile a list of 266 pairs from Binance, which will be sent to you. The final output must: - Bypass Power Query's current limitation from 1000 to 2584. - Arrange the pairs in order of their price. Your solution will enable real-time updates of this data in Excel. It would be beneficial if you have previous experience managing API calls and dealing with large data sets in Excel. Proficiency in real-time data extraction and handling is also crucial. need it fast around 2 Hours not more then this, i had the excel to work on just make this on new sheet

I have a presentation that calculates a percentage each time someone makes a sale. I want to be able to change percentages on the fly and still do the calculations. I have attached a PDF version as well as powerpoint to show how it works and can provide the power point file. Ideally there would be an excel function that would calculate each sale. There are three levels of commission. 15, 7, 3 basis points .(0015,.0007,.0003). The sale price is assumed static across all sales (but need to be changeable). For each person (first level) directly under you you will earn .0015 of the sale amount. For each extension (2nd Level) of a person directly under your first level you will earn .0007 of the sale amount. For each third extension (3rd Level) of a person directly under your firs...

I'm looking for a competent developer experienced in automation to help me automate user interactions with a desktop application that lacks an API. this can be done in many of the following ways 1. Robotic Process Automation (RPA) RPA tools like UiPath, Blue Prism, and Automation Anywhere are designed for automating repetitive tasks on desktop and web applications. They can interact with applications at the UI level, mimicking human actions. You can use these tools to automate the login process by recording and replaying login sequences. 2. AutoHotkey (Windows) AutoHotkey is a powerful and flexible scripting language for Windows that allows you to create scripts for automating keystrokes and mouse clicks. You can write a script to focus the application window, enter login credentia...

I am seeking a developer to create a bespoke trading software specifically designed for Windows. The main functionality of this software will be to conduct small calculations on end-of-day (EOD) CSV files of stock data and produce a CSV output. IDEAL SKILLS & EXPERIENCE: - Strong proficiency in Windows software development - Extensive experience in creating trading software - Significant knowledge in stock market operations, specifically EOD data - Superb CSV data manipulation Please note, the specific calculations the software will perform have not been defined. We will discuss this further during the project's execution. Therefore, a flexible and adaptive approach will be beneficial. I look forward to working with someone who can deliver a straightforward, efficient, and u...

I need an expert to code MS Access to perform data analysis and present the results in charts. - Your main task is to implement data visualization features in MS Access. - The desired outcome is a series of charts that will help me understand the data. - You will be responsible for the end-to-end process, from data processing to visual output. Ideal Skills: - Strong proficiency in MS Access and coding within it. - Experience in data visualization, especially using charts. - Ability to understand and translate data into clear, meaningful visuals.

As someone unfamiliar with the specific version of Microsoft excel I'm using, I am seeking a proficient freelancer in handling Excel Automation. To successfully take on this project, you need to demonstrate: 1. Proficiency in Data Entry, Calculation, Analysis and overall Data Manipulation using Excel. 2. Good knowledge across different versions of Excel, since I'm uncertain of the specific version I am currently using. 3. Responsiveness and good communication skills. While the turnaround time for the task isn't defined, I appreciate a quick and efficient service. However, quality should not be compromised. Experience in working across various Excel versions will be an added advantage. I look forward to receiving your bids.

I am on the search for a professional who has proficiency in Excel. The main task of this project involves automating the process of conditional formatting in Excel based on cell content, which can help streamline and simplify my workflow. Skills and Experience Required: - Strong knowledge of Excel functionalities - Experience in automating conditional formatting - Ability to build scripts based on cell content Your expertise will help me ensure that my data is formatted accurately and consistently, saving me time and increasing efficiency. Please place your bid if you possess the necessary skills and experience, and we can discuss further details.

Excel to Invoice Automation System My project involves leveraging Power BI, excel, and macros to automate the invoicing process. I am specifically looking to reduce the manual work that comes with data transfer. Requirements: - Develop a system to automatically generate and track invoices from excel spreadsheets - Implement a robust and error-free data transfer process - The final product should be able to streamline the entire invoicing process Ideal skills and experience: - Deep experience with Power BI, excel and macros - Understanding of finance and invoicing processes - Proven track record in creating automated systems - Strong problem-solving skills, attention to detail. In conclusion, I need someone capable of merging my existing software with a new automated invoicing system. I...

I'm looking for a highly skilled macro coder to assist me with the development of advanced custom macros in Microsoft Excel. This project will require a deep understanding of VBA and prior experience with integrating macros with external databases or APIs. Key Requirements: - Develop advanced custom macros in Microsoft Excel - Implement integration with external databases or APIs - Ensure the macros are efficient, reliable and user-friendly Ideal Skills: - Proficient in VBA (Visual Basic for Applications) - Experience in developing advanced Excel macros - Knowledge in integrating with external databases or APIs I look forward to working with a professional who can deliver high-quality, efficient and effective macros.

need an expert in a multi-project task tracking Gant chart multi suppliers provide document control he must be an expert in MS excel and need to provide a solution for tracking ad document control by excel or another software he is an expert in it we can use later

I'm looking for an Excel VBA expert who'll be prepared to take on challenges on the go, as this listing lacks specific task detail. I rely on you to be innovative and foresee potential tasks such as automating data entry, creating macros, or generating reports. Ideal Skills & Experience: • Proven VBA scripting in the Excel environment • Experience with automation, macros, and report generation • Demonstrable troubleshooting skills In your application, please showcase your past work, how much experience you have, and provide a detailed project proposal. While the specific tasks aren't predefined, your application should reveal your versatility and expertise in VBA scripting. The project's ultimate purpose is unknown, potentially involving the aut...

I have a daily dataset of the prices and funding fees of cryptocurrencies from Binance. I'm seeking an Excel expert to automate the task of calculating the price, funding fee, and percentage of each crypto every day at specific time. - The output should be in a table format for ease of understanding and comparison. Any tool or programming language that can efficiently and accurately perform this task is acceptable. The goal is to create a structured, automated process that can handle this daily task with precision. Ideal Skills and Experience: - Strong Excel skills, especially in formulas and functions. - Prior experience with automation in Excel, macros and VBA programming. - A good understanding of cryptocurrencies and their pricing. - Ability to deliver a clean and user-friend...

In need of a qualified freelancer to automate tasks such as report generation and data manipulation in Excel using advanced VBA. Key Tasks: - Create automated processes in Excel for data manipulation and report generation - Work with Excel data sources exclusively Skills and Experience: - Expert in Excel VBA development - Proficient in the use of advanced Excel functions, including array formulas and 'What-if' analysis - Strong understanding of data handling in Excel The successful candidate will be expected to demonstrate a track record of automating complex tasks in Excel using advanced VBA, and manipulating data accurately and efficiently.

I'm looking for a freelancer who can type up data from an XLS Excel sheet. The data is related to different categories and I want it organized accordingly. Additionally, I would need some basic analysis done on this data; think simple calculations like sum and average. Ideal Skills: - Proficiency in Excel, specifically with XLS files - Experience in data entry - Ability to perform basic calculations Please note: This project doesn't require any complex analysis like pivot tables or charts, just simple arithmetic operations.

Excel to Invoice Automation System My project involves leveraging Power BI, excel, and macros to automate the invoicing process. I am specifically looking to reduce the manual work that comes with data transfer. Requirements: - Develop a system to automatically generate and track invoices from excel spreadsheets - Implement a robust and error-free data transfer process - The final product should be able to streamline the entire invoicing process Ideal skills and experience: - Deep experience with Power BI, excel and macros - Understanding of finance and invoicing processes - Proven track record in creating automated systems - Strong problem-solving skills, attention to detail. In conclusion, I need someone capable of merging my existing software with a new automated invoicing system. I...

I am in need of a proficient VBA and Excel Macros expert to develop a simple, yet efficient invoice/billing application. Key Features: - Generation of invoices from input data. - Tracking and calculation facility for totals. - Maintaining a robust database for customers and invoices generated. Interface Requirements: - The GUI should be straightforward and user-friendly, allowing quick input, management, and retrieval of information. Data Handling: - The application should exploit Excel capabilities for the storage and manipulation of all the data, including customer and invoice records. Ideal Skills & Experience: - VBA and Excel Macros expertise. - Experience in creating user-friendly GUIs in Excel. - Able to develop robust database systems in Excel. - Knowledge of financia...

As a thriving e-commerce platform, our daily operations depend heavily on efficient inventory management. Therefore, we're seeking an expert in Excel to build us an inclusive inventory management template. The template should possess the following specialized features: - Product Categorization: A way of classifying each product for straightforward identification and reference. - Stock Tracking: The prime functionality we're seeking. Notably, it should track items by product name. This will ensure precision in monitoring our inventory and prevent replication or confusion. - Comprehensive SKU Tracking: It should encase a complete and precise representation of our stock movements. Specifically, it should include incoming stock, outgoing stock, and current stock levels. An ideal ...

I'm in need of a freelancer who is skilled in designing both process and workflow flowcharts via Microsoft Visio, as well as project management checklist forms in Excel. The checklist should be of an intermediate level complexity, incorporating features such as drop-downs and validation. Prior experience in constructing Visio flowcharts and Excel forms is imperative to understand the project's need thoroughly. Proficiency in Excel functionalities would make tackling this task comparatively easier.

In this particular project, I require a freelancer with keen MS Access development and design skills. The primary tasks will be: 1. Code Refactoring: I need the existing code of the MS Access project to be analyzed, enhanced, and optimized. You should ensure that code complexities are addressed and improved for better efficiency. 2. Main Menu Design: After improving the code, you will need to revamp the Main Menu. Presently, it provides navigation to different forms, displays relevant information, and initiates the running of queries/reports. I'm aiming for a clean, minimalistic design to make it more user-friendly and efficient. Skill Set: - Advanced knowledge and expertise in MS Access. - Proven experience in code refactoring and menu design. - Strong UI/UX skills, with a good u...

I'm in need of a data handling professional. Gig is $36 Max. I have a large excel file that houses data from multiple sources but the columns are misaligned. I want it to be organized to Name, email, city, state, phone number, additional info columns. Your task will be to: - Correctly align the columns - Merge any duplicate records Ideal freelancer would have: - A strong background in Excel - Experience in data cleaning - Proven track record of handling large datasets - A keen eye for detail to spot and fix misalignments

Looking for an experienced Excel professional who can help debug my university project. I'm currently grappling with project-related issues and need rapid assistance. Expectations include: - Rectifying the project - Delicate understanding of Excel debugging - Fast turnaround time - as soon as possible Ideal candidate should have prior experience with Excel debugging, problem-solving ability, and methodology to correct projects. Knowledge about appropriate data structures will be appreciated. Being a student's project, confidentiality will be highly appreciated.

I need a console application that can sign PDF files. The application should support both electronic and digital signatures. - The application must be developed for Windows. - It should take two parameters: the name of the PDF file to be signed and a token password. - I do not require any logging capabilities within the application. The ideal freelancer for this job should have: - Experience in developing console applications, especially for Windows. - Proficiency in handling PDF files programmatically. - Knowledge of electronic and digital signature methods.

I need an Excel macro developed for my employee training tracking workbook. I want to have a feature that sends email notifications to both the new hire and their manager based on the completion date of each training module. Key Requirements: - Email Trigger: The macro should send emails based on the completion date of each training module, not just the hire date. - Email Recipients: The email notifications should be sent to both the new hire and their manager. - Email Content: The email should include the name and email of the new hire, along with a list of overdue training modules. Ideal Skills and Experience: - Proficient in VBA and Excel: You should have a strong background in developing macros and automating processes within Excel. - Familiarity with Employee Training Systems: Expe...