Visual Basic Jobs

I am looking for a freelancer to create a Lease Excel Calculator for me. The calculator should include calculations for lease payments, interest, and depreciation. Specific calculations needed: - Lease payments - Interest calculations - Depreciation I need to this excel sheet to match the screen shots and calculate the payment to the penny or within a penny based on the information shared in the screen shot. Taxes are captitalized. Formula requirements: - I have a general idea of the formulas needed but need help with the specifics. Type of lease: - I am not sure about the specific type of lease this calculator will be used for and need guidance from the freelancer. Ideal skills and experience for the job: - Advanced knowledge of Excel and formulas - Experience with creating financi...

I am looking for a skilled freelancer to create a macro for me on PC. I require a software application capable of generating simple macros on a PC by analyzing and interpreting images from a video game that I upload to the program you develop. I have specific requirements for each image, for example, press enter, L, space, hold enter 2 seconds and so on. I am looking for someone who can meet these requirements. Ideal Skills and Experience: - Proficiency in creating macros on PC games - Experience with data entry tasks - Scripting Languages: Proficiency in scripting languages like Python, AutoHotKey, or Lua is essential for creating macros. - Image Recognition: Understanding image processing techniques and libraries (such as OpenCV in Python) for recognizing and analyzing images is fund...

Project Description: - I have a working draft spreadsheet that needs to be unified, with everything looking like the ME HVAC sheet. - The project requires adding new data and unifying formulas and formatting. - The preferred format for the data to be added is through manual input. - The client also requires specific features to be added to the spreadsheet, as they have specific features in mind. - The project is estimated to be completed within a maximum of 3 hours. - The completed spreadsheet should be returned to the client by 09:00 London time on 11.12.23. Ideal Skills and Experience: - Proficiency in spreadsheet software, particularly Excel. - Strong knowledge of formatting, formulas, and data manipulation. - Attention to detail and the ability to ensure consistency and accuracy in t...

I am looking for a freelancer who can help me with a project to remove all attendees from all calendar appointments in my Microsoft 365 Outlook calendar. Preferred Method: - I would like to use a script or automation tool to remove the attendees. User Requirements: - This solution is needed for a single user. Additional Details: - I do not need to keep a record of the removed attendees. Ideal Skills and Experience: - Experience with Microsoft 365 Outlook calendar and scripting or automation tools.

Hi, I would like to create an Excel file in VBA for betting, which takes data from a betexplorer. I need the total ranking, home, away of both teams, and the bookmakers' odds of over 1.5-2.5 and goals of the 2 teams. Salve, vorrei creare un file Excel in VBA per le scommesse, che prenda i dati da un betexplorer. Mi servono la classifica totale, casa e trasferta di entrambe le squadre, le quote dei bookmaker superiori a 1,5-2,5 e i gol delle 2 squadre.

I am looking for a freelancer to implement the below project. We have some Stockmarket Software which is written in VB6. Its operation is to exchange trading messages between Client (user of Software) & Server (Stockmarket) via ATHEX Gateway (API protocol (ODL)). ODL API as communication protocol is used in Future Market option so that the member to manage derivatives financial contracts & in Quote Machine option so that market makers to trade stocks, options, indexes by seeing the bid & ask prices of market in real-time & other similar features like min/max spread, theoritical quotes etc... We want to replace the ODL API with Athex Fix Server (Fix 4.4) which will support natively encryption (up to TLS 1.3 & SSL). Also except from Trading Session to support Drop-copy se...

Cuento con macros funcionales en otro libro excel, lo que necesito es traspasar esas macros a un libro excel diferente y adaptar las macros del otro libro a los rangos del nuevo.

Project Title: Gantt Chart Creation Project Duration: - ASAP Specific Milestones and Deadlines: - Yes, I have specific milestones and deadlines Specific Dependencies and Constraints: - Yes, I have specific dependencies or constraints Ideal skills and experience: - Proficiency in Gantt chart creation - Strong project management skills - Ability to work with tight deadlines and deliver results quickly - Experience in identifying and addressing dependencies and constraints in Gantt charts - Excellent communication skills to collaborate with the client and ensure accurate representation of milestones and deadlines

I am in need of a project management timeline with a customizable Gantt chart template in Excel. Features: - Customizable features to suit my specific project needs Skills and Experience: - Proficiency in Excel and creating Gantt charts - Experience in project management and understanding of timeline requirements Plese note, in the timeline doc I wish to have the phases and project week created as it is in the image with all the other characteristics from the timeline 2 and timeline 3 images. Additionally, I would like WBS added as a first column. Please add the tasks I have listed in the images. And please add the Gantt chart cells. Please add a formula that would automatically adjust the Gantt chart cells based on data input. This is a very import need which is why I am askin...

I am looking for a freelancer to implement the below project. We have some Stockmarket Software which is written in VB6. Its operation is to exchange trading messages between Client (user of Software) & Server (Stockmarket) via ATHEX Gateway (API protocol (ODL)). ODL API as communication protocol is used in Future Market option so that the member to manage derivatives financial contracts & in Quote Machine option so that market makers to trade stocks, options, indexes by seeing the bid & ask prices of market in real-time & other similar features like min/max spread, theoritical quotes etc... We want to replace the ODL API with Athex Fix Server (Fix 4.4) which will support natively encryption (up to TLS 1.3 & SSL). Also except from Trading Session to support Drop-copy se...

Require experiences VB6 Visual Basic for Development to Existing Project Thanks Ally

Check attached file before apply the job. I am looking for a freelancer who can help me with a project that involves locking Word files using a macro. I need a new macro to be created specifically for this purpose. The level of security I am looking for is advanced, using macro-based protection. Requirements: - Expertise in creating macros for Word files - Experience in implementing advanced security measures using macros - Familiarity with file locking and password protection techniques in Word - Ability to understand and implement client requirements accurately - Attention to detail and ability to deliver high-quality work If you have the necessary skills and experience, please submit your proposal along with examples of similar projects you have worked on.

I am looking for a freelancer who can create a flow from Outlook to Excel, specifically transferring emails. The data should be formatted in a table in Excel. Furthermore, it is crucial that the data is updated in real time, meaning that any changes in Outlook should immediately reflect in Excel. Ideal Skills and Experience: - Proficiency in Microsoft Outlook and Excel - Experience in creating automated data transfer flows - Knowledge of VBA scripting for Excel macros - Attention to detail to ensure accurate data transfer

I am looking for a freelancer who can create an automated excel spreadsheet for me. The spreadsheet needs to perform advanced calculations using formulas and macros. I have a template or sample spreadsheet that I want the freelancer to follow. The data in the spreadsheet will be updated on a weekly basis. Ideal Skills and Experience: - Advanced knowledge of excel formulas and macros - Experience in creating automated excel spreadsheets - Strong attention to detail and accuracy in calculations Automating dates and cell colours, timelines on spreadsheet

I am looking for a freelancer who can assist me with a Google sheet project involving basic arithmetic calculations. Skills and Experience: - Proficiency in Google Sheets and strong understanding of basic arithmetic formulas - Experience with data manipulation and analysis - Attention to detail and ability to accurately incorporate existing data into the sheet - Knowledge of automation techniques in Google Sheets to create an automated solution Project Requirements: - Incorporate existing data into the Google sheet - Create formulas and calculations for basic arithmetic operations - Automate the Google sheet to perform calculations automatically If you have the necessary skills and experience, please submit your proposal. Thank you!

I am looking for a freelancer who can assist me with formula and function optimization in MS Excel programming. Tasks include: - Analyzing and optimizing formulas and functions for improved efficiency - Streamlining data processing and calculations - Ensuring accurate and reliable results I am not sure if I will require ongoing support or if this will be a one-time project. However, I do have a deadline for the completion of this project, which is within a week. Ideal skills and experience for this job include: - Proficiency in MS Excel programming - Strong knowledge of formulas and functions - Experience in optimizing and automating tasks in Excel - Attention to detail and accuracy in data analysis If you have the necessary skills and can meet the deadline, please submit your prop...

I am looking for an Excel expert who can assist me with formulas and functions. - I have a specific dataset that I need analyzed, so the freelancer will need to work with my data. - The desired outcome I am looking for is clean and organized data. - The ideal candidate for this job should have experience with Excel formulas and functions, as well as data analysis skills.

I am looking for a skilled .Net Developer to assist me with a code optimization task at work. The specific task involves optimizing the code for our project. Ideal Skills and Experience: - Proficiency in .Net development - Strong understanding of code optimization techniques - Previous experience in optimizing .Net applications - Familiarity with debugging tools and techniques The complexity of the task is intermediate, so I am looking for a developer who has experience in handling moderately complex code optimization tasks. Need to figure out the timeout error and the root cause of the issue by debugging it

I am looking for a freelancer to help me create an excel template report that will be used to track machine data on a daily basis. The report will contain sales data, financial data, and inventory data. Requirements: - Proficiency in Excel and data analysis - Experience in creating templates and reports - Ability to understand and implement a specific format for the report - Attention to detail to ensure accurate data entry - Excellent communication skills to discuss the specific format and layout of the report The values in the report will be manually updated on a daily basis. The freelancer will need to create a user-friendly template that allows for easy data entry and manipulation. If you have experience in creating excel templates and reports, and can work with me to implement a sp...

Years ago (Office 2013) we developed a customized Access DB which we had hired a programmer to customize with links to Outlook to sync contact information from one to the other. We upgraded to Office 2019 a few years back and need the links reestablished. We also need to have some reports repaired, and ongoing updates / maintenance provided. A confidentiality agreement will be required of the person chosen.

I am looking for a freelancer who can help me convert a large Excel file (more than 5MB) into an Access database. Presently the file is used as an invoicing system to generate invoices and save information. This is it's primary function. There is additional recording with each invoice showing manufacturing details. Requirements: - The data should be updated in both Excel and Access after conversion. - I need the Access database to have reporting and analysis features. -The file has a few macros which are used to generate PDF invoices and save them to a folder. -I want to ensure I can see the information and use filters in the same way as I can in excel - so we don't need a special form to display the data. Ideal skills and experience: - Strong knowledge and experience in Ex...

I am looking for an experienced freelancer to create an Excel form for me. The purpose of the form is for calculation and analysis. Key Requirements: - Intermediate level of complexity for the calculation and analysis tasks - Ability to create a rough idea format for the Excel form Ideal Skills and Experience: - Proficiency in Excel and advanced knowledge of formulas and functions - Experience in creating custom Excel forms for calculation and analysis purposes - Strong attention to detail and ability to accurately organize and present data If you have the necessary skills and experience, please submit your proposal along with examples of similar projects you have completed.

I am looking for a freelancer who can apply basic arithmetic and statistical formulas to 4-7 Excel formats. I have specific formulas in mind that I would like to be implemented. I am open to suggestions for any additional formulas that could improve the functionality of the formats. Skills and Experience: - Proficiency in Excel and knowledge of basic arithmetic and statistical formulas - Ability to understand and implement specific formulas provided by the client - Strong problem-solving skills to suggest additional formulas for data manipulation and conditional formatting - Attention to detail to accurately apply formulas to multiple Excel formats

Process Management Excel Dashboard - I am looking for an Excel expert to create a process management dashboard that will track specific metrics such as sales, inventory, and customer satisfaction. - The dashboard should provide data visualization through charts and graphs, with the option to include tables if necessary. - As an Excel expert, you should have experience in creating visually appealing and easy-to-understand dashboards that effectively communicate key metrics. - The dashboard should be updated on a regular basis, but the frequency of updates is yet to be determined. - This project requires a strong attention to detail, as accuracy in data representation is crucial for making informed business decisions. - The ideal freelancer should have a strong understanding of process mana...

Partendo da una base dati in txt occorre allocare i vari record all'interno di slot di risorsa seguendo alcune regole di mancata sovrapponibilita e tenendo conto dei vincoli

Software to Automate Invoice Entry with AI Learning I am looking for a skilled software developer to create a solution that automates invoice entry using AI learning. This project is for personal use, and I need the software to have invoice processing as its main feature. Key Requirements: - The software should be able to process and extract relevant information from invoices automatically. - It should have AI learning capabilities to improve accuracy and efficiency over time. - The ability to analyze and generate reports based on the processed invoice data is essential. Subject: Proposal for Implementing Automatic Invoice Entry System with AI Learning An advanced automatic invoice entry system. Project Overview: Our goal is to revolutionize our invoicing workflow by introducing auto...

Brief: We are looking to further develop an online application which needs to provide both ourselves and our clients access to a portal which has separate spaces for each client to log in and complete and update a tracking spreadsheet with information, and then also upload documents/evidence to their own secure area. Description: We have a basic operational tracking spreadsheet that works, but we need it to be able to be send as a link to clients for a fee and a login, or they pay us to manage it for them for a fee. The spreadsheet will capture all the client details against a list of compliance requirements and allows them to answer each item as a question, supported by documentation or statement evidence, which we need to capture and store. The spreadsheet will need to be updated to ass...

Hi i am after way to use ChatGPT to summarise a teams transcript. Process is: Transcript from Team Meeting -> Output to ChatGPT -> Chatgpt summarise meeting and actions -> Places into 4000 word cunks due to limitations -> Processes output to OneNote (if possible) or output to another directory. I am looking for a skilled AI developer to create a tool that can transcribe entire Microsoft Teams meetings using machine learning technology. The main functionality of the AI tool will be to accurately transcribe all the discussions and conversations that take place during the meetings. Key requirements for the project include: - Proficiency in machine learning techniques and algorithms to develop an accurate transcription tool. - Experience working with Microsoft Teams platform ...

I am looking for a freelancer who can create a user form in Excel for me. The form that I need is a data entry form. I have a specific design in mind for the form, so the ideal candidate should be able to replicate that design accurately. The user form should have between 6 to 10 fields for data entry. Skills and experience needed for this project include: - Proficiency in Excel and VBA - Experience in creating user forms - Attention to detail to accurately replicate the design - Ability to create a user-friendly and intuitive form for data entry.

Hello. Im creating one projet with autoit and i have a beginner code. In this code i try to exit from my while. But not working. I have a mul;tiple while, is not easy for me. If u know autoit please pm me.

I am looking for a freelancer who can create a dynamic financial spreadsheet that will help me generate monthly projections for balance sheet, income, and cash flow statements. The ideal candidate should have experience in creating complex spreadsheets with automated calculations and formulas, as well as the ability to input and analyze multiple scenarios. Specific requirements for the project include: - Automated calculations and formulas to generate accurate financial projections - Graphs and charts for visual representation of the data - Compatibility with Microsoft Excel for easy use and sharing As for the financial models or templates to be used, I would like the spreadsheet to be based on industry standards to ensure accuracy and reliability. If you have experience in creating dy...

I am looking for a freelancer who can assist with Excel formatting. The project involves data entry and organization, as well as implementing formulas and functions. The ideal candidate should have experience in visual design and formatting. Specifics: - The client has provided a detailed layout for the formatting. - The project requires formatting of 1-3 Excel sheets. Skills and Experience: - Proficiency in Excel and knowledge of data entry and organization. - Strong understanding of formulas and functions in Excel. - Experience in visual design and formatting in Excel. - Attention to detail and ability to follow a detailed layout. If you are skilled in Excel formatting and can meet these requirements, please submit your proposal.

I have the following string: EACH 12.00 0.00 $19.08 $22.79 $225.4610AIR VALVE - 50MM (AAV)17788P.127.00136 Need a function that 'search's' the string for a 5 digit numeric string. In this case. 17788. It then places 'spaces' either side of the found numeric string: EXAMPLE: EACH 12.00 0.00 $19.08 $22.79 $225.4610AIR VALVE - 50MM (AAV)17788P.127.00136 EACH 12.00 0.00 $19.08 $22.79 $225.4610AIR VALVE - 50MM (AAV) 17788 P.127.00136 EACH 10.00 0.00 $1.48 $1.63 $16.2810DWV F/COLLAR BODY ONLY FEMALE 100MM11666P.102.00339 EACH 10.00 0.00 $1.48 $1.63 $16.2810DWV F/COLLAR BODY ONLY FEMALE 100MM 11666 P.102.00339

Project Title: GOOGLE SHEETS - Formula Creation Description: I am looking for assistance with formula creation in Google Sheets. Specific tasks required: - Creating basic calculations using formulas in Google Sheets Data: - I need help with both collecting the data and working with the data that is already available MAKING A TIME SHEET FOR WORK Ideal Skills and Experience: - Proficiency in Google Sheets and formula creation - Strong understanding of basic calculations in Google Sheets - Attention to detail and accuracy in working with data - Ability to collect and organize data if needed

Project Title: Excel dashboard Description: - I need an Excel dashboard to track sales on defferent parameters and month and month tracker on different parameters - The dashboard should be interactive, allowing me to easily explore and analyze the data. - I prefer a combination of charts and tables in the dashboard format. - The ideal freelancer for this project should have expertise in Excel and data visualization. - Experience in creating interactive dashboards with a combination of charts and tables is a plus. - Attention to detail and the ability to present complex data in a user-friendly manner are essential skills for this job. And VBA including is also added advantage Will connect on remote desktop and explain what I need

Salve a tutti, Cerco un esperto che possa crearmi una macro per automatizzare la creazione di nuove email. Accetto solo Freelancer ITALIANI. Cortesemente SOLO GENTE SERIA. NO PERDITEMPO. Grazie!

Need to develop a very basic desktop application. Need to be done in next 24 hrs. It will hardly take 4-5 hrs to an experinced developer. More details will be provided over chat.

I need make some excel vb in a file I need to add some VBA script in a excel files Thanks

I am looking for a freelancer who can create an Excel dashboard for project management purposes. The data I will be using is of moderate complexity, with some calculations and several variables. I already have a template in mind that I would like to use for this dashboard. Skills and experience needed for this project: - Strong proficiency in Excel and data analysis - Experience in creating project management dashboards - Ability to customize and modify existing templates - Knowledge of complex calculations and formulas in Excel - Attention to detail and ability to organize and present data effectively - Strong communication skills to understand and meet the requirements of the project.

I am looking for someone with excellent Excel skills to help me with a data merge, extraction, and functions project. Here are the details: Data: - The project involves merging and extracting both text and numeric data. Format: - The extracted data should be in Excel format. Sheets: - There are more than 7 sheets involved in the data merge and extraction process. Skills and Experience: - Strong proficiency in Excel, including advanced functions and formulas. - Experience with data merging and extraction. - Attention to detail and accuracy in handling large amounts of data. If you have the necessary skills and experience, please bid on this project.

Hi, I need help with Excel entries and am looking for someone to help me with my project. Specifically, I need help with data entry but I don’t need to modify any existing data. On top of that, I require additional help such as creating reports. The results of this project should be an organized, clean set of Excel entries. This project is urgent, so whoever could help me out ASAP would be greatly appreciated. Thanks!

I am looking for a skilled freelancer to create an order confirmation template in Excel with several dropdown menus. The template should include the following information: - Customer name - Customer address - approx 7 different products - Order details - delivery details - Payment information The complexity level of the dropdown menus needed is advanced. The order confirmation template should be delivered in Excel file format. Ideal skills and experience for this project include: - Advanced proficiency in Excel - Experience in creating complex dropdown menus - Attention to detail to ensure accurate inclusion of customer information and order details

Project Description: I need help with modifying an existing Excel file that requires basic formulas and functions. The complexity level of the tasks is basic. Skills and Experience Required: - Proficiency in Excel and a strong understanding of formulas and functions - Experience in modifying existing Excel files and making necessary changes - Knowledge of basic Excel formatting and design principles

I am looking for an excel expert who can create a dashboard for me on an urgent basis. The dashboard will include financial, sales, and marketing data. Skills and Experience: - Expert in creating excel dashboards - Strong knowledge of financial, sales, and marketing data analysis - Proficient in using excel functions and formulas - Experience in designing visually appealing and user-friendly dashboards - Ability to track and analyze 5-10 metrics or Key Performance Indicators (KPIs) efficiently The dashboard does not need to be updated regularly, so there is no need for daily, weekly, or monthly updates. If you have the required skills and experience, please reach out to me as soon as possible.

Dashboard required for operational data, the raw data is attached with basic info. 1) Column define for day, week, month. 2) need to declare table with info by Product 3) sheet 1 Dashboard and rest in the following sheet Sample attcahed view Job complete review then payment

Hi I have this Google Sheet, https://docs.google.com/spreadsheets/d/1IxqAC4MozcoxQYEADVgYH262fimGbXgNcEiKO45Ap7k/edit#gid=0 , and I would like the function to delete operations at my discretion. The sheet updates itself via Binance API, it does not save my changes and does not allow me to delete operations (each operation is made up of buy and sell, therefore 2 rows). I therefore need to permanently delete operations, and therefore are not displayed, and be careful, I said operations not fixed rows, because as they self-update the values of the operations scale into new rows. If instead I wanted to work with an offline sheet, without the data being synchronized via Binance API, would it be possible to implement a function that eliminates the values ranging from -70% to -inf%, of column I,...

Project Title: Excel dashboard Description: - I need an Excel dashboard to track sales on defferent parameters and month and month tracker on different parameters - The dashboard should be interactive, allowing me to easily explore and analyze the data. - I prefer a combination of charts and tables in the dashboard format. - The ideal freelancer for this project should have expertise in Excel and data visualization. - Experience in creating interactive dashboards with a combination of charts and tables is a plus. - Attention to detail and the ability to present complex data in a user-friendly manner are essential skills for this job. And VBA including is also added advantage Will connect on remote desktop and explain what I need

I am looking for someone with excellent Excel skills to help me with a data merge, extraction, and functions project. Here are the details: Data: - The project involves merging and extracting both text and numeric data. Format: - The extracted data should be in Excel format. Sheets: - There are more than 7 sheets involved in the data merge and extraction process. Skills and Experience: - Strong proficiency in Excel, including advanced functions and formulas. - Experience with data merging and extraction. - Attention to detail and accuracy in handling large amounts of data. If you have the necessary skills and experience, please bid on this project.

Hi I have this Google Sheet, https://docs.google.com/spreadsheets/d/1IxqAC4MozcoxQYEADVgYH262fimGbXgNcEiKO45Ap7k/edit#gid=0 , and I would like the function to delete operations at my discretion. The sheet updates itself via Binance API, it does not save my changes and does not allow me to delete operations (each operation is made up of buy and sell, therefore 2 rows). I therefore need to permanently delete operations, and therefore are not displayed, and be careful, I said operations not fixed rows, because as they self-update the values of the operations scale into new rows. If instead I wanted to work with an offline sheet, without the data being synchronized via Binance API, would it be possible to implement a function that eliminates the values ranging from -70% to -inf%, of column I,...

I am looking for a freelancer to develop a rental software that will primarily focus on invoicing and receipting. The software should be able to generate invoices and receipts for rental transactions. I am currently using Google Sheets for this task, but it is becoming time consuming and tedious as the business expands, I have attached an example of a statement. Key requirements: - The software should have a user-friendly interface and be easy to navigate. - It should have a database to store customer information, rental details, and financial records, along with running balances. - It should be able to distinguish between various properties, with multiple tenants in each and customizable statements, as each property is owned by a different entity and therefore different logos, etc. - T...