Visual Basic Jobs

I am looking for a VBA expert who can help me automate tasks in Excel. I would like a vba script that looks at a variable number of combinations, considers the ones that have the shortest overall length and then provides the output of the row number. All details in sheet. Comments are required in the VBA script outlining all steps and variables included. it would be preferred if the lookup table (A2:A16) could be made dynamic as this may increase, and also the range C:J.

I need to be able to trend data points by selecting from a drop down list. I would like to select which aspects to trend and graph. A rough example spreadsheet is attached. There would be two drop downs with either being able to select each data point for a given serial or ID and plot points from several dates on individual graphs for trending. I wan to complete this in 1 day.

Hi, I am looking for a freelancer who has great knowlege in creating VBA application for learning platform. I have done 80 percent of databases, forms and coding. I need help in finishing this application by interlinking all in to single form like a web page. Generation of payment tracker and automatic creation of payslips.

I am looking for someone to assist me with basic arithmetic operations in Excel. I have existing data that needs to be used for these calculations. The level of automation required is a one-time calculation. Ideal skills and experience for this project include: - Strong proficiency in Excel and knowledge of basic arithmetic operations - Ability to work with existing data and perform calculations accurately - Attention to detail to ensure accurate results - Experience with creating formulas and macros in Excel

Create bots that will collect events and business in certain cities. Bots should be able to collect and store data on excel sheets.

I am looking for a freelancer who can assist me with automating tasks in Excel. The specific tasks that I need to automate include data entry, formulas and calculations, and data analysis and reporting. For this project, I would like to create quotes using drop-down menus that reference an Excel-database. I do not have a specific template or format in mind for the automated Excel sheets, so I am open to suggestions from the freelancer. The complexity of the data that I will be working with is moderate, with some variables and basic calculations. Ideal skills and experience for this job include: - Advanced knowledge of Excel, including formulas and data analysis - Experience with creating automated Excel sheets and databases - Strong attention to detail to ensure accuracy in the aut...

Add info fields to the existing data base. Add check boxes for info that is needed. Export info that has been inputted into the data base to a microsoft word form. Fix export to excel button that has a bug. Have some type of red flag reminder pop up a week prior to Purchas Orders expiring. A few other changes and additions as they come up.

I am looking for a skilled vb.net developer who can create a function to verify an address using the Google Map API. The purpose of this verification is for form validation. Requirements: - The function should be able to check the accuracy of the address and return a default address if it is invalid. - Any version of vb.net can be used for this project. Skills and experience: - Proficiency in vb.net programming. - Familiarity with the Google Map API and its address verification functionality.

I am in need of a skilled software developer who can create an autofill software specifically for desktop applications. Ideal Skills and Experience: - Proficient in desktop application development - Experience in creating autofill software - Familiarity with form submission and data entry processes - Strong understanding of login credential management The main purpose of this autofill software is to streamline the data entry process and enhance productivity. Key Requirements: - The software should be able to autofill more than 10 fields or forms within desktop applications. - It should be user-friendly and intuitive, providing a seamless autofill experience. If you have the necessary skills and experience in desktop application development and autofill software, I would love to dis...

Stiamo cercando un programmatore che abbia già avuto esperienze con il componente VB/ISAM per la gestione di database. Abbiamo alcuni gestionali per Windows che erano stati sviluppati in quel modo e dobbiamo mettere le mani sui sorgenti per aggiornarli.

I am looking for a freelancer who can create an excel file for me that will help with scheduling meetings. The spreadsheet should be able to schedule meetings based on the responses we receive from clients through a survey. Survey Template: - I already have a specific survey template that I would like to use. Key Parameters for Scheduling: - The spreadsheet should consider the availability of participants when scheduling meetings. Flexibility in Scheduling: - The spreadsheet should be designed to accommodate changes in the meeting schedules and should be editable by me. Ideal Skills and Experience: - Experience with creating customized excel spreadsheets - Strong understanding of scheduling and survey data analysis - Attention to detail and ability to accurately interpret sur...

I am looking to develop an input report generator that can provide invaluable insights to support my business decisions. The input report will contain textual data and numerical data which will calculate the results based on input and generate report, for which I intend to use it for internal analysis. The reports should be delivered in an Excel spreadsheet format, ensuring an easy interpretation of the data received. By having the ability to generate this data in an Excel spreadsheet, I can easily capture and analyze the data collected in order to make well informed decisions in our internal analysis processes. As well as this, I will have accessible data available to me to present to my clients, should I need to do so. This input report generator project is ideal for someone with a s...

I am looking for a freelancer to create a programme dashboard in EXCEL to track financial data. & Project & Portfolio data Management Data with Charts/ Pie Charts Easy to pull from other sheets Skills and Experience: - Proficiency in EXCEL - Experience in creating and designing dashboards - Understanding of financial data and metrics Requirements: - Create a dashboard in EXCEL to track and display financial data - The dashboard should be designed in a user-friendly and visually appealing format - The data on the dashboard should be updated daily Please provide examples of previous dashboard projects you have worked on.

I need someone expert in Excel to show correct number here on Excel that using VBA. More details please chat me.

I am looking for a freelancer who is experienced in Excel and VBA to help with a project involving the condition-based processing of source data. The ideal candidate will have the following skills and experience: - Proficient in Excel and VBA programming - Familiarity with working with Excel spreadsheets - Ability to apply specific conditions to data processing, particularly data transformation - Experience in sorting, filtering, and transforming data in Excel - Ability to understand and work with a sample output provided by the client The project involves processing data from Excel spreadsheets based on specific conditions, with a focus on data transformation. The freelancer should be able to apply the desired conditions to the data processing in order to achieve the desired output form...

Small excel task / vb script to create batch 'Names' and 'Refers To' in the Name Manager section from a table I have provided. Excel Sheet (name manager xls) is attached and provides in table showing each of these and have also added the Excel sheet (Final Call Forward) that these entries need to go into. I have also provided an image with example of where it is and how they are entered. As this is a small task I will offer $35 AUD to complete this.

Hi, I will share my project details in chat box with Only selected candidate. Thanks

Buenas, cuento con macros que interactuan con selenium vba desde excel a una pagina web, lo que quiero es agregar validaciones para evitar errores en caso no encontrar algun elemento de la pagina. la macro transfiere valores desde excel a una pagina web, quiero poder agregar validaciones para que interactue de cierta manera al encontrarse con un caso u otro. todo el codigo es funcional, lo que necesito es modificarlo para agregarle mejoras, optimizaciones. mas detalles inbox.

Hello. I have one small app who i have create with autoit. I start one loop and one GUI On GUI if i click EXIT I don"t exit or other. Any action for all buton Pelase contact ME

I am looking for a freelancer who can help me with a project involving Microsoft Flow and extracting email data to Excel. Skills and Experience: - Proficiency in Microsoft Flow and Excel - Experience working with Outlook email service provider - Strong understanding of email data extraction processes Project Requirements: - Extracting email body information from Outlook emails - Organizing and formatting the extracted data in Excel - Implementing specific formatting requirements for the extracted data in Excel Additional Information: - The ideal candidate should have a strong attention to detail and the ability to accurately extract and organize data from emails. - The extracted data should be clearly formatted and organized in Excel, according to the specific requirements provided. I...

NEED THREE SHEETS Patient Entry Sheet Columns: Patient Name Phone Number Last Visit Date Follow-Up Interval (in days/weeks) Next Appointment Date (automatically calculated) Description/Notes (for treatment notes or other relevant information) Purpose: To enter and store patient details, calculate their next appointment date, and record any notes or treatment descriptions. Today's Call List Sheet Columns: Patient Name Phone Number Next Appointment Date Call Status (checkbox or dropdown for 'Called', 'Not Called', etc.) Description/Notes (pulled from the Patient Entry Sheet) Purpose: To display patients who need to be called today, along with relevant notes. Additional Requirement: If the Call Status is not marked as 'Called', the patient should remain o...

I am looking for a freelancer to improve my Excel spreadsheet by focusing on data analysis and visualization. Skills and Experience: - Proficiency in Excel and advanced knowledge of data analysis techniques - Experience in creating visually appealing charts and graphs to present data - Familiarity with Excel macros and automation - Strong attention to detail and ability to format and design spreadsheets effectively Specific Requirements: - Improve the overall design and formatting of the spreadsheet - Analyze and visualize the data effectively to provide insights and make it easier to understand - Develop macros based on my general idea, but also provide advice and suggestions for additional functions - The spreadsheet consists of 2-5 sheets, so experience working with multiple sheets...

Project Title: Conditional Formatting Formula for 4-7 Data Sheets in Numbers Hello, I am looking for someone to write some formulas for Numbers 10.1 (Mac). Simple formulas as look and highlight duplicates, etc. Thanks

I am looking for someone to assist me in organizing financial data in an Excel sheet. The ideal candidate should have experience in data organization and be proficient in applying simple functions and formulas. Requirements: - Proficiency in Excel and data organization - Knowledge of simple functions and formulas - Attention to detail in organizing financial data - Ability to deliver accurate and well-structured Excel sheets Skills and Experience: - Strong knowledge of Excel and data management - Experience in organizing financial data - Proficiency in applying simple functions and formulas - Attention to detail and accuracy in data organization If you have the necessary skills and experience, please bid on this project.

program ini untuk menghitung dan menggambarkan berapa banyak lembar hasil yang didapat dari lembar yang lebih besar

Hi Freelancer, I am an Australian based mortgage broker and I am seeking the expertise of an excel wizard. I am hoping to build a customisable spreadsheet to show my customers the estimated costs of purchasing a property in Australia. I have already built a number of these spreadsheets, that will form the foundation of your work, but I want to consolidate these into 1 customisable spreadsheet that the customer can input their unique numbers to give them a customised result. I envision this spreadsheet to have 2 tabs, tab 1 will be the landing page which will be branded to match my business and tab 2 will have the data. Tab 1 will include a “how to guide” on how to input their numbers on tab 2. Tab 1 will also include a “call to action” button that will link to...

We have a project management system set up in Google Sheets. We are looking at moving from Google to Microsoft and need to re-create the sheets and templates in Excel. The system is pretty simple. There is a Master Sheet that contains rows of clients with links to a job specifice sheet of each client. The job specific sheet then links to document templates and external links for the tasks involved in implementing the client file. When a new job is created the system copies templates and precedent documents into a client specific folder.

I am seeking an Excel Macro Expert who can assist me with creating advanced custom formulas. The ideal candidate should have experience in developing complex formulas in Excel. This project does not have a strict deadline, as the timeframe is flexible. Skills and Experience Required: - Proficiency in Excel macros and VBA programming - Strong understanding of advanced formulas in Excel - Ability to automate data entry and generate reports using Excel macros - Attention to detail and ability to deliver accurate and efficient solutions

I am looking for a freelancer who can help me with reverse engineering a database file (*.dat) and converting it to an Excel file (*.xlsx). The purpose of this project is data recovery, as all fields in the database file are equally important. Skills and experience required: - Proficiency in reverse engineering and data recovery from database files - Strong knowledge of Excel and data conversion - Attention to detail to ensure accurate conversion of all fields from the database file to the Excel file If you have experience in reverse engineering database files and converting them to Excel, please submit your proposal. We then need the procedure/tool to be able to solve it permanently ourselves.

Excel and Notion Trainer Skills and Experience: - Strong proficiency in Excel, especially in formulas and functions - Experience in training and teaching beginners in Excel - Familiarity with Notion's standalone functions Project Overview: We are looking for an Excel and Notion trainer who specializes in teaching beginners in Excel and has a strong understanding of formulas and functions. The ideal candidate should be able to provide comprehensive training on these specific features of Excel. The main focus of the training will be on teaching the client how to use formulas and functions in Excel. The trainer should have a solid understanding of different types of formulas and functions and be able to explain them in a clear and concise manner. In addition to Excel training, the cl...

Hello, i want use my button who i have make with KODA and for exemple if i click on "yes button ": - Return message "Hello" I use autoit and im beginner. Thank you to help me

Below is my current code (ASYNC FUNCTION) that does not work ! Response always false ! Public Async Function UploadImageAsync(imagePath As String, altText As String) As Task Using client As New HttpClient() Dim usec As String = Para(Val(TermNumber), 483) 'for testing hard code para 483 usec = "|ck_key |cs_key" If DatabaseUSE = 2 Then usec = Para(Val(TermNumber), 535) End If If DatabaseUSE = 3 Then usec = Para(Val(TermNumber), 601) 'shopify info End If If InStr(usec, "|") = 0 Then Exit Function End If Dim keysN() As String = Split(usec, "|") keysN(0) = LCase(keysN(0)) Dim myString As String = keys...

Buenas, ocupo soporte para un programa en clipper de VISUAL FOX PRO

I am looking for an expert in Vlookup to help me merging two sheets. I have an existing dataset that I need to work with. The task needs to be completed within 24 hours. Skills and Experience: - Proficiency in Excel and Vlookup formulas - Experience in creating Vlookup formulas - Strong attention to detail and accuracy in data analysis

Need to execute a excel vba file thru wordpress

Design an excel template. I need to create an professional and attractive template in excel. More details will be provided to shortlist candidate only. Write template in your proposal.

I am looking for a freelancer who can create an automatic email reminder system in Excel to remind about project deadlines. The ideal candidate should have experience in Excel and be proficient in creating automated systems. The email reminders should include the project deadline as well as additional details and next steps. This will help keep all team members informed and on track. The email reminders should be sent 3 days before the due date. This will give team members enough time to complete their tasks without feeling overwhelmed. Overall, I am looking for a freelancer who can create a simple and efficient automatic email reminder system in Excel. This system will help ensure that all project deadlines are met and that everyone is on the same page.

I am looking for a freelancer who can create a macro dashboard to track sales data on a daily basis. The ideal candidate should have experience in handling and analyzing sales data to provide accurate and real-time updates. Skills and Experience: - Proficiency in data visualization tools such as Tableau or Power BI - Strong understanding of sales metrics and KPIs - Ability to create interactive and user-friendly dashboards - Experience in data analysis and reporting - Attention to detail and ability to identify trends and patterns in data The main focus of the dashboard will be to track customer acquisition cost, as this metric is crucial for our business. However, it would also be beneficial to include other important metrics such as revenue and profit margin. Overall, the goal is to ...

I am looking for a freelancer who can create a macro dashboard to track sales data on a daily basis. The ideal candidate should have experience in handling and analyzing sales data to provide accurate and real-time updates. Skills and Experience: - Proficiency in data visualization tools such as Tableau or Power BI - Strong understanding of sales metrics and KPIs - Ability to create interactive and user-friendly dashboards - Experience in data analysis and reporting - Attention to detail and ability to identify trends and patterns in data The main focus of the dashboard will be to track customer acquisition cost, as this metric is crucial for our business. However, it would also be beneficial to include other important metrics such as revenue and profit margin. Overall, the goal is to ...

Hello, I have one code on autoit. I try to exit one loop but is not working It's one easy problem, please contact me. TY

I am in need of a PowerBI expert who can assist me with report/dashboard creation. I already have all the required data prepared for the dashboard and the intended use for the dashboard is internal business decisions. Skills and experience required for this project: - Proficiency in PowerBI - Strong data modeling and visualization skills - Experience in creating interactive and visually appealing reports/dashboards - Ability to analyze data and provide insights for internal business decisions - Data source will be on Excel sheets it's required to keep adding up according to the new sheet uploads

I am looking for an Excel VBA expert who can assist me with the following tasks: - Creating a CV based on an excel sheet - Data analysis and reporting - Automation of repetitive tasks - Creating custom functions and formulas The successful freelancer should have experience in Excel VBA and be able to provide examples of their past work. I am looking for someone who can complete the project within a week.

I am looking for a freelancer who can make my Excel spreadsheet more automated. Here are the details of the project: Tasks: - The automated Excel should be able to perform data entry and calculations efficiently. - It should be able to handle complex calculations and formulas accurately. Sample file: - I have a sample file that I would like to use as a reference for the automated Excel. - The freelancer should be able to work with this sample file and make the necessary adjustments and improvements. Deadline: - There is no specific deadline for this project. - The freelancer can work at their own pace and deliver the completed project when it is ready. Ideal skills and experience: - Proficiency in Excel and its advanced features, such as formulas, macros, and VBA. - Experience in autom...

I am in need of a skilled VBA developer who can assist me in creating a tool that will automate the process of extracting certain details from Outlook emails (Actual email platform we use is PrivateEmail but we login via outlook IMAP protocol) and organizing them in a specific format on an Excel sheet. Requirements: - Experience working with VBA and Excel automation - Ability to extract the date from the email subject and cost information from the email body content - Understanding of structuring data in a specific format in Excel We will only accept candidates with prior experience in developing VBA code for similar automation tasks and will be able to efficiently extract the required details from the emails and structure them in the specified format on an Excel sheet.

In Excel, data typing refers to specifying the type of data that a cell contains. The main data types in Excel are: 1. **Text:** Used for alphanumeric characters, including letters, numbers, and symbols. - To enter text, simply start typing in a cell. 2. **Number:** Used for numeric values. - Enter numbers directly into cells. 3. **Date/Time:** Used for date and time values. - Enter dates or times in recognized formats, or use Excel functions for specific date and time calculations. 4. **Currency:** Similar to the Number type but with a predefined currency format. - You can format cells as currency to display values with currency symbols and appropriate number formatting. 5. **Percentage:** Used for percentage values. - Enter the number followed by the percentage sign (...

VBA coder needed for small-scale project in Chennai Skills and Experience: - Expertise in VBA coding - Strong knowledge of Excel and other Microsoft Office applications - Experience with data manipulation, automation, and creating macros - Familiarity with Chennai's business environment and practices Timeline: - Hourly basis, depending on the project query Location: - Chennai-and bangalore based coder preferred

Data consolidation using excel invoices and pdf reports. Only bid if you can start work right away. More details will be provided to selected candidates.

Create one excel with macros to validate data other excels based on different rules. Please find attached screenshot for the same. First excels should have buttons and option to upload other excels. Demonstration available.

Tengo un excel hecho para hacer dietas y necesito ayuda para acabarlo. Necesito poder hacer búsquedas en tablas relacionadas y mediante filtros seleccionar diferentes menús. Además, estas categorías están diferenciadas por colores y necesito que se cambie de color la celda. Por último, necesito guardar todos los movimientos en formato base de datos para visualizar un gráfico de seguimiento.

See attached spreadsheet Be able to select from the drop down box ( from one area at a time only) across all three of the following tabs ( including the Title, Access and Total Hours):- i. Mandatory Education ii. Role Requisite iii. Cont Prof Learning To populate into the REF Template tab – is it possible to have it populate under the different titles creating a new row each time. I.e REF TEMPLATE TAB: - Staff Mandatory Education Once only F2F SCHHS Orientation F2F / LOL 2.50 SCHHS Staff Local Induction F2F 8.00 Aboriginal & Torres Strait Islander Cultural Practice Program F2F / LOL 6.00 In this example it would only have been for area 3C TRAINING ACCESS TOTAL HRS 3A 3B - COVID WARD 3C ALL STAFF MANDATORY ED...