Cell address based vlookup result macro excel jobs

... - **File Format**: The directory should be in Excel (.xlsx) and easily editable. - **Data Required**: The spreadsheet should include Business Name, Address, Phone Number, Email (if available), and any other relevant contact details. - **Usage**: I'll be using this directory for sales lead generation, so it's crucial that all the information is up-to-date and well-organized. - **Categorization**: The businesses should be categorized by specific industry (e.g., Hospitality, Retail) to help with targeted marketing efforts. I would like this done for the retail/hospitality e.g. butchers, newsagents, cafes, and convenience stores. We are not targeting large chains or franchisees. **Ideal Freelancer**: - **Excel Expert**: Proficiency in Excel is a mu...

Please Sign Up or Login to see details.

I need an experienced professional to visit Usiminas in Brazil for the purpose of verifying a previous employment certificate. This involves: - Confirming the work experience stated. - Validating the job title and responsibilities provided. - Ensuring the employment dates align with what's recorded. Targeted Address for Visit: Usiminas, Ipatinga - State of Minas Gerais, Brazil Issuing Authority Name :Usiminas Brazil Task : Verify the provided document by form filling and get geo-tagged pictures Please note, you'll only be authenticating one certificate. A background in HR, employment screening, or due diligence would be helpful for this project. Strong attention to detail is essential, alongside fluency in Portuguese and English. Familiarity with Brazilian business ...

...plan. Based on the information you provided, the scope of services will include the following: Architectural Plans: This includes the site plan, floor plan, elevation plan,and structural engineering calculations. Basic Services: I will confirm the design criteria and provide the necessary drawings based on the basic drawing you sent me. If there are any issues with the submitted drawing and modifications need to be made, I will be responsible for revising the drawing until a full set of plans is approved. As part of my commitment to providing you with the best service, I will send you daily reports to keep you updated on the progress of the project. However, please note that I am not available 24/7. I suggest we set a specific time for our communication to ensure that I ...

I'm looking for an experienced data scraper. I need someone with excellent knowledge and expertise in web scraping. I will need the following with regards to mid sized collectible stores around the world: Company Name City Country URL Contact person Email address. Ongoing work for the right candidate/s

As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.

I'm in need of an Excel formula expert to help me with a specific task. I need a formula that will COUNT cells based on the following criteria: - I need to COUNT the number of cells in a range that are greater than -250 - The count should be done for the last 50 cells (ongoing) Your task will be to help me create a formula that dynamically counts the number of cells based on the above criteria. I need this formula to be able to adjust as new values are added to the range. The ideal Freelancer for this project should have: - Extensive experience with Excel functions and formulas - Strong understanding of dynamic range referencing in Excel - Excellent communication skills to explain the logic behind the formula in layman's terms Please includ...

note added April 18th: Please use the blue and orange color from the existing page, because that are my CI colors. In need of a website redesign using Wordpress for www.consulmedics.de. I am seeking a freelancer who can deliver a fresh, modern redesign without losing the professional and formal tone of the existing site. Users of my site are medical doctors, so I need a high-quality result. The project will mainly focus on the pages that I have already in my website now. Additional I need a page containing a mondern/nice looking map of Germany with cities where located our offices are pinned in a nice looking way. We have 3 offices. You should use the same text as we have now. note added April 18th: Please use the blue and orange color from the existing page, because that ar...

I'm looking for a seasoned web developer to help me create a parent portal for a childcare booking system. This web-based application should effectively and efficiently allow parents to manage their bookings and communicate with the childcare staff. Key Features: - Online Booking: Parents should be able to make, alter, and cancel their bookings with ease. - Parent-Staff Communication: A communication portal that allows parents to directly liaise with the childcare staff. Skills and Experience: - Expertise in web-based application development. - A strong track record of creating user-friendly platforms. - Previous experience with booking systems or parent portal apps, a plus. --written in python

I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of this project req...

I am seeking an experienced Python professional to develop a system that can accurately detect fake invoices. The aim is to prevent financial losses and enhance security. Need to detect a submitted computer generated receipt in pdf if it is a tampered or real one. There are chances like in the computer generated bill some people can change the amount, name, address sections and submit. This model should able to detect all those tampered PDFs with minimum false positives. Do metadata analysis QR code reading in the receipt and validation Key Responsibilities: - Develop a fraud detection algorithm using Python. - Test and tune the model for maximum accuracy. Ideal Experience and Skills: - Proficient in Python programming. - Proven experience in creating algorithms, preferably ...

2 excel files with VBA macro as per customer requirement

...paper usually you will find 50 papers. and i want him/her to make a table highlighting the compares. Please note that completion is needed ASAP. Your prompt attention and quick work turnaround will be highly appreciated. Research Report 1. Title: [Insert your research title here] 2. Names: [Insert author names here] 3. Department: [Insert department name here] 4. Email: [Insert email address here] 5. Abstract (9-10 lines): Research area: Briefly explain the area your research focuses on. Problems: Identify the key problems existing in the research area. Solutions: Briefly mention the solutions your research proposes. 6. Introduction (20 lines): General overview: Provide a broader introduction to your research topic. References: Include at least 5 relevant references. ...

One excel file with macro as per requirement

I need an expert in Microsoft Excel to build an efficient spreadsheet to monitor potential lost revenue due to late service deliveries. The ideal candidate would possess a strong background in creating financial models and understanding of revenue tracking. Key Requirements: - Proficient in Microsoft Excel, with emphasis on creating advanced, clear, and highly-functional spreadsheets. - Experience in financial modelling and understanding of revenue tracking. - Ability to automate the process as much as possible to minimize manual tracking. Objective: - Create an intuitive and efficient Excel spreadsheet to replace the current manual method of tracking potential lost revenue due to late service. Skills Needed: - Microsoft Excel - Financial modelling - Adv...

I need an experienced freelancer able to carry out a large-scale sheetrock project. Key tasks include: - Installation of sheetrock across an entire floor - Taping and mudding for a well-leveled and solid construction The final result should have a smooth finish, providing a clean, modern look to the renovated space. The ideal professional for this project has experience in large-scale installations and creating smooth sheetrock finishes. You should be detail-oriented, ensuring a high quality and uniform finish across all rooms.

...Zoho Creator, as well as application design, to develop an application based on this platform. Key Features: - Internal Business Process Application - Data Management: The app needs a strong data management feature, allowing for efficient organization and retrieval of information. - Workflow Automation: Automatically streamline tasks and workflows to increase efficiency. - Customization Options: Enable customization to cater to various needs within our internal team. Design: The UI should have a clean and professional look, facilitating easy navigation and enhancing user friendliness. Audience: - The app is intended primarily for use by our internal staff only Ideal Skills: - Previous experience in Zoho Deluge based application development. - Proven track record in d...

I'm seeking a proficient writer to create a compelling letter. The letter should introduce my company to our target audience - small business owners. The tone of the letter should be friendly, conveying a sense of approachability, trustworthiness, and warmth. Key Points: - Introduce our company to potential clients. - Make sure the tone is friendly, not overly formal or salesy. - Address small business owners specifically. Ideal Skills and Experience: - Proficient in business writing. - Experienced in crafting persuasive, engaging content. - Understanding of small business owner's needs and concerns. - Creative and able to think from the perspective of the target audience.

As a client, I am looking for a skilled developer who will create a custom webpage for conducting polls. The key functionalities I need include: 1. Email Verification: The webpage should limit voting to one time per institutional email address. If an invalid email is entered, the interface should display an error message. 2. Voting Display: The voting results should be displayed in real time using bar graphs. It's crucial for the freelancer to have experience in creating such an interactive visual display. 3. Commenting Feature: I want users to be able to create notes as comments under the poll. This gives people a space to share thoughts or elaborate on their vote. The ideal freelancer for this job will have a strong background in web development, with specific experience ...

I'm in need of a bilingual (Arabic and English) social media manager to take control of my beauty business's social media communications, based in Dubai or the UAE. - Payment: 1,500 AED per month (408 US dollars) - Incentives: 500 AED (136 US dollars) will be provided based on increased sales and performance - A dedicated mobile and phone line will be provided - No visa provided - Work from anywhere, but the candidate needs to live in UAE Key Responsibilities: - Manage messages and inquiries from customers. This includes answering questions about our beauty products and services. - Book appointments efficiently. Your promptness and professionalism in this aspect is crucial. Skills and Experience: - Fluent in both Arabic and English to ensure seamless comm...

...others, member registration, subscription tracking, member services management, and trade references. The system should facilitate data import from Excel and accommodate online and offline accessibility based on the user’s capacity to meet online hosting costs. Member Registration: Develop a module for member registration capturing key details such as Name, address, and any other contact information. Village, group, area, district, province, sub-group affiliation (e.g., Study circle, VSLA, commodity association etc.) Demographic information (age, gender, household size, etc.) Implement functionality to adapt and import member data from Excel sheets. Enable different access levels (Project team, Donors and trading partners) for viewing, analysis and w...

I'm seeking a professional to diligently run through LinkedIn, identifying and documenting HR higher-ups within Fortune 500 companies. Ideally...personnel only. Expertise in navigating LinkedIn search and understanding corporate hierarchies will be a plus point. 2. Documenting: I'd like the findings to be presented in a tabular form within an Excel document. Critical data points to be captured include the Company Name, individual's LinkedIn Profile link, and their Role. Your background in HR and corporate structures would be critical in understanding the perfect fit for my requirements. Strong organizational skills, meticulous attention to detail, and proficiency in Excel would be highly appreciated. Overall, a good grasp of LinkedIn-based research wou...

I'm seeking a professional lead generator to boost student enrollment for a secondary education institution. Some key details include: - Target Audience: We're specifically focusing on students in the secondary education bracket (6th to 12th grade). - Ind...sector and understanding of student enrollment dynamics is highly desirable. - Experience in Lead Generation: Proven track record in generating quality leads, ideally within the education sector. - Effective Communication: The ability to communicate effectively with potential students and their guardians to encourage enrollment. If you have experience in this domain and can provide innovative and result-driven lead generation strategies, I'd love to hear from you. For more details about the project, visit -

I need a proficient Solidity and Web3 developer to help build a smart contract on the Ethereum network. The primary functionality of the contract is to facilitate fund transfers and sharing. Ideal Skills and Experience: - Solid exper...pay with eth test network (using metamask) and the smart-contract is; Person A needs 2000ETH for their project with a deadline of 30 days and share the profit 10% after 10 days of the project to reach the goal of each ETH donated by another person, Person B donate 1000ETH Person C donate 1000ETH The project reached the goal (2000ETH) The smart contract automated transfers the fund to Person A address (wallet) After 10 Days, smart-contract automated transfer of 10% from person A to Person B and Person C as we mentioned above the donator will get 1...

As an employee, I'm in need of legal advice to manage and address an ongoing situation of corporate harassment at my workplace. The sooner this can be addressed, the better, as the situation is escalating and impacting my mental and emotional well-being. Key Tasks: - Providing sound legal advice and strategies to tackle the harassment. - Guiding on the best course of action to protect my rights and address the issue effectively. - Document the harassment correctly to address it to the company HR / Harassment departments Ideal Candidate: - Legal professional with a focus on employment law and experience in dealing with corporate harassment cases. - Strong communicator who can explain complex legal matters in an understandable manner. - Proven ability to act swift...

I'm looking for a skilled freelancer to help me create a pivot table in Microsoft Excel that will be used to find pricing quicker Key Requirements: - The pivot table must be created in Microsoft Excel. - The purpose of the pivot table is to find pricing easier The data sources which the pivot table will be using are confidential, and will be shared with the selected freelancer.

We're looking for a professional to assist us with a Homeowner Satisfaction Survey for our HOA. We've written the survey and plan to send it ...Survey for our HOA. We've written the survey and plan to send it to 96 homeowners via USPS mail. Key Responsibilities: - Create a link to the 3 question survey, including an address for responses to go to. - Analyze the survey data in a professional and methodical manner - Compile the results into a comprehensive and actionable report Key Requirements: - Proven experience in creating and analyzing surveys - Excellent communication and project management skills The ideal candidate will have a strong background in survey design and analysis, be detail-oriented and able to provide insightful and actionable recommendations ...

I'm looking for a graphic designer who can skillfully change the background of an image to create a new environment. Specifically, the image is of my wife on our wedding day, she really wanted a picture of her with the car, but we f...we forgot on the day and missed the opportunity. Key Tasks: - Add picture of her beetle into the background of a wedding picture - Insert a high-resolution, realistic new environment - Position my Beetle car prominently in the image - Images can be sent over Ideally, you have previous experience with car image editing and can demonstrate a high level of attention to detail. I'm expecting the result to be realistic and in high definition. Proficiency in Photoshop or equivalent software is required. If you appreciate cars, specifically Beet...

I'm a retail business owner looking for a proactive sales representative to help expand our customer base. Key Responsibilities: - Acquiring new customers both online and in-person - Building and maintaining relationships ...relationships with prospective and existing customers - Identifying opportunities to promote business growth Ideal Qualities: - Excellent communication skills are a must to effectively convey our unique selling points - Proven track record of success in sales, preferably within the retail sector - Strong negotiation skills to secure new business and maintain healthy profit margins This role is commission-based, providing a direct link between your efforts and your remuneration. If you're driven, customer-oriented, and have a knack for sales, I'...

I'm seeking a proficient individual to help with a data entry project. I have about 40 URLs, from which I need to extract the product names, prices, and descriptions. The goal is to collate this information in a pre-defined Excel template. Key Aspects: - Extract product names, prices and descriptions from 40 URLs. - Populate an Excel file with the gathered data.

I'm seeking a skilled individual with a strong command of Microsoft Excel and Word. The tasks at hand are primarily data entry, table creation in Excel and development of an instruction manual in Word. Key Responsibilities: - Efficiently perform data entry tasks in Excel. - Create tables in Excel to visually present the data. - Develop an instruction manual in Word. Ideal skills for this project include: - Advanced proficiency in Microsoft Excel, with a strong expertise in data entry and structuring information. - Proficiency in creating tables, and potentially pivot tables. - Strong experience in creating documents in Word, preferably instructional or informative content. - Attention to detail, as accurate data entry is vital. - Strong communica...

...manipulating GSM network authentication. Ideal Skills and Experience: - Proven experience with openbsc, osmocombb, and openbts GSM. - In-depth knowledge of GSM network setups, including voice calls, SMS, and base station capabilities. - Proficiency in network monitoring and analysis tools. - Previous experience with GSM man-in-the-middle implementations. - Excellent problem-solving skills to address any performance requirements that may arise during the project. Please provide examples of similar projects you've worked on in the past, especially those involving GSM networks and MITM configurations. Please review this paper and need to reproduce what they have done. I have all the hardware in the article. Https://

I'm seeking a talented designer who can create an eye-catching and engaging professional bio for my new prosthetist, Stephen Deaton. Stephen is networking in our local community and trying to establish business referrals. Key Requirements: The bio should designed in a friendly and appro...Professionalism: Stephen prefers a professional, but friendly design. I am looking for a designer who can present Stephen's professional achievements with a matching professional layout. I have included several attachments that include the written content of his bio, three pictures of Stephen and our company logo. The address and phone numbers of our company must be included in the layout: 1389 West Main Street, Lexington, KY 40508. Tel: 1-859-266-5500. Fax: 1-859-266-5523 ...

I'm seeking a proficient developer to create a web-based BTC lottery application with integration to Coinbase for payments and Two-factor authentication (2FA) for additional security. The application is aimed at providing a secure and engaging platform for users to participate in a lottery using BTC as the primary currency. Therefore, it's crucial to have a good understanding of cryptocurrency and blockchain technology. Key Requirements: - Development of a web-based BTC lottery application - Integration with Coinbase for cryptocurrency payments - Implementation of Two-factor authentication (2FA) to enhance security Ideal Skills: - Proficiency in web development, particularly with experience in creating secure applications - Prior experience in working with crypto...

I'm seeking a skilled professional to help me with a research project. The specific deliverable is to find and provide 1,000 email addresses from Apollo. Key Requirements: - Industry: The contacts should pertain to the industry I'll list for you. - Freshness: Email addresses need to be less than 3 months old. Ideal Skills: - Strong research skills: the ability to efficiently navigate through Apollo's platform to extract relevant email addresses. - Attention to detail: ensuring that the email addresses are recent and accurate. - Good understanding of various industries: to assist in collecting contacts aligned with the specified industry.

Generic replied will be rejected. You must have experience in Radix, Scraping Data and be able to create a script that will import directly into woocommerce. We need an experienced radix developer to perform data scraping tasks for our client. The fundamental requirements include: - Scraping data from a suppliers website - Data to be scraped includ...have: - Expertise in working with WooCommerce platform - Proficiency in radix software - Experience in data scraping and storing large volumes of data The scraped data should be imported to my WooCommerce site every month. It's crucial for the service performed to be accurate and thorough. Communication and reliability is key. Please apply with this reference:BPRAD11. Failure to do so will result in your generic application ...

I am in need of a comprehensive business plan focused on a technology industry, primarily crafted to secure a bank loan. As such, the business plan should instill confidence in our financial viability and be convincing enough for loan approval. Key responsibilities would include: - Researching and understanding the nuances of the technology industry - Detailed financial planning including projected revenues, costs, and profitability Ideal freelancers for this job will: - Have a deep understanding and experience in the technology industry - Have strong financial planning capabilities - Show a proven track record in crafting successful business plans for securing bank loans - Be able to communicate technical and financial details in an understandable and compelling way.

I'm in need of an Excel calendar for 2024 - 2025 that will be used for tracking school days off and special events. The calendar should feature the following: - Ability to add and modify events - Monthly view - Color-coded categories - Dates should be highlighted with background color Ideal skills: - Proficiency in Excel, including knowledge of advanced functions - Experience in creating and customizing calendars - Design proficiency to ensure aesthetic and functional layout Look at the Sample

I've a 1 min 28 sec MP4 video where a logo (a horse) appears on the shirt of a person in only certain scenes. I need this logo removed and replaced with a white area mimicking the shirt color. Ideal skills and experience include: - Proficiency in video editing software - Experience with logo removal and replacement - Attention to detail to ensure a seamless result - Understanding of color matching and video consistency

I'm looking for a talented product designer to work on an industrial product that is already in the prototyping stage. The ideal candidate should have experience in designing products for industrial use, with a preference for metal materials. Key Responsibilities: - Collaborate with me to...into a design that is ready for mass production - Ensure that the design is optimized for industrial use, taking into consideration factors such as durability, functionality, and ease of manufacturing Ideal Skills: - Proficiency in product design and development - Previous experience in designing industrial products - Familiarity with working with metal materials The final design should be the result of a collaborative effort, taking into consideration both your expertise and my vision f...

I'm looking for a talented product designer to work on an industrial product that is already in the prototyping stage. The ideal candidate should have experience in designing products for industrial use, with a preference for metal materials. Key Responsibilities: - Collaborate with me to...into a design that is ready for mass production - Ensure that the design is optimized for industrial use, taking into consideration factors such as durability, functionality, and ease of manufacturing Ideal Skills: - Proficiency in product design and development - Previous experience in designing industrial products - Familiarity with working with metal materials The final design should be the result of a collaborative effort, taking into consideration both your expertise and my vision f...

I'm in need of a virtual assistant to help with a variety of tasks, specifically: data entry, email management, and conducting research. ...help with a variety of tasks, specifically: data entry, email management, and conducting research. Ideal Skills and Experience: - Proficient in Google Docs and Sheets - Experience in managing email inbox - Can attend video calls and meeting to write MOM with clients I'm looking for someone who can commit to more than 20 hours per week. The ideal candidate should have a basic understanding of Excel or Google Sheets. Your job will be to document data, answer emails effectively, and conduct research on various topics. I am looking for someone who is timely, organized, and detail-oriented. Please reach out if you think you are a goo...

I have a calculator form that needs some updates made. It allows the user to input measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: New page (needs some jQuery updates): Also have Excel with new formula

For corporate customer To add 4 fields on product/cart page To fix the shipping address based on site code To complete the order using pay later mode The site code and address should be editable in customer profile For other retail and wholesale customers flow should be as per normal purchase flow.

...46 to 100 d - Increase the mobile performance (see performance report) from 37 to 100 3. I do NOT want any changes to the existing look and feel. 4. I do NOT want any additional functionality. 5. Delivery must ASAP 6. The freelancer who is awarded must sign a Non Disclosure Agreement (NDA) and Intellectual Property Agreement (IPA). This will require you to supply your full name and email address because these agreements must electronically signed using DocuSign. If you have concerns about this requirement, please check with Freelancer before contacting us. This is mandatory and the requirement cannot be waived. 7. Please do not contact us with alternate technologies (such as wordpress, wix etc) or tools, and solutions. We are not interested in other technologies. 8. We ...

One excel file with macro as per the customer requirement

I'm seeking an experienced designer to create an elegant letterhead that incorporates my company's logo, name, address, and contact information. The design should be cohesive with our brand, using colors from our existing logo. Ideal Skills: - Graphic Design - Branding - Adobe Illustrator/Photoshop Experience: - Creating letterheads - Designing brand-consistent materials - Using color schemes for branding The final design should not only look aesthetically pleasing but also communicate our brand's identity effectively. Looking forward to seeing your innovative approaches that can bring my vision to life.

I'm seeking a skilled Swift developer who can assist with updating my iOS app. The task involves enhancing the app to meet current standards and potentially fixing any bugs identified in the current version. The successful candidate should ...with updating my iOS app. The task involves enhancing the app to meet current standards and potentially fixing any bugs identified in the current version. The successful candidate should have the following skills and experience: - Proficiency in Swift and familiarity with Firebase-iOS development. - Experience in updating and maintaining existing iOS applications. - Ability to identify and address bugs effectively. - Strong problem-solving skills and attention to detail. Please include your past work or any relevant experience in yo...

...Budget: $125 Project Level: Standard Project Overview: Simple Python script with a HTML front end to allow a user to upload a CSV list of “prompts” and have each one sent as a request to the OpenAI API. There will be multiple prompts on each row. The script will need to move through each column, retrieve the output from OpenAI API, before moving onto the next row. The script should insert the result/text output from each column/prompt/request into a prompt output column of the CSV, then over onto the next row & then automatically download the updated CSV file for the user. Technical Requirements - Server Type: Ubuntu 22.04 - Script Type: Python - Front End Type: HTML - Front End Functionality: - Input API Key into a text field - Upload CSV File - CSV file te...

My project necessitates a top-notch custom web-based ticketing system, prioritizing ticket submission, tracking, and superior user management. Key Features: - Ticket submission and tracking: The system should enable simple ticket submission and comprehensive tracking. Users should be able to monitor their tickets' progress with ease. Ticket Priorities: - The system must classify tickets with a three-tiered system: Critical, Major, and Minor. Each category should have its distinct features and priority level. User Roles: - The ticketing system should incorporate three crucial user roles: Admin, Agent, and User. - Admin: Full control over the entire system. - Agent: Responsible for handling and resolving tickets. - User: Able to submit tickets and monitor their ...