Visual basic excel paste empty cell condition jobs

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 include any relevant...

I need an experienced and creative graphic designer to create a postcard that captures the unique features of my product/service. Key Proj...design should be able to draw attention to the unique features of my product/service in a sophisticated way. - I expect the final deliverable in a print-ready format. Ideal Skills and Experience: - Proven experience in creating direct mail collateral, ideally postcards, using a minimalistic and elegant design aesthetic. - Ability to distill complex product/service features into concise, engaging visual messages. - Exceptionally detail-oriented and a high degree of creativity. Do reach out if you can match these requirements and we can discuss specific details like color scheme, typography, and the exact unique features to highlight on the...

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'm in need of a talented banner designer who can create a personalized and illustrative banner for my social media platforms, particularly YouTube and Twitch. Requirements: -I would lik...style for the design. - Colors/Themes: I have specific colors and themes in mind for the design. Ideal Skills & Experience: - Graphic Design: Proficiency in creating custom graphic designs, particularly banners for social media. - Illustration: Strong skills in creating illustrations, especially for digital media. - Personalization: Understanding of how to translate personal brand elements into a visual design. - Communication: Ability to understand and execute client's vision while also providing creative input where necessary. I'm open to viewing your portfolio and hearin...

I'm looking for an expert in Adobe Photoshop who can significantly enhance the quality of a set of images. The key tasks will involve: - Manipulation and improvement of image features - Enhancement in image clarity and quality - Tweaking and heightening image details wherever ne...significantly enhance the quality of a set of images. The key tasks will involve: - Manipulation and improvement of image features - Enhancement in image clarity and quality - Tweaking and heightening image details wherever necessary Post-editing, the final images should be delivered in PNG format. The ideal freelancer for the job will be adept at closely working on minute image details, with an eye for visual aesthetics and master-level skills in Adobe Photoshop. Proven experience in a similar pro...

...businesses with global capabilities; comprised of industry veterans, Confirmis's business model is designed to overcome perennial lack of data (let alone quality data) to support effective decision-making, particularly in developing economies. As a Site Verifier, you will be responsible for verifying a company’s existence through visual data by conducting a site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' names, etc. • Take pictures of the subject company and its vicinity, as per Confirmis’ standard operating guidelines. • Provide observation about the c...

...presentation design. You will be tasked with: - Modernizing our statement of work, proposals, contracts, and PowerPoint presentations. - Updating layout and formatting. Bring outdated formats into the modern age with a refreshing touch that reflects our brand. - Revising content and language. Our output needs to resonate with the audience, so a quality copywriting ability is crucial. - Adding visual elements and graphics. You'd pepper appropriate visuals throughout our documents and slides, enhancing understanding and engagement with our messages. The style we envision for this task is clean, modern, and professional. If you have an understanding and feel for our described style, we want to work with you; plus, experience in corporate communication will be highly regarded....

One excel file with macro as per requirement

I need a designer to create a concise, professional, and clean PowerPoint presentation for a business audience in (Arabic Language ) Requirements: - The presentation should contain less than 10 slides, which are to be engaging and visually appealing while maintaining a professional and clean visual style. Ideal skills: - Proficiency in PowerPoint - Experience in designing business presentations - Understanding of what a business audience expects Please provide samples of your previous work in your proposal.

...exceptional UI/UX designer who has a commendable portfolio and prior experience in creating distinctive and interactive designs. Specifically, the website should incorporate: - User Registration and Login system - Advanced search and filter mechanism for seamless navigation - Capability to list and provide details about the various events In terms of aesthetics, I'm leaning towards a calm and grounded visual experience. Hence, a design utilizing neutral and earth tones would just be perfect. Our model design is essentially like Airbnb. The ideal candidate for this position would have excellent design skills, a deep understanding of user experience and a knack for visually appealing and intuitive design. Experience in designing marketplace websites or similar platforms wo...

As discussed - website design with brand guide, logo, custom graphics & icons, basic content creation and placeholder content, some mock product photography, stock photo selection, chat with our developers in Slack, some revisions, and help to complete entire design.

I'm in need of a skilled designer to create a blueprint for my ice-cream and frozen treat food truck. Key requirements include: - Designing the layout and equipment placement: I need a functional and appealing arrangement that will allow for efficient workflow and ease of use. - Optimizing space utilization: As we're focused on serving ice-cr...of use. - Optimizing space utilization: As we're focused on serving ice-cream and frozen treats, we need the layout to maximize the available space without compromising on the customer experience or our ability to serve. The ideal candidate for this project will have experience in designing food truck interiors and a strong understanding of the unique challenges and opportunities they present. Visual design skills and an e...

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'm seeking a talented video editor who is experienced in advanced video editing. With a solid understanding of color correction and grading, this person should be fluent in Arabic. The t...correction and grading, this person should be fluent in Arabic. The task includes working with footage from a single personal event, and transforming it into a high-quality, captivating video that tells a compelling story. Ideal Skills: - Advanced video editing - Experience with personal event videos - Arabic fluency - Colour correction and grading expertise - Proficient in storytelling through visual media This is an opportunity for you to showcase your skills in creating memorable videos from singular, unique life events. Your expertise will bring these moments to life, creating a ...

I'm seeking a skilled Figma designer who can help me create a basic level prototype with simple transitions and interactions. This prototype is specifically aimed at my stakeholders and investors. The right candidate will understand the nuances of designing for this audience and be able to translate my vision into a user-friendly, interactive prototype. Key Requirements: - Proficient in Figma - Experience in prototyping - Understanding of stakeholder/ investor needs Your role will be pivotal in translating my vision into a tangible prototype, on which I will rely for critical feedback and investment decisions.

...description generated by AI. Actually, we are looking for a hero who helps us get all things about gambling in Spain, especially iGaming. We are not interested in bettings side of this market, only online casino games are in focus and all things around it, including main operators, target audience, regulative organisations, etc. Please don't use a complicated diagrams with numbers and dry copy paste, cause we have already done it on our side :) As result of this project we are waiting for simple and well structured document no matter pdf, page in Notion or Google docs. That will be a starting point to do things. We are going to understand how people spin in Spain and who is in charge of it. We are not gonna launch another online casino there. Just for research purpose. Wha...

Hello, I have 200 forms, each container with around 20 fields of information. I need each form typed out. I cannot make any mistakes. Empty forms are attached below. I just have about 200 forms of handwritten information, some which I can read and some which I can't so I want it all typed. No using AI or anything for this. To be approved say "Banana"

...Even though the specific objective of this initiative has not yet been fully defined - with possibilities including creating an interactive photo gallery, designing an image editing tool, or developing a photo sharing platform - we do know that we want to push the boundaries of photo interactivity. We're undecided about just how interactive we want the project to be, considering everything from basic interactivity like clicking or scrolling, through to moderate interactivity with drag and drop functionality and animated elements, right up to high interactivity, with user input and complex animations. Who we're looking for: - A innovative, boundary-pushing developer - Previous experience with interactive photo projects preferred What to include in your proposal: - A...

...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 in real time data visualization and email validation techniques. Knowledge about implementing c...

Need a freelancer to answer phone calls. After each phone call, the freelancer will fill out a 5-minute survey (it will be provided upfront). One phone call's average duration is from 3 up to 5 minutes. The goal is phone call evaluation. The price we will pay per phone call is $8, and you will usually receive one call per day. Condition: Freelancers need to speak the US English language very well. As part of the application process, we invite you to record 30 seconds of your voice speaking English. This is an opportunity for you to showcase your fluency and competence in the language. We are looking for long-term cooperation. Payments will be in milestones after each survey (each call). Payment will be released at freelancer.com. You can bid for 3 phone calls to ...

I'm seeking a professional to diligently run through LinkedIn, identifying and documenting HR higher-u...Identifying: I'm targeting senior-level 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 would...

I need an experienced Laravel developer to integrate and manage the database for my existing project, www.getyourhomes.in. The task is not only basic CRUD operations but also extends to admin panel updates and AJAX call filters. - Database Management: You should be adept at advanced database management with stored procedures, triggers, and optimization. - Language Proficiency: Strong language skills in either Bengali or Hindi is essential. Your role would be crucial in improving the functionalities of my project. Prior experience in similar projects would be a bonus.

As a growing business, I'm in need of a talented graphic designer who can help me create captivating and visually appealing social media creatives for my Facebook and Instagram platfor...appealing social media creatives for my Facebook and Instagram platforms. The main goal of these creatives is to increase brand awareness among my target audience. Ideal Skills and Experience: - Strong portfolio showcasing social media creative design - Proficiency in Adobe Creative Suite - Understanding of social media trends and best practices - Ability to create engaging and brand-consistent visual content - Excellent communication skills to understand my brand and target audience If you have the skills and experience required for this job, I'd love to hear from you. Thank you for con...

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.

I'm looking for a 14 developer who can help me with a quick job. I need to upload data to MongoDB and images to Firebase, then retrieve the image URLs to display them in a gallery. Key Requirements: - Upload data to MongoDB - Upload images to Firebase - Retrieve image URLs - Display images in a gallery I don't require any exten...don't require any extensive proposals or past work; just someone who can complete this task quickly. The project should ideally be completed within a day. I have 90% of the code already done but I do not have time to finish it. But i do need it to be easy to replace the dummy data when I want to deploy/publish. Ideal Skills: - Proficiency in 14 - Experience with MongoDB and Firebase - Basic understanding of data retrieval and display in...

I'm in need of a skilled CAD designer to create a simple STL file for prototyping purposes. Key Requirements: - The design should consist of basic geometrical shapes. - It is intended primarily for prototyping use, so the emphasis is on simplicity and functionality. The ideal freelancer for this project should have: - Proficiency in CAD design, particularly in creating 3D printable files (STL). - Experience in creating simple, functional designs for prototyping purposes. - Strong communication skills to ensure the final design meets the intended purpose. Please note that no specific dimensions are required, as the proportions are flexible. The main goal is to create a suitable file for the prototyping process.

I'm in need of a skilled CAD designer to create a simple STL file for prototyping purposes. Key Requirements: - The design should consist of basic geometrical shapes. - It is intended primarily for prototyping use, so the emphasis is on simplicity and functionality. The ideal freelancer for this project should have: - Proficiency in CAD design, particularly in creating 3D printable files (STL). - Experience in creating simple, functional designs for prototyping purposes. - Strong communication skills to ensure the final design meets the intended purpose. Please note that no specific dimensions are required, as the proportions are flexible. The main goal is to create a suitable file for the prototyping process.

I'm looking for an experienced Amazon account manager to handle product listing and optimization as well as inventory management for my active Amazon account selling physical products mainly in the grocery category. Key responsibilities to include: - Ensuring product listings are optimized for search - Keeping up with new...logistics - Regularly adjusting inventory levels to match sales patterns The ideal candidate will have: - Proven experience in managing (and growing) Amazon stores - Deep understanding of Amazon's ranking algorithm and search optimization techniques - Expertise in inventory management on Amazon platform. A history of success in increasing sales for physical products would be a bonus. The pay is basic for now until proven proficiency. The more sales,...

...(NLP) and transformer models. The primary goal of this project is to guide a transformer model to generate code-mixed sentences. Specifically, we are targeting basic code-mixing complexity - inserting words from one language into another. Key Responsibilities: - Develop and fine-tune a transformer model for code-mixing at a basic level - Implement the model in a way that can generate code-mixed sentences effectively Ideal Skills and Experience: - Strong proficiency in Python programming - Proven experience with NLP and transformer models - Familiarity with code-mixing and its linguistic aspects would be a plus - Good understanding of basic code-mixing complexities - Ability to design, implement, and evaluate NLP models This project is ideal for someone who is pas...

I'm in need of a skillful designer to create a basic online portal, web or app, where my small hotel's rooms can be monitored and rented out. Key requirements: - Designing the platform to be responsive, enabling users to access and interact with it from various devices. - Tenant will only request for booking and Booking should confirm only by landlord. After confirmation tenant should be able to book. -Calendar Integration: A feature that enables tracking of room occupancy to prevent double booking. - Implementing an inventory management system that will enable me to monitor the availability of items in rooms at the hotel. - Including a functionality to monitor any defects that might occur in the rooms. - Inventory Maintenance: A system to monitor room conditions, track ...

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

I own a bathroom LED mirror business and need a talented graphic designer to create an engaging infographic image. This image will be used to market my products and educate potential customers. Key Points: - The infographic should emphasize the unique selling points of our LED mirrors, such as the built-in IR sensor, copper-free mirror, energy efficiency, and more. - The design should be visual, easy to understand, and suitable for a broad audience. - It's essential that the image is captivating and encourages viewers to consider the benefits of our products. Ideal Skills: - Graphic Design - Infographic Design - Marketing and Branding Experience The perfect freelancer for this job will have a strong portfolio showcasing similar work. We can provide detailed produ...

Seeking a skilled developer for a website project. The primary goal of this project is developing a website that aligns with my brand and online presence. Key Requirements: - Custom website development tailored to my brand and online presence Ideal Candidate: - Proficient in website development - Experience in developing websites for branding and online presence - Strong understanding of visual aesthetics and design - Excellent communication skills for ongoing discussions about the project Please include past work, your experience and a detailed project proposal in your application.

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 approachable tone, making it easy for Stephen to connect with various professionals and pot...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 Cell...

Need someone to make a reactive webage which will replace an existing site with a single "holding page" whilst a new site is being worked on. Single page, a few links and some text.

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 cryp...with cryptocurrency, such as BTC and Coinbase API - Strong understanding of blockchain technology - Familiarity with implementing Two-factor authentication (2FA) If you have the necessary skills and experience to deliver high-quality work in a timely manner, I look forward to your bid. Tech stack would be Frontend ReactJs Backend NodeJs(Mongo + MySQL) Aws+ cloud deployment Looking for a MVP ...

I'm in need of an adept creative professional who can brainstorm a catchy, two-word name for a Management System Consulting company based in India. The name should reflect the concept of Consulting, Management Systems and embody a westernized tone. Specifics I require: - A trendy and easy-to-pronounce name - .com domain availability for the suggested name - A basic logo concept would be advantageous but not mandatory Successful bidders should have a background in creative writing, branding and possibly graphic design. Proficiency in understanding western and Indian business culture is a plus!

I am seeking an experienced Shopify developer who can design an appealing and easy-to-navigate e-commerce store for my business - a clothing and accessories retailer. Key Requirements: - eCommerce: The purpose of the website is primarily for online sales. Please prioritize...experiences. - Product Category: The website will solely deal in clothing and accessories. - Product Pages: The pages should be image-focused and contain minimal text. The absolute essentials only. Clear, high-quality images will be the selling point here. Preferable Skills & Experience: - A history of successful Shopify e-commerce design, ideally in the clothing sector. - Strong understanding of visual appeal in fashion eCommerce. - Excellent attention to detail, especially in product imaging and minima...

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 need an expert in creating captivating, kid-friendly digital products such as coloring books. - Your task will be to design children's coloring ebooks with a specific theme: farm animals. - I appreciate someone who has previous experience in illustrating for children's books or has a solid background in creating engaging visual digital products. - Superior skills in graphic design, illustration, and ebook creation are paramount. - Your creativity, precise attention to details, and adherence to deadlines will be crucial for the success of this project. - The final product needs to be high quality, fun, and engaging, prompting children to interact and learn about farm animals through coloring.

...showcasing their logo design skills and a keen eye for typography, color theory, and visual storytelling. Responsibilities: - Collaborate with our team to understand our brand identity and design preferences - Conceptualize, sketch, and create multiple logo options for consideration - Fine-tune selected designs based on feedback and iterate until final approval - Deliver the final logo in various file formats suitable for print and digital use Requirements: - Proven experience as a Graphic Designer with a strong portfolio of logo designs - Proficiency in industry-standard design software (Adobe Creative Suite, Sketch, etc.) - Excellent understanding of typography, color theory, and visual composition - Ability to work collaborative...

Project Overview: We are seeking talented graphic designers to create a cohesive visual identity for our existing family of logos. Our goal is to unify these logos under a single thematic design that reflects our brand’s core values and aesthetic. The logos currently serve different products and services but need a harmonized look and feel that connects them visually. The core is the figure "1". We need one Logo "1" as base logo too. So that the company is "1" with the subbrands 1Hosting, 1Marketing, 1Tool, ... We are thinking on just using the 1 alone, too. Scope of Work: Analysis and Research: Review our current logos and brand materials to understand the different themes and elements in use. Concept Development: Generate several concepts t...

...selected candidate will play a crucial role in laying down the structural foundation and preparing the app for future functionality and enhancements. Responsibilities: - Collaborate with the design team to refine app structure for both Android and iOS platforms. - Create and integrate a primary version of the application, utilizing placeholder data to demonstrate flow and functionality. - Construct a basic, yet dynamic, Super Dashboard for project management and tracking. - Prepare the app for backend integration, ensuring scalability for additional features and vendor management capabilities. Qualifications: - Proven experience in mobile app development, with a portfolio showcasing completed projects. - Proficiency in both Android and iOS platforms, with an emphasis on creatin...

...prolific video editor with expertise in special effects editing, particularly skilled with green screen and motion graphics, for my YouTube content. The goal is to polish and uplift the allure of my videos by incorporating visual filters and overlays, adhering strictly to a cinematic style, all in line with the premium quality I envision. Proficiency in special effect software such as After Effects, Blender, or similar is highly desired. Ideal Skills: - Proficiency in video editing - Skilled in motion graphics - Expertise in green screen effects - Mastery in incorporating visual filters and overlays - Focused on cinematic style editing - Proficient in After Effects, Blender or similar software. By showcasing your creativity and leveraging your expertise in special eff...

I'm curr...values, aiming to be inspirational in tone. Key Requirements: - The video needs to be uplifting and motivating, reflecting the core values of our organization. - Interviews with our clinicians and clients will be the main content of the video, so the ability to interact well with people and bring out their stories is crucial. - Creative input in terms of video editing, background music, and other visual elements is highly valued. Skills and Experience: - Proven experience in video production, especially in the realm of corporate videos. - Adept at conducting and filming interviews in a professional manner. - Ability to edit and produce high-quality, engaging content. If you can bring creative flair, technical expertise, and emotional depth to this project, pleas...

I'm in need of a virtual assistant to help with a variety of tasks, specifically: data entry, email management, and conducti...assistant to 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 ar...

...businesses with global capabilities; comprised of industry veterans, Confirmis's business model is designed to overcome perennial lack of data (let alone quality data) to support effective decision-making, particularly in developing economies. As a Site Verifier, you will be responsible for verifying a company’s existence through visual data by conducting a site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' names, etc. • Take pictures of the subject company and its vicinity, as per Confirmis’ standard operating guidelines. • Provide observation about the c...

I need a standard sized flyer for email blast and social media posts. I am attaching product images and a basic description. You do not need to use all of the pictures. My website is: Title: SOUNDWAVES ARE BACK IN STOCK! Description: Looking for the premium all in one earpiece? Do you need better sound quality? Having trouble hearing audio coming from your radio? Look no further! - Superior sound quality - Eliminates condensation issues - Kevlar reinforced for durability - Suitable for daily use, most preferred by Law Enforcement - Allows user to receive communications as well as ambient sound - Constructed with medical grade components - Available in black only. Includes One Ear mold