Visual Basic Jobs

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.

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.

I am looking for an Excel VBA expert who can assist me with data analysis. The specific task involves analyzing simple data with few variables. I have a preferred method of analysis in mind and would appreciate someone who has experience in implementing this method. The ideal candidate should have expertise in Excel VBA programming, as well as a strong background in data analysis. Additionally, experience with creating custom functions and automating repetitive tasks in Excel would be beneficial. I will do a quick call for more information.

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...

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

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.

I am looking for a VBA expert to help with my Excel data management project. The main tasks that I need the VBA code to perform are automating repetitive tasks. The size of the data set that the VBA code will be handling is small, with less than 1000 rows. Additionally, I need the VBA code to interact with other Microsoft Office applications. Ideal skills and experience for this job include: - Strong proficiency in VBA programming - Experience in automating tasks in Excel - Familiarity with data entry and validation - Knowledge of data analysis and reporting - Understanding of Microsoft Office applications and their integration capabilities

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.

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...

This is a SUPER SIMPLE fix for an experienced VB developer. I have a VP app that downloads photos from a website. It recently stopped working. A few lines of code changes should fix it. To be considered please answer these questions in detail: 1) What is your experience with VB and VB.net? 2) Can you fix this now? 3) How is your written English from 1 to 10 (with 10 being fluent)? 4) How is your spoken English from 1 to 10 (with 10 being fluent)? *** You will only get a reply if you have answered the above questions ***

I am looking for a freelancer to create a customized Excel invoice template for my company. The ideal candidate should have experience in creating visually appealing templates with company branding. Requirements: - Customized invoice template with company branding - Additional features like automatic calculations and tax adjustments - Advanced information included in the invoice such as payment terms, late fees, and notes Skills and Experience: - Proficiency in Excel and experience in creating customized templates - Knowledge of advanced Excel functions for automatic calculations - Familiarity with tax adjustment formulas - Attention to detail and ability to create visually appealing designs with company branding If you have the skills and experience required for this project, please su...

I have 500 txt files with line breaks in contents. Attached is a sample file. To automate: select A1 cell with double cell then paste the contents on txt file. In 500 rows, each row 1 text file. the excel row must look ditto as in txt file i.e with n, etc. To deliver code so that i can use it again.

Project Title: Google Sheet Automation I am looking for a freelancer who can automate data entry tasks in Google Sheets. The specific tasks that need to be automated are very simple entries. Workflow: - I have a detailed workflow that the automation needs to follow. Skills and Experience: - Strong experience in automating tasks in Google Sheets - Proficient in formulas and calculations in Google Sheets - Familiarity with data analysis in Google Sheets If you have the skills and experience required for this project, please submit your proposal.

Project Title: Daily Purchase and Sale Tracking Tool I am looking for a freelancer to help me develop a tool that can track my daily purchases and sales on a lot basis. The tool should have the following features: - Input daily purchases and sales with lot basis - Printable format for easy record keeping - Capture item name, purchase quantity, and creditor name - Track sales quantity against the purchases - Generate detailed reports for analysis and record keeping Ideal Skills and Experience: - Proficiency in software development - Experience in creating tools for tracking purchases and sales - Knowledge of generating reports and analytics - Attention to detail for accurate record keeping Please note that I currently do not use any specific software or tool for tracking my purchases a...

I am looking for an Excel expert who can assist me with formula creation. I have a general idea of the calculations I need, but I will need some guidance. The complexity level of the formula is basic. Skills and experience required for this project include: - Proficiency in Excel and formula creation - Strong understanding of basic calculations and functions - Ability to provide guidance and recommendations for formula creation

I am looking for a Tableau expert to create a visually appealing and interactive dashboard using an Excel dataset. The ideal candidate for this project should have experience in data visualization and proficiency in Tableau. Visualization Preferences: - The type of visualizations preferred for this project include bar charts, line charts, and pie charts. Color Preferences: - The client has given the freedom to the freelancer to decide on the color scheme for the dashboard. Tabs or Sheets: - The Tableau dashboard should consist of 4-7 sheets or tabs to effectively present the data. Skills and Experience: - Proficiency in Tableau and experience in creating interactive dashboards. - Strong understanding of data visualization principles and best practices. - Ability to translate complex da...

I recently ran into a problem where an important file was saved over in Excel, and I need it restored. The original format of the file was .xlsx, and unfortunately, no backup was made before it was saved over. I'm not sure if I have a version of Excel that supports file recovery, so I'm hoping to find someone who can help me with this issue. If you have experience with file recovery in Excel and can help me restore the file, I'd love to hear from you. Thanks in advance!

Hello, I have a list of details, using those you need to collect a lot of data from a specific website. I will show you how to scrape the details like Name, Email, and Phone numbers, you just need to follow the pattern..

Not so much of a project, but a relatively simple task for an experienced Microsoft Word geek. I have two Microsoft files. v1 was created and saved after 5mins in April this year. Unfortunately, it does not contain some final drafting that was lost when I clicked the wrong button at the time. v2 of the document is a simple cut-n-paste of the original with corrected 2nd bullet (highlighted) My Ask/Request Update to the original v1 document with the 2nd bullet replaced with (v2 Bullet 2) without changing the original Properties. OR the v2 document (as is, no change to document content) but showing the original document properties (last modified & created) see attached Word file called Document Properties. The final Word document - whichever approach (above) is taken needs to have h...