Delete rows in excel vba based on criteria jobs

I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed

...sobre ellos o tiempo de incubación etc 1-Species selection (List of species with option to add manually) 2-Adult-breeding-egg (Each species has its section without mixing) 2.1(Adult)Male-Female-Add adult-Edit 2.1.1(Male)List with data of each Male 2.1.2(Female)List with data for each Female 2.1.3(Add adult) Cover data (Name-sex-date of birth-genetics-terrarium) 2.1.4(Edit) Be able to edit adults or delete 2.2(Crias) Add-Edit-List 2.2.1.2 the same as adults but without sex 2.3(Eggs) Add-Edit-List 2.3.1 (Add) Select parents from adult list - Laying date...

I'm in need of a generative artificial intelligence that can analyze given text inputs and provide suggestions based on the analysis. The main purpose of this AI would be for data analysis. Key Requirements: - The AI should be primarily text-based. - It should be able to process and analyze the supplied text. - The output should be suggestions derived from the analysis. Ideal Skills and Experience: - Previous experience in developing generative AI systems. - Proficiency in natural language processing and data analysis. - Strong understanding of machine learning algorithms.

...create an account on , an online translation platform. The selected freelancer will not only be responsible for creating the account but also have the opportunity to use the account for their own translation needs. **Requirements**: * Hold a valid translation certificate or degree in one of the following languages: + English to French, Spanish, Italian, Japanese, or Chinese * Provide a detailed CV highlighting your translation skills and experience * Be able to pass 's verification process with your valid translation certificate or degree **Tasks**: * Create a account with the client's provided information * Configure the account for shared access * Provide login credentials for the client to access the account * Assist the client in understanding ...

I'm in need of a specially developed Stream Deck plugin, tailored to capturing and instantaneously replaying in-game voice clips. This plugin will not need to integrate with any streaming software, but must have the ability to work seamlessly within gaming environments. Key aspects of this project include: - Development of a button functionality on the Stream Deck that allows clipping of in-game voices. - Instant replay feature for the captured voice clips. - Automatic saving of these voice clips without prompting the user. Firstly, I already use a plugin for the Streamdeck called “Sound Deck” for videogames and this plugin has a feature that allows me to record the voices, or sentences, of my teammates the voice chats and then i can immediate...

I need someone to enter 500 purchase invoices into an Excel spreadsheet. I will provide a template for the format. The invoices will be sent to you as digital files through a cloud service, which you'll use to input the basic details like date, vendor, and amount. Ideal Skills and Experience: - Proficiency in Excel for accurate data entry - Experience in processing financial documents - Attention to detail to ensure data accuracy - Ability to handle sensitive financial information with confidentiality - Familiarity with using cloud services for file management Please let me know your experience with similar projects and how you plan to ensure the quality and efficiency of the data entry process.

I need assistance with a data typing project. The job entails: - Entering data from various sources into a spreadsheet - Ensuring accuracy in the data entry - Organizing the data in a single consolidated file While the project doesn't require specific styling or formatting currently, it might at a later point. Therefore, experience with Excel and basic data entry is crucial. Please reach out if you think you're qualified for the task.

...the local machine and can sign PDF, XML, JSON, and Text files in bulk and with the following additional features: - Bulk Signing: It should support signing multiple files at once, with no specific limit. - Predefined Output Path: Users should have the option to assign a default output path for the signed files. - PDF Signature Display: For PDF documents, the utility should display the signature as an optional feature. The goal is to have this utility developed within a month. Ideal skills for this project include: - Proficiency in programming languages suitable for file processing (e.g. Python, Java) - Experience in developing software utilities or tools - Familiarity with e-signing mechanisms and standards - Prior experience in working with PDF, XML, J...

I'm looking for a skilled Excel expert to create a project tracking sheet with a calendar section that lists weekly milestones. Key Features: - The main sheet is for tracking project progress. It should include: * Project /Task Name * Start Date * End Date * Progress (percentage) * Priority * Action plan * Comments - The calendar section should list team schedule. * Team working schedule "in office / out of office" * Team calendar "working remotely, annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to quickly...

...create a comparison website to help potential traders assess and select proprietary trading firms in the finance industry. Key Requirements: - The site should have a comprehensive database of different proprietary trading firms, their key features, and offerings. - Users should be able to filter and compare the firms based on various criteria like trading strategies, capital requirements, and more. - A user-friendly interface and robust backend that can handle large amounts of data and provide real-time updates are crucial. Ideal Skills & Experience: - Web development experience, particularly in building comparison websites. - Understanding of finance and proprietary trading firms. - Proficiency in database management and user interface d...

I'm looking for a skilled software developer to create a Windows-compatible software application. This software should be specif...Requirements: - Compatibility: The software should be compatible with Windows. - Integration: There's no need for the software to be integrated with any existing systems, so you can focus solely on creating the best software for our sales team. - Data Input: The software should have the capability to import data from Excel/CSV files. This method will facilitate the input of sales data and make the software more user-friendly for our team. Ideal Skills and Experience: - Proficient in Windows software development. - Experience in creating software for sales teams or incentive calculation. - Familiarity with Excel/CSV ...

...partners signs the same agreement . new partner signs in new agreement print out )I'm seeking a skilled legal professional to review this agreement and provide their expert opinion. Opinion Should be Given in Writing in a Letter pad with Seal signature and Digital Signature Person signing should have valid registration certificate and must be attached with the Opinion Letter. Key Concerns: - Terms of Membership: I need assurance that our membership terms are legally sound and won't put us at risk of non-compliance with local laws. - Dispute Resolution Process: It's crucial that the agreement's dispute resolution process is fair, efficient, and legally sound. - Profit Sharing Mechanism: I want to ensure the profit sharing mechanism is in...

I'm looking for a creative designer to craft a modern, text-based logo intended for online use (websites, social media). The Word is XConn which needs to be designed. Following example is for proof of concept. XConn represents cross-platform connectivity, so a little touch of that in the logo would be a bonus Key details: - Style: The design should reflect a modern aesthetic. I'm not after overly complex or vintage styles but rather something sleek, clean, and current. - Color: I don't have a specific color palette in mind. I'm open to suggestions, so feel free to utilize colors that align with modern design trends. The ideal candidate for this project will: - Have a strong portfolio that demonstrates expertise in modern logo design. - Pos...

I ll upload various images under specific keywords. I want members to receive 1 image after texting that keyword in their personal channel. Also i want that image to be deleted in storage so that it will not be forwarded to other member. I also want a channel for my accountant, where he ll be uploading bill in pdf. And i ll get all data in excel sheet.

I'm in need of a highly skilled and advanced CISSP trainer for on-prem training in Kuwait. The training will be for a small group of 1-10 participants. The ideal candidate should be able to provide the following training materials: - Comprehensive printed manuals and handouts - Digital copies (PDFs, slides) for participants to refer to post-training - Practice exams and quizzes to help reinforce learning and assess understanding The trainer will be expected to travel to Kuwait for this assignment. Experience in providing CISSP training in a physical setting, particularly in the Middle East, would be a significant advantage. The ideal candidate should be able to deliver complex CISSP concepts in a clear and engaging manner, ensuring par...

I'm looking for a professional who can plot GPS coordinates from an Excel spreadsheet onto a map. This map should be easy to interpret, displaying the route taken by a vehicle. Key requirements: - The data provided is in Excel format. - The final map should be a static image file. The main task of this project is to: - Visualize the route taken by a vehicle based on GPS coordinates. - Timestamps are crucial and should be displayed in a clear, understandable manner. - Since I want to see the exact route taken, the map should display addresses corresponding to the GPS coordinates. Although the main focus of the project is plotting the coordinates and timestamps, other features such as: - Distance between points. - Speed of the vehicle. - Est...

I'm looking for a skilled freelancer to create a mantra chart in Excel. This will be a presentation-worthy document, so I'm keen on ensuring that it's well-structured and visually appealing. Key Requirements: - Incorporating text, numbers, and dates into the chart - The chart should feature less than 10 mantras - Ensuring the final output is suitable for professional presentation The task will require someone with excellent Excel skills and an eye for design. A good understanding of data representation would be a big plus. You can expect detailed instructions and guidance from me throughout the project. Feel free to ask any clarifications you might need.

To create a precise 3D model of a small-sized charging case for the AirPods Pro 2 in Blender, here's a detailed plan based on your specifications. Specifications Recap: PCB and Battery Dimensions: 33 x 40 x 10 mm AirPods Pro 2 Dimensions: Height (H): 30.9 mm Width (W): 21.8 mm Depth (D): 24.0 mm Design Requirements: The case should connect to the top and be formed like a butterfly. The two circular charging metals at the bottom should be positioned to the left and right. The part of the AirPods Pro 2 that goes into the ears should stick up 15 mm above the case. Steps to Create the 3D Model in Blender: Set Up Blender: Open Blender and delete the default cube. Model the Charging Case: Create the Main Body: Press Shift + A to add a new mesh, select C...

...the app is to place and manage trades based on predefined criteria. It should be able to execute trades automatically without the need for manual intervention. Ideal Candidate: I am seeking a developer with a background in finance and algorithmic trading who can bring the following skills and experience to the project: - Proficiency in Windows application development using Python or similar languages. - Experience with trading APIs, particularly in the context of order execution and management. - A solid understanding of trading strategies and the ability to translate these into functional code. - Knowledge of financial markets and trading dynamics. Please note that the specific API provider for the trading has not been settled yet, so fle...

I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus

I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.

I need to scrape data from a websi...website. I'm stuck with an error. I used improtxml to scrape data from a class in a website I know. However, the fact that this website has classes has a problem: . While on page 1 there will be that text data, but on many pages, that text data is not there and it is accidentally pushed up to insert the class data below into the previous class data. To make it easier to imagine, there will be 4 rows. I will need to get a fix for each row into the google sheet. However, there are pages where I insert the link and there will be no row 3 or row 2 and then row number 4 will be inserted into row number 3, making the data incorrect. I need improxml to automatically check the syntax, if it is correct, it will be filled in...

I'm in need of a skilled freelancer to assist in finalizing my email list building project. Your role will be to source C-Level leads and their contact details, ensuring they meet the specified criteria. Key Responsibilities: - Source C-Level leads in the technology industry - Gather email addresses and LinkedIn profiles for each lead - Ensure all sourced leads meet the specified criteria This project requires you to source between 100-300 C-Level leads. I value accuracy and efficiency and am looking for a competent and reliable freelancer to assist in this final crucial step of the project.

I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data management processes and turn this d...

...for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's success. Please note th...

I require a talented freelancer to construct a text-based logo, along with an engaging introduction focused on emphasizing my company's mission and values. Additionally, I'm looking for the concept and design of formal business attire. Requirements: - Aesthetic and definitive text-based logo design. - Draft an introduction with captivation, mirroring our mission and values. - Original and professional designs for formal business attire. Ideal Skills: - Extensive experience with logo design and typography. - Excellent written communication for the introduction. - Creativity and expertise in formal attire design. - Understanding of the apparel industry's current trends. - Proactive, innovative and deadline-oriented. And providing the type ...

I am looking for an experienced developer to create a Hangman game using React and utilising ...random words. This game will implement particular features of my choosing but will not revolve around any specific visual theme or elements. Key Requirements: - In-depth knowledge and experience working with React. - Understanding and previous work with APIs, specifically in random word generation. - Ability to implement specific features to enhance the hangman game experience. Expected Deliverables: - A fully functional hangman game that runs smoothly and is bug-free. - Proper integration with the pre-selected random word generation API. Note: Although no specific visual elements or themes are required, creativity is appreciated in the design process to make the game use...

I'm in need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac compatibili...

I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.

...skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry out some basic analysis on it...

I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a practical, real-world ...

I'm in need of a web-based job card system that will allow the creation and editing of digital job cards. There is also a requirement for quotes, parts / inventory, archived jobs, and customer management. Both employees and managers will need access to the system, with an admin login section for authorization of completed job cards. We would like the system to export completed jobs to CSV file for automated invoice generation in Quickbooks Online. We will also require the system to import the customer database from Quickbooks in CSV format. Key Functionalities: - Creation and Editing of Jobs - Ability to use system on-site / remotely through the use of iOS or Android web browsing. Some - Ability to select a simple job status from a drop-down comb...

Develop macro-enabled Excel file to handle CSV

I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to ...

I'm in need of a creative and innovative logo expert who can design a compelling text-based logo for my brand. The logo must convey a sense of innovation through its design. Key requirements: - The logo should be primarily text-based, ensuring that the brand name features prominently within the design. - The design should embody a sense of creativity and innovation, resonating with a target audience that appreciates forward-thinking brands. - The logo must be suitable for online use, enhancing its visibility and appeal on websites and social media platforms. Ideal candidates for this project should possess: - Proven experience in designing text-based logos - A strong portfolio that demonstrates creativity and innovation in logo design...

Key Requirements: - Need an expert in Python programming - Familiarity with Pandas and Beautiful Soup - Experience in data analysis The job mainly involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required. (feel free to rewrite code if you have better idea) --- name "iXBRL" , inside folder contain multiple html file(hundreds to thousands), each html file contain multiple tables(vary from 15-35, depend on each html file). Python to extract specific table and vertically stack them together to create an Excel file.(first column add html filename.) inside html file is encoded in chinese, s...

I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources

I'm in need of a talented Salesforce developer based in Hyderabad who can provide offline support for custom application development. This project requires your physical presence in Hyderabad, so remote support is not an option. Ideal Skills and Experience: - Proven experience with Salesforce development, particularly in custom application development. - Strong understanding of Salesforce CRM and its various functionalities. - Excellent problem-solving skills. - Strong communication skills, as you'll be required to provide in-person support.

Make an Android app which can be installed on customer phone(new/old) and if customer defaults EMI payments, I can lock customers' phone remotely.

I'm in need of a backend developer with experience in PHP and deploying Flutter apps on shared hosting. Key Requirements: - Configure the backend using PHP - Deploy the Flutter app on a shared hosting environment - Ensure the app functions properly in this setup - Provide any necessary support during and after the deployment Please note that I've already set up the custom domain for the app, hence your assistance won't be needed in that aspect. Ideal Skills: - Proficiency in PHP - Previous experience deploying Flutter apps on shared hosting - Strong understanding of server configurations and optimization - Good communication skills and ability to provide technical support if required. Looking forward to your bids.

DotNet developers required for #Errors removal and Improvement work# in thenafter Host on server. Developers should also have knowledge about Merger of sourcecode and database of his done-work with other developer's done-work on GitHub. Website Address - User emailid- @gmail.c Password- kaspersky Errors removal and Improvement work which has to be done is explained in below link-

I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to 'Category A' sh...

... Project Requirements: - Convert Microsoft Word Document (2 pages) to Web Form: Transform the content and layout of the Word document into a web-based form. - Responsive Design: Ensure the form is fully responsive and looks great on all devices (desktop, tablet, and mobile). - Form Fields: Create all necessary form fields as outlined in the Word document, including text fields, dropdowns, checkboxes, addable rows table, etc. - User-Friendly Interface: Design a clean, user-friendly interface. Skills Required: - Proficiency in HTML, CSS, JavaScript, and responsive web design - Experience with web form development and validation PHP Integration (optional): - Form Data Processing: Develop a PHP script to receive the form submission

From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.

...money hence our AI works on it through big data and automation. The project is about algorithmic auto-investing trading on world wide's financial market. Fixed Rate Job Paid based on success delivery per country. $10/country. Make about 5-10 API/country for installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup cron...

I am in need of an expert who can proficiently implement DMARC, DKIM and SPF records to improve my email deliverability and security level. I'm currently using GoDaddy as my email service provider, hence, hands-on experience with GoDaddy will be crucial for this project. Key Requirements: - In-depth understanding of implementing DMARC, DKIM and SPF records - Expertise in email security - Experience with GoDaddy and Klaviyo - Ability to complete the task ASAP Only bid if you are confident you can meet these criteria. This is a priority for me and should be handled with the utmost professionalism.

I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.

I am in need of an experienced Amazon Web Services (AWS) specialist who has an extensive knowledge in EC2, S3, and Lambda. I represent an AWS Reselling company and am seeking individuals and small to medium-sized firms actively using AWS to partner with us for the 2024 CRP program, which focuses on promoting AWS adoption. Through this program, you can earn rewards for launching new projects on AWS or for your existing active AWS projects. Increase your earnings effortlessly, without any additional workload. If you're interested in learning more, let's connect to discuss the details. Eligibility Criteria: The program is open to all IT companies, independent vendors, and freelancers supporting a diverse range of clients, primarily those...

Please Sign Up or Login to see details.

...dashboards, primarily based on data from Excel spreadsheets. Key Responsibilities: - Develop compelling, visually appealing reports and dashboards that are easy to interpret and navigate. - Tailor the reports and dashboards specifically to financial analysis, ensuring they provide the insights necessary for informed decision-making. Ideal Candidate: - Proven experience creating financial analysis reports and dashboards in Power BI. - Proficiency in integrating data from Excel spreadsheets. - Strong attention to detail and the ability to translate complex financial information into clear, concise visual elements. This project requires a high level of expertise in Power BI, financial analysis, and data visualization. If you're a ...