Visual Basic Jobs

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.

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

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 need a team sheet created/duplicated for my team. I am attaching the document I need created. I need this done in MS Excel and must work in both Windows and Mac. I need the players to be like the top row. Please do not duplicate the school logos. I need the formatting to be correct as well. especially for printing. I also need another item in the box where it has the player information: Intended Major. It can go under the QR in each player box. Our colors are Red, White and Navy Blue. I would like this as soon as possible please.

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!

Excel set with macro for starting a new enterprise Tasks: - Data entry - Data analysis - Data manipulation Ideal skills and experience: - Proficiency in Excel - Strong knowledge of macros and automation - Experience in data entry and analysis Timeline: - Project completion within 1 week

I have some executable file. That´s files contains excel files with macro. I bought a USB to open it but the UBS is down and I dont have any possibility to find another USB. I would like find someone can unlock this files.

Hi there, I’m looking for a freelancer who can help me automate a process involving material part numbers. I need someone who is comfortable and experienced with VBA programming. The list of part numbers that I have is in an Excel spreadsheet, and I’d like the automation to achieve two primary tasks: identify gating items, and then tabulate the results. I’m hoping to find someone who can help make my life a little easier and help me get the job done quickly and efficiently! Thanks in advance for your interest and I look forward to hearing from you.

I am looking for an experienced data entry professional to help with an upcoming project. The primary task is data input, and I have a preference for Microsoft Excel. The data that needs to be entered is basic information, and should not require a high level of complexity. With the right person, this project can be completed quickly and accurately.

Google Finance API programmer required to retrieve data for a list of equities provided in a CSV file. Your program will make requests to the Google Finance API for each equity in the list. Once you have retrieved the data, your code should handle the API responses and parse the data. This parsed data should then be stored in a database for future use. It is important to ensure that the data is stored in a way that is easily accessible and searchable. To ensure that your program is working efficiently, it is important to test it thoroughly and make any necessary adjustments. This will help to ensure that the data is being retrieved accurately and in a timely manner. Overall, with your expertise in the Google Finance API, you can create a program that will retrieve and store data for a li...

I am looking for someone to compare the data between two excel spreadsheets and report all the differences. Specifically, I need someone to compare the numeric values from one sheet to the other where each row is a unique entry. The report should detail all the differences between the spreadsheets. The top 4 rows of the result sheet shows what I am looking to achieve

I am in need of a VBA Excel expert who can assist me with creating custom functions and formulas within a tight deadline of 24 hours. I have detailed specifications for the functions and formulas that need to be created. The ideal freelancer for this project should have strong expertise in VBA Excel programming, with the ability to understand and implement complex requirements accurately and efficiently. They should also have excellent problem-solving skills and attention to detail.

Conversion of xls estimating work sheet to latest excel with some enhancements

I am looking for a freelancer who can automate a task for me. The task involves creating an Excel pivot table based on data from an Excel file. Specific requirements: - The source of the data for the pivot table is an Excel file. - Although I don't have a specific layout or format in mind for the pivot table, I do have some preferences that I would like the freelancer to consider. Its a data set that needs to be created: Previously was a google sheet that used a formula: =RANGETOTABLE(FILTER('Sheet1'!D:J,'Sheet1'!E:E=A2 ),'All Employees'!$D$1:$J$1) A folder needs to be created called Payroll Adjustments Each Excel file needs a name Convention (Country) Payroll (Month you run the file) (year) Skills and experience: - Proficiency in Excel and pivot tab...

I'm looking to hire a Freelancer who can create an invoicing software in Excel or a spreadsheet for a preschool. This software should have advanced features such as generating invoices, tracking payments, automatic reminders, late fees and recurring invoices. I do not need it to be compatible with any external software or systems. I would like the software to provide basic reports such as payments received and outstanding invoices. The software should be easy to use and should incorporate security measures to protect confidential data.

I am looking for a skilled Power BI developer to create a dashboard for me. The project involves the following requirements: Data Sources: - The dashboard should include data from Excel spreadsheets. Design: - I do not have a specific design or layout in mind for the dashboard. I am open to suggestions and ideas from the developer. Visualizations: - I would like to include more than 7 different visualizations or charts in the dashboard. Ideal Skills and Experience: - Proficiency in Power BI and data visualization. - Experience in working with Excel spreadsheets as a data source. - Ability to suggest and implement creative and effective dashboard designs. - Strong understanding of different types of visualizations and their applications. If you have the required skills and experience, ...

I am in need of a skilled vb.net developer who can help me resolve functionality issues with my vb.net application. Specifically, I am experiencing issues with the functionality of my application and need someone who can identify and fix the problem. The issue is occurring consistently, so it may require some troubleshooting to determine the root cause. I am looking for someone who can prioritize this project as urgent and can resolve the issue within a week. Ideal skills and experience for this job include: - Proficiency in vb.net programming - Strong troubleshooting and debugging skills - Experience in resolving functionality issues in vb.net applications - Ability to work under tight deadlines and prioritize urgent tasks

Seeking a skilled MS Access Database Developer to collaborate on enhancing and maintaining an existing MDB/MDE application. Responsibilities include database design, optimization, data management, and user support. Proficiency in SQL, VBA, and strong problem-solving skills are essential. If you have a keen eye for detail and a passion for creating efficient database solutions, we want to hear from you. Requirements: Proven experience in MS Access database development Proficiency in SQL, VBA, and relevant technologies Strong problem-solving and analytical skills Excellent communication and collaboration abilities