Count colored cells in excel with vba jobs

I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.

I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase ord...

I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.

I require a skilled writer who can create engaging Arabic articles. The topics are varied and can cover anything. Key project details: - Topic: Various, from Technology to Travel or Health - Word count: Less than 500 words per article - Language: Arabic I value: - Excellent command of the Arabic language - Ability to create engaging and well-structured content - Previous experience in article writing is a plus Looking forward to receiving your bids.

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

...annual SEO project for a well-known small appliance brand in the United States, which is part of an international group. The website is an e-commerce site. This profile will work integrated into the SEO team for AMERICA that the client has formed, along with other management and technical members so that teamwork will be an essential condition. The project is a global project where each region has its strategy, but all must go hand in hand. The consultant will become part of our network of freelancers, with the possibility of participating in other projects for which a profile like theirs is sought. What do we offer? - The possibility of joining a multicultural team and working in the dynamic e-commerce sector for a company with a broa...

I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines

I am seeking a skilled freelancer to find popular influencers across multiple social media platform...media platforms including Instagram, YouTube, TikTok, Gettr, Truth, Facebook, and Rumble. Requirements: - Experience in social media marketing and influencer outreach. - Ability to categorize influencers by follower count and engagement rate. Main Tasks: - Identify influencers across stated platforms - Categorize them based on follower count and engagement rate Application: Please share examples of your past work related to influencer discovery or social media marketing. Highlight any specifically relevant experience for this project. By recognizing your ability to successfully deliver this project, through past work examples, I can feel confident that my projec...

I'm in need of a skilled developer to create a custom Forex indicator that counts bars from a specific origin point. The indicator should work on Tradingview Key Requirements: - The primary function of the indicator should be to count bars rather than identifying trend reversals, highlighting entry/exit points, or measuring volatility. - The indicator should be capable of accurately counting bars. Ideal Skills and Experience: - Proven experience in developing custom Forex indicators. - Proficiency in working with a variety of trading platforms. - Strong understanding of Forex trading and technical analysis. - Prior experience in creating bar counting indicators would be a significant advantage. Please provide a brief overview of your...

I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.

I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate tran...

**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and ...

Sure, here is the translation of your text into English: ...interior decorator to help me furnish and decorate my new apartment. We would like to start with the living room and the bedroom. We like the modern and minimalist style, with a preference for the Scandinavian style. We also appreciate some details that could warm up the atmosphere of the rooms. Here is some information about our living room: - The kitchen is anthracite-colored with an island featuring a white base and an anthracite countertop. - The floor is covered with light gray tiles. - Our furniture is mainly white and beige. - We mostly buy our furniture from IKEA and Pfister. We would like a proposal that harmonizes these elements while bringing a personal and warm touch to our interior...

...content writer with expertise in SEO and familiarity with ChatGPT to craft a 1000-1500 word article. The primary objective of this article is to ensure it's optimized for SEO to achieve high and fast ranking on search engines. The content should be informative and engaging and meet the needs of SEO professionals. Ideal skills and experience for this job include: - Proven track record in content creation, particularly SEO-optimized articles - Knowledge of LSI keyword extraction - Experience with ChatGPT or a similar AI writing tool - Strong understanding of current SEO best practices - Ability to use Visual Studio Code for collaboration and development The successful candidate will be able to deliver a high-quality, compelling, and SEO-friendly ...

I need a software expert to develop ...then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can create a tool that not only collates d...

I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.

...expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a large amount o...

...a user adds or subtracts a color, the form should update in real-time and count up the number of colors selected. The user should be able to see a preview of the selected colors. Furthermore, the form should dynamically adjust the color options based on the user's selections. - Data Handling: The form should send me an email with the final count and types of colors selected. - Layout and Design: It is crucial that the form matches the design of the provided image. Ideal applicants should have: - Extensive experience developing custom forms for WordPress - Proficiency in CSS and HTML, with an eye for design to create a visually pleasing experience. - Strong communication skills as you will be required to provide updates and keep me in...

I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” ...

...a skilled freelancer who can help automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on - Details of your ...

I need a simple static HTML banner ad des...i was thinking "We Pay" could be larger on the first of 3 lines and 2nd line could be smaller and read "for Clients" and the bottom line would be "Inspections" it should be colored similar to this page coloring: Key requirements: - The banner should be static, no animations are needed. - The design should be eye-catching and present the message in a clear, visually appealing way. - It should be suitable for web placement. Ideal skills and experience for this job: - Proficiency in HTML and CSS to design the banner ad. - Previous experience in creating similar static ad banners. - A good understanding of design principles and ability to create visually appealing graphics.

...message count - Customizing the message content The app does not need to include analytics to track the number and timing of messages sent. More information: Can someone develop an Android app that can do the following: Automatically send a message in a WhatsApp group at random times. For example, send 3-5 messages per day at random times. The number of messages should be adjustable within the app. The messages should be sent between 9:00 AM and 10:00 PM (always at random times). The time range during which the messages are sent should be adjustable within the app. Why do we need such an app? These messages are intended to prompt a person in the WhatsApp group to take an alcohol test and post the video of the test in the WhatsApp group. The purpose is t...

I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verification. This role necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks to be per...

I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.

I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

...life, envisioning a multi-colored, Ryder Cup inspired logo for a sports event. With time being of the essence, your commitment to promptly delivering high-quality work would indeed be a boon. Key Responsibilities: - Transform a sketch into a compelling sports logo - Incorporate a multi-color scheme proficiently to create a vibrant design Ideal Skills: - Proficiency in graphic design software - Previous experience in logo design - Quick turnaround time - Excellent communication skills Your prompt submission of a well mitigated, polished logo design would be greatly appreciated. As the client, I am keen to collaborate with a dedicated, skillful, and innovative individual to elevate this project from concept to reality. LOGO ELEMENTS. Silver plate ...

I need a skilled 3D artist to create a realistic tree model in PSD format for architectural visualization. - Design a custom tree based on the characteristics of an orange tree - The 3D model should be colored green - The primary purpose of this model is for architectural visualization, so it should be realistic and detailed Ideal Skills: - Proficiency in 3D modeling software - Experience in creating realistic 3D models of nature elements - Strong understanding of color and texture in 3D design - Previous experience in creating assets for architectural visualization would be a plus.

Product Description: - FamPe is a platform that enables viewers to interact with their influencers through messages and monetary contributions. Adding a monetary contribution prioritizes and highlights their comments/messages. Brand Name: FamPe "Fam" is a keyword used by influencers to refer to their fans because it creates a sense of closeness and community. This platform enables fans to contribute (monetary contribution) to their influencers, especially in Live Streams. That's where the name FamPe comes from. Brand Values:- - Innovation - Reliability - Efficiency - User-Friendly Logo Style Preferences:- - Audience: YouTube streamers and viewers, ages 15-45, worldwide demographic - Type: Wordmark logo, modern and minimalist - Feel: Exclusive, Professional, ...

I'm seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to create user-fri...

I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temp...manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufactu...

I'm in need of a skilled developer who can create an AI portal that is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel...

...message count - Customizing the message content The app does not need to include analytics to track the number and timing of messages sent. More information: Can someone develop an Android app that can do the following: Automatically send a message in a WhatsApp group at random times. For example, send 3-5 messages per day at random times. The number of messages should be adjustable within the app. The messages should be sent between 9:00 AM and 10:00 PM (always at random times). The time range during which the messages are sent should be adjustable within the app. Why do we need such an app? These messages are intended to prompt a person in the WhatsApp group to take an alcohol test and post the video of the test in the WhatsApp group. The purpose is t...

We are looking for a person with knowledge in German Health & Safety regulations. Native German speaker and good command in English or Spanish is needed in order to be able to obtain the training and coordinate with our validation team. The job will consist on checking documentation to see if the validation requirements established for each documents are met. Our client needs to obtain certain documents from the companies that are going to work in the premises of our client. The documents will be related to the company, employees, tools and vehicles. The task is to validate or not the document. In case there is a non compliance, then the person will need to request the ammended document to the subcontractor. This is a remote job, i...

I am in need of detailed administrative work. It involves segmenting primary school level maths questions based on the specific skills required to answer them correctly. The task will be to review 50 past papers - containing approx 50 questions each. For each question, I need someone to: - cut & paste an image of the question into a Google slides / Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page number of Google Slides document ...

...assist me in creating a web scraper that can extract specific text content from a website on a weekly basis. The scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python programming - Experience with web scraping libraries such as BeautifulSoup or Scrapy - Understanding of scheduling tasks in Python - Familiarity w...

...looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - In...

I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.

I'm seeking a skilled virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You'll be responsible for using various messaging platforms to engage with potential clients and leads. Ideal candidates should excel in written communication and have a knack for sales. Proficiency in project management tools is a plus. Our preferred mode of communication with leads is through messaging platforms.

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

I have a black-colored, cotton garment that I want to change to white. I'm looking for an experienced professional who can accomplish this without damaging the item's quality and texture. The ideal freelancer will have prior experience with fabric dyeing, color theory, and material handling. Knowledge of best practices for color transition for cotton materials is a must.

...who started on TLD in 2018, with a focus on the years 2023 and 2024. Key Study Objectives: - Analyzing Viral load suppression and its trends over time. - Evaluating CD4 count improvement and documenting its progression. Information Sources: - The research will utilize clinical trial data and information from medical research articles. Careful extraction of relevant data from these sources is essential. Target Audience: - The report is intended for healthcare professionals. Hence, it necessitates a rigorous, scientific tone and language. Required Skills and Experience: - Extensive experience in medical research and report writing. - Strong understanding of HIV treatment outcomes including viral load suppression and CD4 count improvement. - Demonstr...

I'm seeking a social media manager to help me with my Facebook and Instagram accounts. Key Responsibilities: - Grow my follower count on Facebook and Instagram - Enhance engagement on both platforms - Drive traffic to my website from these social media channels I'm looking to: - Increase the number of followers - Boost engagement levels - Drive quality traffic to my website The ideal candidate should have experience in: - Social media management - Growing followers and engagement - Increasing website traffic through social media Your successful work on this project will be a great step towards long-term collaboration.

I need help with my Microsoft Excel project! Specifically, I require assistance with the following: - **Formulas and Functions:** - Basic arithmetic operations. I don't need anything too complex, just fundamental formula structures. - **Automation:** - No macros for repetitive tasks are required, but I need guidance on setting up conditional formatting rules within the document. I'm looking for a Freelancer who is experienced in Excel and is comfortable with basic arithmetic operations and conditional formatting. You should be able to provide clear, concise, and easy-to-follow guidance. A strong attention to detail and excellent communication skills are a must. If you're proficient in these areas, I'd love to ...

I'm in need of an experienced VBA developer who can create custom macros for me, specifically to assist in automating tasks within Microsoft Excel. I'd like to streamline processes and increase efficiency within the software. Key requirements: - Proficient in VBA: You should be well-versed in VBA programming and have a proven track record of creating efficient and effective macros. - Microsoft Excel expertise: Experience in working extensively with Excel is a must. - Automation focus: The macros need to automate a variety of tasks, including data entry, report generation, and potentially formatting. While the complexity of the data manipulation needed isn't explicitly detailed, please be pr...

I need a skilled content writer to create professional blog articles and w...Requirements: - Content Types: The project involves creating blog articles and website content. - Word Count: The desired word count for each piece is between 500 to 1000 words. - Tone: The tone of the content should be thoroughly professional. I am looking for a writer who can adopt a professional tone while crafting engaging and informative content. The ideal candidate should have a strong understanding of SEO, tailoring content for digital platforms and have an excellent command over English. Experience in content writing for websites and blogs will be an added advantage. If you possess all the above qualities and can deliver high-quality content within the specified word count,...

...this project: • Proficiency in eclectic interior design • Experience in bright, bold color scheming • Experience designing for hospitality businesses. Your creative vision in blending different style elements can create an energetic, inviting atmosphere in our establishment. Interior Design Brief for Women's Salon 1. Overview: Design focus: Create a luxurious and functional space for a women's salon with distinct areas for nail care, hair services, and reception. Aesthetic: Modern, elegant, and inviting with a contrast between black furniture and flooring. Key Features: Open ceiling, glass partitions, nail polish display shelves, dedicated areas for nail care, hair services, and reception. 2. Layout ...

I need a freelancer to help me gather phone numbers from clothing stores in County . You'll be provided with the location and shops to focus on. Key Responsibilities: - Utilize street view to identify shops - Collecting phone numbers of all such shops - Organize and input these numbers into an Excel spreadsheet Ideal Skills: - Proficient in using street view and other location tools - Detail-oriented and capable of data entry - Comfortable using WhatsApp for communication This is a straightforward project, but attention to detail is crucial. Feel free to reach out if you have any questions.

I'm seeking an experienced professional to help me recover a fixed lump sum payment due as compensation following the t...representing a substantial debt. Key Factors: - The lump sum payment is calculated based on the revenue generated during the agency. - Expertise in handling similar financial disputes is preferred. - Knowledge in sales agency contracts and labor rights is advantageous. Ideal candidates should have experience dealing with unpaid commissions, overdue expenses, and outstanding loans. Additionally, a strong understanding of how compensation for sales agency termination is calculated would be highly beneficial. My expectation is to enlist your help to recover this money as efficiently and quickly as possible. I count on your efforts, e...

...strong level of experience and skills in managing safety issues at large scale events with an expected attendance of more than 5,000. Key Responsibilities: - Develop and implement robust safety measures addressing key anticipated issues including Crowd Control, Medical Emergencies, and Fire Hazards. - Review and approve all safety arrangements and plans prior, during and after the event, - Continuously monitor safety compliance during the event. - Quality control - Auditing and monitoring - Document management - Policy and procedures implementation - Other events safety related matters Skills and Experience Required: - Proven experience in large scale event safety management. - Expert knowledge of various safety threats and first-hand experience in ...