Useful vba codes for excelemplois

Looking for an experienced developer with a robust understanding of PHP, JavaScript, HTML, and CSS to build a unique WordPress website. No pre-built themes or visual builders will be used in this project; we are looking for hands-on work to create a custom, one of a kind website. We are switching a pre-built / visual builder theme to a hand coded application and you need to have enough knowledge to create reusuable codes, have php functions called in, and even in your css and responsiveness all codes have to be reusuable and objected oriented for differnet views. Skills and Experience: - excellent communication skills - excellent communication skills - excellent communication skills - Strong knowledge of PHP, JavaScript, HTML, and CSS - Demonstrate...

I am looking for a freelancer with expertise in Excel to type and arrange data precisely as provided. Specifically, here's what you would need to do: - Type text data onto an excel sheet - The data should be inputted in lists - The data should be arranged exactly as provided, not in any specific order Ideal applicants for this task have precision and attention to detail. Mastery of Microsoft Excel is also required to ensure accuracy in typing and data hold. If you take pride in meticulous work, I'd be thrilled to have you on this project.

I need your help to add the names of LLC owners to an Excel spreadsheet. The purpose of this is purely for identification purposes. The names should be sourced from public records and the final file format should be .xls. Ideal Skills & Experience: - Proficiency in Excel and data entry - Understanding of and experience with public records - Attention to detail in accurately transcribing names - Prior experience in legal or administrative data handling is a plus

I want a Power Automate workspace delivered that will ingest multiple images, convert the area specified on the image to columns in Excel. Sample files can be provided

For an upcoming task, I need a detail-oriented worker to parse data from around 400-450 resumes in PDF format into an Excel file. My task requires you to: - Extract specific information from each resume, specifically: contact information, work experience, educational background, and date of birth. - Accurately enter the data into a given Excel template, ensuring no data loss or misplacement. The ideally suited freelancer for this job should have: - Extensive experience with data entry and PDF manipulation - A meticulous eye for detail - A solid understanding of resume contents and structure If you possess these skills, and the task fits your abilities, please demonstrate in your application your relevant experience in similar roles. I look forward to ...

I'm seeking a proficient and detail-oriented freelancer to execute a critical cleanup process on my Excel spreadsheet encompassing 1000 lines of data. This role requires the incumbent to perform the following tasks: - Sorting and filtering Name, Date, Number, Price, and Uber data fields - Identifying and executing operations on specific calculations – particularly focusing on sums The ideal freelancer should possess outstanding Excel literacy and a keen attention to detail. Proficiency in data management with an ability to identify trends, anomalies or data discrepancies is also crucial. Prior experience with similar tasks will give candidates a competitive edge.

Formula Excel max min

I require the creation of an employee database focusing o...fresh graduates with 2-3 years of experience in the Technology and Finance sectors. The database needs to be structured and delivered in an Excel spreadsheet format. It should contain the following information for each candidate: - Name - Education qualifications - Work experience details - Phone number The ideal freelancer for this project should demonstrate strong data entry skills and have a firm grasp of Microsoft Excel. A background in recruiting, HR or a related field, and knowledge about the Technology and Finance industries would be beneficial. Efficiency, meticulous attention to detail and respect for confidential information are also critical for this project. Prior experience ...

... brand, categories, etc.) directly from Excel or CSV files. Integrated Skip Logic and Branching: Utilize advanced conditional logic to guide respondents through customized paths based on their answers. This includes dynamically filtering choices for subsequent questions based on previous responses taking bulk imports into consideration. Question Types: • Invoice Scanning (employing third-party SDK, finalized by Metrix) • Text, Matrix, Drop-downs, MCQ • Would recommend a modular approach for the ease of building additional question type in future. Survey Preview: A visual flowchart or diagram view of the survey logic paths, making complex logic structures easier to understand and manage during the design phase. Panel Management: Offer support fo...

We are looking for a highly trained independent professional with experience in creating WordPress plugins. The project involves developing a plugin that incorporates all the functionalities of the chatbot section of the 'aipower' plugin (you can use the aipower plugin and modify its name to a new one provided by us), to which you must add additional features such as generating iframe codes to each chatbot for the integration of external websites, implement an additional password for bot generation (password that allows blocking only so that the admin can create new bots within the plugin), integrate new APIs such as HeyGem streaming Avatar, allowing HeyGem avatars within the chatbot interface and allowing the use of shortcodes within the bot training ...

I'm looking for a skilled Python programmer to help me clean up and optimize my son's current codebase. The goal of this project is to prepare the codes for direct school admission (DSA) submission Key tasks include: - Cleaning up the code to improve readability and maintainability - Optimizing the code for efficiency and performance - Ensuring the code adheres to best practices in Python programming The ideal candidate for this job will have: - experience with Python and scratch programming - Familiarity with direct school admission requirements

Immediate need for data entry specialist highly proficient in Excel. Your task will involve: - Web research to gather names of colleges, their respective majors and professors. Skills & Experience Required: - Proficiency in Excel and web research. - Accuracy and attention to detail. - Able to deliver high-quality work as soon as possible. Please note, you will only be gathering names, no additional information is needed. Bid now if you are ready to start immediately. So the task is to bring from the internet list of college, major, professor list for the missing one in the application. check the app in app store Professory app

I'm seeking an experienced professional who is proficient in Arabic and English for a data entry project. You will be inputting simple data in Excel form, such as names and addresses. The data is currently stored in digital files. Required Skills: - Proficiency in Arabic and English languages - Experience in Excel data entry - Attention to detail Experience with similar data entry projects before would be ideal. The Task we have an excel sheet which has list of professors for a Kuwait University, and we have images of the updates professor list. We want you add in the table the missing people from the images. Attached the excel sheet and the images. What you will do is, open an image check which major it is, then apply major filter...

Exported shopify product data is in html format. I need to reimport them in a shopify rich text field and need to decode html to shopify rich text format therefore.

I need a skilled professional to update my website's stock prices in real-time using excel. The project primarily involves: - Updating numerical data on my website - Ensuring accuracy and real-time updates - Using excel as the data source Ideal candidates will have: - Experience in data updating on websites - Proficiency in excel and data management - A good understanding of stock prices and real-time data management The goal of this project is to enhance the user experience on my website by providing accurate and real-time stock prices.

a single strategy via Excel so if you're interested then message me

I am keen on acquiring an already developed and deployed puzzle game app, specifically in the genre of match-three games. The app should be available across both iOS and Android platforms. Here are the essentials for this role: - Have developed in the past, or currently manage an active Match-three puzzle game - Proven success with game app published on both iOS and Android stores - Able to transfer complete ownership rights, including codes and proprietary assets - Experience in facilitating a smooth transfer bench to ensure the game's successful navigation Please note, I am only interested in Puzzle game apps with a match-three game type. If you hold the rights to such an app and are willing to sell, kindly send me your proposal. Thank you.

More details: How would you like the PDF files to be named? This question was skipped Are there any specific formatting requirements for the PDF files? This question was skipped How soon do you need your project completed? This question was skipped

I have a garage for which I need permit-ready CAD drawings to convert it into an Accessory Dwelling Unit (ADU). I've sketched out a basic layout that I want to be reflected in the professional drawings. About the Project: - I do have some understanding of the regional regulations about garage to ADU conversions and want the final output to adhere to these rules. - The ADU is intended for renting out, so it should be fully equipped and self-sufficient. Freelancer's Requirements: - Expertise in CAD software - Familiarity with building codes and regulations for ADUs - Experience working on residential projects, especially ADUs - Ability to incorporate my sketches into a permit-ready drawing efficiently and accurately.

I have code for login trading accound and fetch token data. I need to update code I need to collect live data from the web and candle stick,Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. I need an intelligent programmer, who can see future problems and solve them clever and independently. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 600 INR an...

Address labels to be made Over 100 different addresses Font and layout should be all correct Addresses on excel spread sheet Label template will be provided and is on Microsoft word Labels made should not be duplicated

Need a Logo for our New Brand " Travevo " which is going to be a brand for gadgets and tools useful while travelling. I have attached a sample logo for your reference.

Address labels to be made Over 100 different addresses Font and layout should be all correct Addresses on excel spread sheet Label template will be provided and is on Microsoft word Labels made should not be duplicated

The project is an excel test. The attached file contains the test. It requires medium level skills. All the details are in the file More details: What specific calculations do you need to perform in Excel? Formulas to consider using - IF, VLOOKUP, SUMIF, SUMIFS, INDEX How familiar are you with using Excel formulas? Intermediate (comfortable with commonly used formulas) Which Excel features beyond basic formulas are you interested in incorporating? Pivot Tables, Conditional Formatting

This project includes a Version upgrade of the project so that we can deploy it on both PlayStore and App Store, check the Admin dashboard, and upgrade the project there too. - Generate two Qr Codes 1 for the Android app and 2nd for the iOS app. - Change the Light theme from orange color to golden color. - If your iOS account has expired then you'll need to subscribe to membership again. Note: If there are any extra requirements, then cost and time will be discussed separately.

I'm looking for an experienced Java developer to create a simple servlets program using JSP, JAVA, and bare HTML for a school project. The structure should follow a 3-layer architecture with the MVC design pattern. I have already designed the solution, just need some muscles to implement my ideas as I have not much time to do it myself. Key Project Requirements: - Version Control: Git - Database Connection: MySQL - Functionality: User registration and login, product catalog management (store, fetch, and modify products in the database) - Use of Design Patterns: Singleton, Observer, MVC, and any others you feel are necessary Additional Skills and Experience: - JUnit - Netbeans - Password hashing techniques (if time permits, otherwise store passwords as plaintext.) - Exp...

I need an expert in Gnatt timeline design for a crucial project. I am looking to track task dependencies specifically and want to monitor the start and end dates of these tasks closely. Key features I need include: - Task dependencies: I want to set up the timeline in a way that different tasks are linked and the impact of one task's delay on others can be visualized. - Start and End Dates: The timeline should accurately display the start and end dates of each task in a clear and concise manner. I prefer to see these using exact dates rather than color codes or completion percentages. Ideal experience and skills: This project needs someone proficient in project management tools, specifically timeline and task management. Knowledge of task dependencies and milesto...

I'm seeking a highly-skilled freelancer with a deep understanding of Excel for a data entry project. This is not your typical data entry job as it requires knowledge of complex formulas and data manipulation. Key Responsibilities: - Enter data from Excel spreadsheets - Create complex formulas within Excel - Use data manipulation techniques to ensure data integrity Ideal Candidate: - Advanced understanding and experience with Microsoft Excel - Proven experience with complex data entry - Attention to detail is paramount - Strong organizational skills - Ability to meet tight deadlines Join me in this challenging yet rewarding project and let's make a difference together.

I have code for login trading accound and fetch token data. I need to update more details incode I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Automate the buy/sell Trade I need an intelligent programmer, who can see future problems and solve them clever and independently. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term ...

...responsible for performing takeoffs from blueprints and HVAC drawings, as well as producing accurate submittals. Additionally, the candidate will be required to create detailed sketches for various mechanical systems, including but not limited to boiler venting, fire suppression hoods, and more. Responsibilities: - Conduct takeoffs from blueprints and HVAC drawings to accurately estimate costs. - Generate detailed submittals for review and approval by clients and regulatory authorities. - Produce sketches and technical drawings for mechanical systems, including boiler venting, fire suppression hoods, ductwork layouts, etc. - Perform calculations and analysis to ensure mechanical systems meet performance standards and safety regulations. - Stay updated on ind...

I am in search of a capable ...sensor. - With 4 magnetic spots. - Sends specific codes to a digital screen contingent on the number of times the magnetic sensor is activated. - A different number sent to the screen with each magnet. - Functions proficiently in an indoor, climate-controlled environment. The successful candidate must have demonstrated experience in sensor technology, coding and electronics. Strong problem-solving skills and precise attention to functionality and detail are necessary. Knowledge of device sustainability and resilience within a climate-controlled environment is also expected. Again, the device must be capable of transmitting multiple codes based on the frequency of magnetic sensor activation. I look forward to reviewing your tailored proposal ...

Hi, I have 6 excel optimization problems using premade excel model involving costs/profits/promotion. Answers using excel solver. Using an excel model to adjust subcontracting and demand. Note: Need it done within the next 20 hours.

Necesitamos personas que cierren ventas de préstamos de Infonavit. Las comisiones se entregan de 15 a 22 días hábiles después de finalizar un trámite. Ofrecemos: •Trabajo 100% en línea (tú decides cuando trabajas). • 100% Comisionista (tú decides cuanto ganas). • Ganancias previstas desde 8,800$mxn hasta ...100% en línea (tú decides cuando trabajas). • 100% Comisionista (tú decides cuanto ganas). • Ganancias previstas desde 8,800$mxn hasta 44,000$mxn. • Excelente ambiente laboral. Responsabilidades: - Buscar, filtrar y cerrar clientes. Requerimientos: - No se requiere experiencia (nosotros te capacitamos). - Pasión por las ventas. - Habilidad para comunicarse tanto verbal co...

This project involves the modification of the structure in my residential entry room. I need a structural engineer who can deliver a detailed addition plan. Ideally, you have: - Expertise in residential property design and can provide references - Proficiency in creating detailed and actionable architectural plans - Understanding of building codes and structural safety measures - Ability to envision and integrate the new design with existing structures The project's ultimate goal is to modify the current arrangement and structure of my home's entry room. I welcome creative input, provided it aligns with the safety standards and my overall vision. Your previous experience in similar structural modification projects will be greatly preferred.

6 excel optimization problems using premade excel model involving costs/profits/promotion. Answers using excel solver

This take is to take a list of URLS (as in the URLS spreadsheet attached) and create a Power Automate flow to extract the following from each URL: • Previous Close • Open • Bid • Ask • Day’s Range The output should be in a separate spreadsheet (‘output’). In the sample ‘output’ file attached, this shows the result for ‘MMM’. Other URLs will follow. I should be able to run the Power Automate workspace at any point to scan the URLS. The URLS may change (added or removed).

Hello I do sales for a tobacco company and I need to enter all my sales for January February March. I need three different Excel files. All it is is the name of the store the amount that I sold and the address.

...concreto necesitamos: • Automatizar la exportación de datos de facturas emitidas (y su estado, canal de entrada, consultor asignado) y gastos, y preparación de los mismos desde HOLDED. • Automatizar la exportación de datos (presupuestos lanzados y vendidos, potenciales clientes y comerciales asignados) y preparación de los mismos desde HUBSPOT. • Automatizar la cumplimentación Excel de RRHH mediante un Excel que nos pasa la gestoría cada mes, con todos los datos de las nóminas y costes laborables de cada trabajador. *****Importación e integración de todos datos y modelado de un cuadro de mando en Microsoft Power BI con las siguientes funcionalidades:  Facturación Mensual, anual,...

I'm seeking a freelancer with advanced Excel and Power Query proficiency to provide essential data extraction, transformation, cleaning, and combination services for an Excel Report. Qualified candidates must demonstrate: - Advanced understanding of Excel and Power Query - Experience in extracting data from diverse sources - Capability for cleaning and transforming data for optimal utility - Aptitude for combining data from various sheets effectively In your proposal, include details about your relevant experience. Your hands-on experience and proven record of similar projects will secure your success in this job.

I am looking for a proficient professional with expertise in accounting and financial analysis. It would be useful if you can showcase your past work, industry experience, and detailed proposals that will add value to my project. Skills Required: - Strong knowledge in accounting and finance - Ability to provide detailed project proposals - Relevant industry experience and proven past work. If you feel you are the right fit, please reach out and let's discuss how we can work together.

As a busy professional, I'm on the lookout for an Excel pro who can assist in organizing my dataset of less than 1,000 rows. The data is moderately complex, with multiple columns of various types. The ideal freelancer will: - Have experience with Data Entry and Organization. This includes swiftly inputting data and structuring it for optimal accessibility and productivity. - Possess Data Analysis and Reporting Skills. I'm keen on meaningful insights from the data and require straightforward, compelling reports. - Excel proficiency is a must, with strong attention to detail, and ability to handle moderate complexity data. By bringing your advanced Excel management and analysis skills, you'll be delivering order to chaos, and helping drive ...

More details: What specific information do you need to gather for each company? Company name, Contact name, Contact email; Contact phone number; Company website, Gender, Position, Email What information should successful freelancers include in their application? Past work How would you like the database to be organized? Name, Position, Gender, Company, URL, Email, Phone, Notes Project Objective: To create an organized and detailed database, which includes the following columns: Name, Position, Gender, Company, URL, Email, Phone, and notes. Requirements: 1)Research Skills: Ability to conduct thorough online research to find accurate contact information for HR representatives, recruiters, and hiring managers within the specified companies. 2)Attention to Detail: Ensure ...

See the attached File. Simple project here. If any of the words in column A, sheet 2 are in column D, Sheet 1, then delete the entire row (in Sheet 1) (Delete the entire row, not just the cell) No macros Likely conditional formatting, new rule is the best. This will be used on multiple files so it needs to be quickly applied. New words will be added to the list to filter for. The filter list can be added to each new file. No Macros Type :Sponge Bob" in your bid (to sort through the spammers) This should be a very low cost bid and delivered today.

...need of a virtual number script in PHP that can connect to the API to provide virtual numbers. Additionally, I require the script to have the following features: - Call forwarding - SMS forwarding - Virtual number management - Ability to receive activation codes - Option to rent numbers The project will also involve integrating different payment gateways into the script. To be specific, I'm looking to have PayPal, Stripe, paystack, and flutterwave integrated as payment options. The ideal candidate for this project should have: - Proficiency in PHP - Experience with API integration, particularly with - Previous work on call forwarding and SMS forwarding features - Familiarity with payment gateway integration, particularly with PayPal, Stripe, paystack, and

I need an Excel expert who can craft 4 meaningful bar charts to visualize several health metrics. The foremost tasks required would include: - Visualizing perceived health data acquired from various sources namely, self-assessment questionnaires and participant interviews - Converting raw data of percentage changes in health into impactful insights using Excel It's pertinent that the freelancer has a good grasp of Excel and data visualization. A comprehensive understanding of health metrics would be appreciated, but not compulsory. Your role will aid in the better comprehension of health improvement or decline, ultimately guiding decision-making based on these observations.

I am looking for a skilled individual to create 4 bar charts in Excel for the purpose of showcasing percentage changes in perceived health over time. Key requirements: - Using perceived health data, generate 4 bar charts showing changes over time. Ideal Skills: - Proficiency in Excel - Understanding of data visualization - Ability to depict percentage changes in a clear and accessible manner. Please provide examples of your past work in your bid.

I need an Excel file created with text, numbers, and formulas. The data should be organized using rows and columns, across 6-10 tabs/sheets, and include pivot tables. Ideal skills and experience for this project include: - Advanced Excel knowledge - Experience in creating organized and visually appealing Excel files - Proficiency with pivot tables and formulas - Attention to detail and ability to follow specific instructions If you have experience with similar projects and can deliver a well-organized Excel file with the specified features, I'd like to hear from you.

...from an Excel file. The automation should be set up to run on Windows operating system using Power Automate. Requirements: - Automate creation of tasks and subtasks in Microsoft Planner from an Excel file - The automation should trigger based on a specific action, potentially a call, button, or script (vba button Prefered) - The system should be set up to run on Windows Ideal skills and experience include: - Proficiency in Power Automate - Prior experience integrating Microsoft Planner with Excel - Strong understanding of Windows OS and how to set up automation scripts to run on it - Experience creating and managing subtasks in project management software I am looking for someone who can create a reliable and efficient automation system that can sea...

I am in need of a skilled data analyst who can perform a descriptive analysis on my Excel spreadsheets, focusing on understanding trends. Key responsibilities: - Conduct a thorough descriptive analysis on the provided data - Identify and interpret trends within the datasets - Translate the data into actionable insights Ideal skills and experience: - Proficiency in data analysis, particularly descriptive analysis - Excellent working knowledge of Excel and data handling - Strong analytical skills and the ability to interpret data accurately - Prior experience in trend analysis is a plus

...automate email sending through Excel. I have a list of email addresses and the same message to send to all recipients. However, there are certain conditions to consider: Firstly, as shown in the screenshot below, there are checkboxes with options (OUI ou NON) YES or NO. If the checkbox is marked with a "YES", the email will be sent. Otherwise, it will not be sent. Secondly, another condition relates to the frequency of email sending: Once a week Twice a week Once every two weeks Once a month I would like to establish an automated process that takes these conditions into account to send emails according to the specified parameters. Thank you for your assistance in implementing this solution." This version of the message is clearer and more precise, makin...