Excel vba select based criteria jobs

I'm looking for a data entry expert to help with Excel data entry and formatting customer information. Key Responsibilities: - Entering customer information into Excel - Formatting data for consistency Ideal Skills: - Proficiency in Excel - Experience in data entry and formatting - Attention to detail and ability to meet deadlines Please reach out if you're interested.

"Enhance an Existing Excel Workbook with Creative Design & Marketing Skills Looking for a professional to refine an Excel workbook with existing formulas, functions, and macros. The task involves improving its visual appeal and overall presentation (logo included) without disrupting the calculations. Estimated time: 2-2.5 hours. Task Instructions for Excel Workbook Enhancement Aesthetic Improvement: Enhance the visual appeal of the workbook, making it more professional and polished. Remove unnecessary areas that do not add value for marketing purposes. Workbook Flow: Organize the pages to ensure logical progression and easy navigation. Improve readability and ensure a cohesive structure. Content Review: The workbook contains real data, such as companies, ...

I'm seeking a skilled Excel or Google Sheets expert to create a comprehensive spreadsheet to track my crews in hotels. The data I need to monitor for each crew includes: - Crew names and contact information - Hotel check-in/out dates - Room assignments - Purchase Order (PO) numbers - Job Numbers The spreadsheet should have the following functionalities: - Automatic notifications before the hotel booking ends Ideal candidates should have extensive experience in creating complex spreadsheets with advanced features, and a strong understanding of data management. Please include examples of similar projects you've completed in your bid.

I'm looking for an experienced developer to create a WHMCS provisioning module that automates the selling, creation, and activation of IPTV service accounts through a provided API. Key Responsibilities: - Build a WHMCS module enabling clients to select from various IPTV service options, such as country selection, service duration (monthly or annually), and channel package selection, during the purchase process. - Implement automation for account creation on the IPTV server as soon as payment is confirmed in WHMCS. - Ensure immediate activation of the IPTV service account upon successful payment. Module Features: - The module should allow for service customization at the point of purchase. - Seamless interaction with the IPTV API for automated account creation. Deliverables: ...

...preferences, tone, and voice of each client. The vision is to create a system where users can select a client from a list. Upon selection, the tool will adapt its content generation approach based on client-specific parameters, stored in a database. Additionally, the tool should learn and adapt its writing style over time by analyzing previously submitted content, improving its ability to match each client’s unique voice. Since this is my first venture into AI-based content generation, I would greatly appreciate the guidance of an experienced developer on how best to build this tool and structure the project. Scope of Work: Client-Specific Model Customization: Develop a system that allows users to select a client (e.g., Client A, Client B, etc.), and...

I'm facing an issue with my WooCommerce store where none of my product variations or attributes are showing to customers, neither in the frontend nor in the backend for variable products. - All color variations are correctly set up in the WooCommerce product settings, yet they are not displaying. - When attempting to view or edit these variations, an error message appears stating "please select an option", even when no options are visibly available. I'm looking for a qualified WooCommerce expert who can troubleshoot and resolve this issue. Experience with WooCommerce and understanding of product variations is a must. Please provide examples of similar issues you've resolved in the past.

I'm looking for a Python script that leverages RoBERTa to automate the identification of potential candidates from both LinkedIn and their resumes. The script should analyze candidates based on their skills, experiences, personal statements, educational backgrounds, etc. Key Requirements: - Data Processing: The script should be able to process both LinkedIn profiles and uploaded resumes. - Data Preprocessing: The script needs to carry out critical preprocessing steps such as synonym replacement, sentiment label mapping, and implementing data augmentation and class balancing. - Analysis and Evaluation: The script should perform correlation analysis and generate a heat map. The model's effectiveness should be evaluated using metrics like accuracy, F1 score, precision, recal...

...connection. Demographic Appeal: Young adults (18-45) passionate about sustainability, cultural heritage, and empowerment. Consumers seeking high-quality, eco-conscious, and socially responsible beauty products. Deliverables: A complete logo in vector format (AI, EPS) and high-resolution PNG/JPEG. Black-and-white and color versions of the logo. Mockups showcasing the logo on cosmetic packaging. Judging Criteria: Alignment with brand values (empowerment, heritage, sustainability). Creativity in integrating Indigenous symbols with a high-end aesthetic. Scalability and versatility for multiple uses. About WAR PAINT Beauty: WAR PAINT Beauty is more than a cosmetics brand—it’s a movement. Inspired by the war paint traditions of Indigenous ancestors, our products embody res...

I'm in need of a dynamic and energetic video editor for my YouTube channel. Channel will be focusing on reviews, advice, business and behind the scenes. Looking for someone I can slowly grow with! @AndreiRoman Key Responsibilities: - Edit videos to reflect a dynamic, fast-paced style - Incorporate text overlays and annotations at relevant points - Select and integrate appropriate background music and sound effects - Utilize transitions and visual effects to maintain viewer engagement The ideal candidate would be a skilled video editor with a good understanding of YouTube's format and viewer expectations. Experience with product review and unboxing content is a plus. A keen sense for energetic pacing and the ability to keep the content engaging through visual and

I'm in the process of starting a cleaning service business and need a WordPress expert to help me design a professional and corporate styled website. Key Features: - Custom WordPress Design: I want a modern, sleek, and professional looking site that reflects the corporate n...timesheet management. Ideally, the freelancer for this project should have extensive experience with WordPress and WordPress theme customization. A portfolio of similar corporate projects would be a plus. Good communication skills and a collaborative spirit are essential, as I want to work closely with you to bring this project to fruition. This will most likely be a situation where we together select a theme, and you will be editing the theme. Must be able to handle customizations and work efficiently ...

I am seeking a skilled and experienced professional or team to assist in the development of a new medical aesthetic device. Device Purpose: The device will serve multiple purposes including: - Skin rejuvenation - Body contouring - Lipo suction - Fat dissolving Technology: The device will utilize laser technology. Ideal Skills and Experience: - Expertise in medical device development - Experience with laser technology - Background in selling/ using aesthetic devices - Knowledge of the UK medical device market - Understanding of regulatory requirements for medical devices in the UK The ultimate goal is to sell the device to medical professionals who are practising in the UK. The device is not only effective but also safe and compliant with UK regulations. Your bid should reflect your un...

...NN, or N status, monthly lease payment, and lease term (in years). Option to hide sensitive details if requested by the seller/landlord, displaying "Inquire" instead. Excluded Pages: Omit Business listings, the News, Books for Sale, and Directory pages from the new website. Keyword Matching Algorithms: Develop algorithms for matching users with properties based on specific keywords like location, property type, and investment criteria. Design and Development Guidelines: No WordPress. Unique design (no templates or copied designs; must not violate copyrights). Present design concepts via Figma for approval before implementation. Beta test to ensure full functionality and stability before transferring to the live server. Final website ownership will belong to N...

I'm a financial advisor looking for an experienced telemarketer to help me convert leads into qualified prospects for investment management services. Criteria for Qualified Leads: - The primary criterion for a lead to be considered qualified is their interest in investment management. Ideal Skills and Experience: - Previous experience in telemarketing, particularly in the financial services sector, is highly sought after. - Strong understanding of, and ability to discuss, stocks and bonds. - Excellent communication skills, with a knack for engaging potential prospects. - Proven track record of lead conversion and sales. If you're capable of turning leads into valuable prospects, I would love to hear from you.

I'm in the market for a budget-friendly, utility category Android app, specifically a Task Manager. I am willing to pay less than 20 USD for a ready-to-upload APK, which I can later submit to the Playstore. Key Requirements: - The app must be a Task Manager. - It should come with the feature of Daily Reminders. If you have an APK that meets these criteria and you are looking to sell it, please get in touch.

...profitable and there is little local competition. This type of service is service oriented rather than HW/SW oriented. Also, goverment regulations mandate that organizations implement IAM solutions which presents an opportunity for us to capture this business. We identified 3 obtions for building the capability: a) Hire a team locally. More expensive but it might be more compelling for customers to select us if we have a local team. but it requires considerable investment. The challenge is that we dont have a clear sales pipeline provided by sales team. Therefore the company wants to be carefull with investment. b) hybrid model where we hire only 1 or 2 people locally and we partner with an offshore company on an annual basis where they dedicate resources to our company to use wh...

Create a tool that scrapes online business profile reviews for any business I input. Key Requirements: - The tool should allow me to input the name of a business with online reviews - It should capture ALL the reviews in a single excel document like the attached Timeline is 2 to 3 days

I'm looking for a video editor who can transform my real estate footage into a cinematic property showcase. The final product should be engaging, with smooth transitions, beautiful visuals, and a fitting musical score that enhances the viewing experience. Key Requirements: - Expertise in editing real estate videos - Proficiency in creating cinematic style video with music - Ability to select suitable, engaging royalty-free music Must include samples of REAL ESTATE VIDEO work in your application.

I need assistance with an Excel project where I am trying to find unique permutations of mixed data (text and numbers). Key Requirements: - Expertise in Excel, particularly in handling permutation matching. - Ability to work with mixed data sets (text and numbers). - Experience in displaying results in separate columns. I would like the results to be displayed in separate columns. If you have the necessary skills and experience to assist me with this project, please reach out.

I'm a student working on a project utilizing LightweightCharts by TradingView. I need a developer to assist me in adding bar pattern tool similar to the one in TradingView. Key Features Needed: - Users can select a range of bars (candlesticks) in two clicks. - The first click selects the start of the range. - The second click selects the end of the range and draws a pattern over the selection. - The pattern should be visualized over the selected bars and be draggable or editable. Requirements: - The tool should interact with other chart features. - The most crucial aspect of this interaction is the ability for patterns to be draggable and scalable. What I've Accomplished So Far: - I've successfully integrated LightweightCharts for displaying candlestick charts. - I...

I'm in need of a word-based logo using my name, and an initial-based favicon. The logo should be simple, yet elegant and in line with a classic aesthetic. It should also be easily recognizable and scalable for various uses. Ideal skills and experience for the job would include graphic design and branding expertise, with a strong portfolio of similar classic designs. Proficiency in design software such as Adobe Illustrator or Photoshop is also essential. Experience in creating favicons would be a plus. Please note that I haven't specified a font type or color scheme - but do have colours in mind, but also open to your professional recommendations.

I'm looking for a developer who can create an AR solution for a web-based, virtual glasses try-on experience. The AR should be realistic, but not overly detailed or animated. Key aspects: - The level of detail for the virtual try-on experience should be intermediate, meaning that overlays need to be realistic but not overly complex. - The solution should utilize computer vision for face landmark detection, and should use an AR framework for placing the glasses on the face. The ideal freelancer for this project should have: - Prior experience in designing and implementing web-based AR solutions. - A strong understanding of creating realistic overlays. Note: The resulting work should be similar to the solution here

...camera. A default user will be provided and other users will be pulled from a specified Excel file on the device. 2. Matching Activity: Users will scan three different QR codes, which the system will match. Each QR code has 4 fields, which the shall be processed and match logically. Add a container to add additional QR codes when a field does not match. once all matches, The user can press a button to save the record as an Excel file. There will be a Photo container that will lookup jpg file in device local folder, if one of the field from QR code is entered . 3. Report Activity: A simple list format for viewing saved data. Data Logged: The application will save user details and QR code data to Excel files in a specific location on the device. Ideal Skills: - P...

I'm seeking an adept professional with strong Excel and MySQL skills for a project centered around the creation and management of a database. Key Responsibilities: - Creating and managing a new database in MySQL - Entering and updating a mix of numerical and textual data in Excel Ideal Candidate: - Proficient in Excel with experience in data entry and updates - Skilled in MySQL, with a solid understanding of database creation and management - Capable of handling and effectively managing mixed data sets (text and numbers)

Arreglar el excel

I'm looking for an expert in web scraping who can extract product data from two specific e-commerce sites. I need the data to be organized in a well-structured Excel file, categorizing the products into 'product family', 'sub family', and 'product'. Key Requirements: - Extracting the 'Product name' and 'Price' for each product. - Excluding product images; scraping should only focus on product name and price. - Delivering the data in a clear, organized manner in an Excel file. Ideal Skills and Experience: - Proven experience in web scraping, particularly with Shopify and WordPress. - Proficiency in Excel and data organization. - Attention to detail to ensure data is accurately captured and well-structured.

I have a legacy Excel workbook developed over the last decade that I want to transform into a web-based platform. This will involve using the Excel workbook as an 'engine' in the background. The final product should include: - A web-based interface with user logins - Payment processing capabilities for licensing - An Admin dashboard - User analytics features - Integration of some AI elements, specifically natural language processing The platform should also have a user database where project details can be stored, allowing users to handle multiple projects and modify existing ones. Ideal skills for this project include: - Proficiency in web development - Experience with legacy system integration - Knowledge of AI, particularly natural language proc...

I'm seeking an Excel expert to create a comprehensive sales commission report. I receive monthly reports from my company, but they don't balance the commission sold versus the commission final at job completion. Key Requirements: - Creation of a report that can be used ongoing, allowing future data input - Each job has three commission payments based on billed/paid - The report should provide as much data as possible Data to be Included: - Sales amounts - Commission percentages - Job completion status - Cost - Price - Margin - Profit - Commission Rate - Commission amount sold - Commission amount executed - Commission due Ideal Skills: - Proficient in Excel - Experience with sales and commission reporting - Ability to create reports for CSV data import I ...

I'm looking for a freelancer who can create two report templates in Zoho Writer connected with our Zoho CRM data. The templates should be modeled after an Excel report design and tailored for client presentations, hence they need to be professional and easy to follow. The first report is 3 pages long, and the second one is 8 pages long. The templates should include: Essential Elements: - Data feed from Zoho CRM - Conditional formatting for certain text field The ideal candidate will have experience with Zoho Writer and Zoho CRM, as well as a clear understanding of creating business report templates. I've specific branding guidelines that need to be applied to the report templates, so the freelancer should be able to adhere to these closely. Skills needed for this pr...

I have a very tiny task that will take only 5 minutes for 5 virtual assistants from USA. All applicants will be considered and new freelancers are encouraged to apply.

I'm looking for a skilled video editor who can transform our 2023 summer vacation footage into a vibrant, emotional, and family-friendly 4-6 minute video. Key Responsibilities: - Organize video clips and photos from our travels to Albufeira, Oeste, and Sintra. - Select and incorporate 2-3 upbeat, family-friendly songs. - Combine clips and photos with fast cuts and dynamic transitions. - Use effects like slow-motion and color grading to enhance the visuals. - Add text labels for locations (e.g., "Albufeira - Algarve Coast"). - Focus on candid moments and natural family interactions. - Synchronize transitions and clips to the music’s rhythm. Final Deliverables: - A joyful 4-6 minute video highlighting the best moments of our summer vacation. - Rendered in 4K res...

I'm looking for a developer to create a simple, yet engaging location-based quiz/riddle app for both iOS and Android. Key Features: - Mobile phone authentication (OTP), with an option for Email logins. - The app will include hints for each riddle to assist players. - A riddle can be free or user need to pay (connect to payment gateway application) - A riddle (each mission) can consist of 1-20 pages/steps max. Each page/step can involve 4 types: Type 1 = Just an instruction (with no input given so they just have to press next) Type 2 = Numbers ONLY to be inputted (customised to input from 1-5 digits) Type 3 = (including numbers) ( 100 characters max) Type 4 = QR Code Scanned (which directs to another page/step or else finish the mission) Notes: - Each page can modify the font ...

I'm facing problems with my Laravel application. Specifically, I'm unable to create issues from the Admin panel, as they simply won't save. When I attempt to save an issue, nothing happens at all - the page doesn't reload nor do I receive a validation error. In addition to this, I also need assistance with importing an Excel file into my database. Ideal Skills and Experience: - Proficient in Laravel - Database management and Excel import experience - Strong debugging skills to identify and resolve issues - Familiarity with Admin panel functionalities in web applications.

I'm looking to create a subscription-based social media platform primarily focused on video content. The core purpose of this platform will be to entertain users with diverse vlogs, and I want it to include essential features like live streaming. Key Requirements: - Development of a video-centric social media platform - Integration of live streaming capabilities - Building an engaging and user-friendly interface Ideal candidates for this project should have extensive experience in social media platform development, with a strong portfolio of video-based projects. Knowledge of integrating live-streaming features is crucial. I am looking for a developer who can create an interactive, entertaining, and easy-to-navigate platform.

I'm looking for a professional to create a PowerPoint presentation from my Excel data. The presentation will primarily focus on sales statistics, specifically sales by region. The visual representation of the data will be in pie chart format. Ideal skills for this project include: - Proficiency in Excel for data extraction - Expertise in PowerPoint for presentation creation - Ability to create clear and engaging pie charts - Experience in sales report preparation The final output should be a well-structured and visually appealing PowerPoint presentation that effectively communicates the sales data.

I'm in need...Medium, Hard, and Extreme. Key features: - A table (without borders) below the puzzle displaying numbers 1 to 9, with options for undo, hint, and solution. - A timer positioned above the puzzle. - An option to select a difficulty level and subsequently generate and print multiple Sudoku puzzles onto an 8.5x11 inch PDF file. - Compatibility with both desktop and mobile browsers. - A modern design interface. - Daily Sudoku challenges. - A leaderboard to track player scores. Ideal skills and experience for this project include: - Proficiency in game development, particularly web-based games. - Experience in creating modern, user-friendly game interfaces. - Knowledge in implementing features like daily challenges and leaderboards. - Ability to ensure cross-p...

I want to make an excel FILE template to make sure I have enough enough staff available cover the work duties The staff will provide services according to below Market sessions Saudi Days: Sunday to Thursday Session: 11:00 AM – 3:30 PM Daylight Saving Time: Not applicable UAE Days: Monday to Friday Session: 10:00 AM – 2:00 PM Daylight Saving Time: Not applicable London Days: Monday to Friday Session: Standard Time (October to March): 11:00 AM – 7:30 PM (AST) Daylight Saving Time (March to October): 12:00 PM – 8:30 PM (AST) US Days: Monday to Friday Session: Standard Time (November to March): 5:30 PM – 12:00 AM (AST) Daylight Saving Time (March to November): 4:30 PM – 11:00 PM (AST) I want to make excel template to -plan and track staff...

I'm in need of a Microsoft Power App that connects to an Excel sheet for creating data entries across 6 columns. The data entries will be a mix of text and numeric values. Key Features: - Mixed data types: The app should allow for both text and numeric entries. - Some predefined options: Certain columns will require dropdowns or fixed options for text entries, while others will be open for free text. - No numeric validation: There are no specific rules or range limits for the numeric entries. Ideal candidate should have: - Proven experience in developing Microsoft Power Apps. - Strong skills in Excel, particularly in setting up sheets for data connection. - Ability to create user-friendly interfaces with dropdowns and fixed options. Please include exampl...

I need a website capable of displaying product images from a database and asking potential customers a series of questions to generate a quote for painting services. Key Features: - Display of product images - Interactive customer questionnaire covering service preferences and contact information Design: - I already have a specific design for the website Ideal Skills: - Web Development - Database Management - User Interface Design - Familiarity with e-commerce structures Experience: - Prior experience in building interactive quoting websites is a plus. My added description: the web site is very simple always a "register" button that will ask name, tel#, eMail ; location, location will be a drop down filled from the database, appt number. This page will have 2 buttons one co...

I need assistance extracting data from PDF files into a structured Excel table. The data is primarily in table format and the formatting is consistent throughout the document. Ideal skills and experience for the job include: - Proficiency in Excel - Experience with data extraction from PDF - Attention to detail - Ability to follow instructions carefully

Hi there - I'll deliver the file as we've discussed by VBA in Excel. Thanks for your trust!

I need a web-based order management system that allows for order placement and delivery tracking. Key Features: - Order Creation: I should be able to create orders and attach necessary documents for each order. - Spreadsheet Import: The system should allow for importing a spreadsheet to link different shipments to various open orders. - Shipment Handling: My store boy should be able to scan shipments, review them, and either accept or reject them. - Document Upload: The ability to upload a PDF sheet related to daily deliveries is required. - Tracking: I want to monitor which shipments have not been received, particularly those delayed over 10 or 15 days. Ideal Skills: - Experience in developing web-based management systems - Proficiency in creating user friendly interfaces...

I need an experienced professional who can link two separate Microsoft Excel Online sheets. The requirement is as follows: - One-way Data Sync: The first sheet (Sheet 1) should automatically update the second sheet (Sheet 2) whenever there's a change. It's crucial that this sync does not interfere with the sheets' existing functionality, colours, or any other design elements. - Data Type: The primary data being used in these sheets is a combination of text and numbers. Please ensure that the integrity of the original sheets is maintained and their visual aspects remain unchanged post-sync. I am looking for someone with proven expertise in Excel Online and data synchronization. Your bid will be considered more favorably if you can provide examples of similar p...

I require assistance with data entry into an Excel sheet. The data is currently stored in databases and consists of a mix of numeric and textual information. The data needs to be categorized by department in the Excel sheet. Ideal skills for this job include: - Proficiency in Excel - Experience with data entry - Ability to categorize data effectively - Attention to detail - Familiarity with databases

...Python - Experience with Interactive Brokers platform - Knowledge about different types of trading orders Ideal Skills: - Python programming - Trading experience - Interactive Brokers expertise - Order placement automation I am looking to hire a pythan trading expert, You need to automate trade in Shoonya Broker Account, Automate the buy sell order, It has lots requirment I have attached excel file to fetch and update data, and automate trade, I can choose any interval, It need to fech candle data, more detaiil i wll give if you can provide result with my budget, Not your Expectation If you accept my term apply this task: Budget:Rs 900 I will give good review, if you complete my budget, Dont expect more money, Money will paid after complete the job successfully, dont ...

I am on the lookout for a seasoned Senior Full Stack Developer who has a strong emphasis on Java development and is well-versed in both backend and frontend technologies. The perfect candidate will possess: - A minimum of 7 years experience in full-stack development. - A profound comprehension of databases, especially MongoDB. - Proven ability to lead...candidate will possess: - A minimum of 7 years experience in full-stack development. - A profound comprehension of databases, especially MongoDB. - Proven ability to lead and mentor teams. Technical Skills: - Expertise in React for frontend development. - Extensive experience with MongoDB as the primary database technology. - Proficient in developing Web applications. If you believe you meet these criteria, please send me a Direc...

Creation of a copy-trading bot on Solana chains. Frontend website (domainname needs to be chosen) needs to be developed with the following options: - Login with 2-factor authentication (after creating an account, and Google Authentication) - Creation of a new Sol address. (on chain), when the user had created the account. This wallet will then be used to trade with after a deposit is made. - The user must have the possibility to withdraw/deposit in the user section of the account. Also, it must be possible to export the private key - The user needs to have the following options on the Copytrading tab/section: o Tag for the specific wallet which is copied. o Target Wallet Adress o Buy Percentage (of the initial wallet) o Max Buy: for example, 0.5 sol o Minimum Buy: for example, 0.4 sol o T...

I'm seeking a dedicated virtual assistant to assist with my e-commerce business. Your primary focus will be responding to emails, managing my Shopify store, and helping with Excel/reporting tasks. Key Responsibilities: - Responding to emails promptly and professionally - Checking off orders and ensuring accurate processing - Updating pricing on Shopify - Adding new physical products to my Shopify store - Filing emails correctly for easy access - Assisting with data entry tasks in Excel and other reporting software Ideal Skills: - Experience with Shopify - Proficient in Excel, particularly with data entry - Excellent English email communication skills - Detail-oriented with a focus on accuracy The ideal candidate should be comfortable working with physical good...

I'm looking for a Tally expert who can customize an automation script for me. The script should be able to import various data fields from an Excel file into Tally. At present we have to import the goods receipt data from excel file and material issues from excel file. The automation script should be robust and capable of handling errors and exceptions during the import process. Therefore, detailed error handling is a must. Your expertise in Tally and experience in creating automation scripts will be critical for the success of this project.

I'm creating immersive brand experiences powered by my 3D expertise, and I need a skilled web developer to collaborate with me on building these web-based AR experiences. Key Responsibilities: - Develop web pages that host these immersive, AR experiences. - Collaborate in creating these experiences from a technical standpoint. Ideal Skills and Experience: - Proficient in web development with a strong understanding of creating AR content. - Experience with developing interactive web pages. - Knowledge in 3D modeling and understanding of 3D assets is a plus. - Experience in working with QR codes for user access. The goal is to provide users with basic interactions, such as viewing objects in AR, through a simple scan of a QR code. Your expertise will be crucial in helping bra...