How to sum values based on criteria in another column in excel vba jobs

I am in need of a portrait photographer, specializing specifically in corporate headshots. These professional images will serve a critical purpose in reinforcing our corporate identity. The ideal freelancer for this project should have: - A proven track record on capturing professional, high-quality corporate headshots - A solid understanding of lighting, composition, and editing techniques - The ability to create a comfortable environment to bring out the best in those being photographed. Remember, your professionalism and attention to detail can significantly impact the first impression our company makes. Hence, if you are confident and match above-mentioned criteria, I am looking forward to viewing your proposal.

Key Features: - Online Booking: Parents should be able to make, alter, and cancel their bookings with ease.

I require a skilled photo editor who specializes in faces for an intricate job. The task includes: - Replacing a face with another face - I have already selected and provided the replacement. - High attention to detail in the replacement is essential, ensuring that the replaced face maintains distinctive textures, precise skin tone, and features. Ideal candidates will have substantial experience in photo retouching and color correction, ability to handle background removal with finesse, and must demonstrate proficiency in maintaining high levels of detail in their work. Portfolio showing past face replacement edits is highly desirable.

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

...digitized and transformed into an Excel spreadsheet. The document consists of approximately 238 pages, and I require the following: - Organization: Calls, texts, and data should be separated into distinct columns in the spreadsheet. - Data Layout: The information should be laid out in an ordered manner which we will discuss further. Additional requirements include: - Calculations: The Excel sheet should include specific calculations like total call duration and data used. - Data Fields: The "To/From", "City", and "Time" fields should be organized in distinct columns within the spreadsheet. Ideally, I'm looking for a freelancer with: - Proficiency in PDF to Excel conversion. - Strong org...

I'm seeking a proficient ...opportunities - The grants of interest are: Government grants, Non-profit organization grants, and Research grants. - The proposal aims to secure funding for the support of research and development within my organization. The ideal candidate will have a demonstrable track record in successfully obtaining such grants, particularly in the spheres of government, non-profit organizations, and research. They will also demonstrate a strong understanding of the criteria required to meet the expectations of these grant bodies. Experience in crafting compelling narratives that effectively communicate the project goals and desired outcomes is also highly desired. Associated skills in writing, editing, and research...

I need a diligent freelancer to copy and paste text for me. Key Project Details: - Copy and Paste: The task involves copying text from one source and pasting it into another. - Source of Content: The text will be sourced from various online platforms. - Timeframe: I need this task completed urgently. Ideal Freelancer: - Attention to Detail: It is crucial that the text is copied accurately. - Speed: Given the urgent nature of the project, a quick turnaround is essential. Please provide your experience with similar projects and your availability.

Please Sign Up or Login to see details.

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

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

...report feature to the existing system. This report should include specifics on debit and credit transactions. Key Requirements: - Prior experience with the Ultimate POS script - Proficiency in Laravel Livewire - Strong understanding of accounting principles The Ledger Report: - The ledger report should have a user-friendly interface and should be able to filter transactions based on specific criteria. - Transactions should be classified as either debit or credit, which should be reflected in the report. Deliverables: - A functional ledger report integrated into the Ultimate POS script with the ability to classify transactions as either debit or credit. - A clear and well-organized codebase that allows for any future modif...

I'm looking to build a robust web-based color prediction application with additional features crucial to its success. This includes a user registration/login system, real-time data analytics, and payment gateway integration. The app will also require seamless integration with specific game APIs such as live casino, betting, and potentially others. Key Requirements: - Development of a web-based color prediction application - Implementation of user registration/login system - Integration of real-time data analytics - Seamless payment gateway integration - Integration with live casino and betting game APIs - Potential for additional API integrations Ideal Skills: - Web development expertise (React.js, Node.js, etc.) - Strong experience with real-time data a...

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

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

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

I'm seeking a developer to create a comprehensive members' social media software. This software should be responsive and functional across both web and mobile platforms. Key Functionalities: -Instant messaging: Members should be able to privately communicate with one another. -Photo and video sharing: A core function should include the sharing and commenting of multimedia content. -Blogging and forums: Members must have the ability to write posts and create threads for discussions. The platform should optimally support a user base of 1,000 to 5,000 members. Applicants should have a robust background in social media software development and be experienced in implementing the functionalities listed above. An understanding of scala...

I'm looking to create a comprehensive web-based accounting software with essential features that will allow me to manage my finances, track inventory, generate GST reports, and handle billing. This software should also support up to 5 users. Key Features Needed: - Financial Management: The software should offer robust financial management functionalities to help me track and manage my finances effectively. - Inventory Management: A sophisticated inventory management system is required which involves product categorization, stock monitoring, and purchase order tracking. - GST Reporting: The software should have the capability to generate accurate GST reports in compliance with the relevant regulations. - Billing Features: I would requir...

I'm in need of a PowerBi expert to resolve a critical error for me. The error message reads: "Failed to save modifications to the server. The error returned: 'Relationship '59f250b2-ca16-47f4-8a50-ba4d8636a1ed' points to deleted column 'Setter 2' in table 'Bridge of Setter'." - Urgency: The task should be completed within 24 hours. - Documentation: I don't need any documentation on how the issue is resolved, just the solution itself. - Dataset Access: Unfortunately, I can't provide access to the original dataset. The expert will need to resolve the issue without it. Skills and experience required: - Proficient in PowerBI with experience in...

...allows the client to publish the product in a category (Example: Cards) and within this there are some associated subcategories (Example: Pokemon), we need to add another level of subcategory (Example: Pikachu SV4 2024). The scheme would look like this (Example: Cards->Pokemon->Pikachu SV4 2024). The main category already allows the creation of subcategories, it is necessary to simply create a second level of subcategories and the client cannot publish in subcategory level 2 only in level 3. The following is necessary: 1st. Create a second subcategory level linked to another subcategory. 2nd. In that second level of subcategory, at the top there appears an image of the category, a descriptive text and a graph...

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

...where I sell physical products. I'm looking to have the shipping costs calculated based on the distance to the delivery address, using postal/ZIP codes as the metric. Key Requirements: - WooCommerce Setup: Need someone who is well-versed in setting up eCommerce stores with WooCommerce. - Shipping Configuration: Experience in configuring shipping settings within WooCommerce, particularly for distance-based calculations. - Geolocation Skills: Proficiency in working with postal/ZIP codes to determine distances for shipping cost calculation. - Problem-Solving: Ability to troubleshoot and resolve any potential issues that may arise during the project. Your primary task will involve implementing a system that accurat...

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

...the creation of a print store catering to my printing business. This project requires the following: - **Printing Services:** The store should allow customers to order Business Cards, Flyers, and Brochures, so experience in setting up e-commerce for such products is essential. - **Design Preferences:** I'm aiming for a modern and sleek design for the store. It should be visually appealing, user-friendly, and align with the latest design trends. - **Customization:** Customers should be able to upload their own designs, so the store needs to integrate this feature seamlessly. Ideal freelancer for this job should have: - **Proven Experience:** I'm only considering candidates who have built similar stores in the past. Please provide ref...

I have a 120MB JSON file with nested objects, and I am in need of a skilled professional who can convert this data into a CSV format. Specifically, I require the following: - The nested JSON objects should be flattened into single columns in the CSV. - The column headers in the CSV should match the keys in the JSON file. The ideal candidate for this job should have: - Proficiency in handling JSON and CSV data structures. - Experience in working with nested JSON objects and flattening them. - Ability to accurately map JSON keys to CSV column headers. If you've successfully converted complex JSON files into CSVs before and you're confident in your ability to deliver clean, well-structured data, I...

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

I'm looking for a PHP expert to handle several minor tasks on my website. Key Responsibilities: - Implementing links from images to other pages. - Making the odd amend to the site - updating google maps code The work is quite straightforward and doesn't involve any major development. It's more about making small changes and ensuring the website works smoothly. Ideal Skills: - Strong PHP development skills. - Proficiency in HTML, CSS, and JavaScript. - Experience with integrating links and implementing simple changes. - Ability to understand existing code and make small tweaks. If you're a PHP developer who can quickly and efficiently manage these minor tasks, I'd love to hear from you. This may lead to ...

I'm in need of a talented game developer to create a mobile game for both iOS and Android, in the grinding genre. I will provide map converters and all necessary assets for the game. Key Features: - Multiplayer Functionality: The game should have the capability for players to interact with each other in-game. - Leaderboards: Implement a system for players to compare their achievements and progress. - In-app Purchases: Include a functioning in-game store where players can purchase virtual goods. As the project is mainly about implementing the provided mechanics, I'm looking for someone with experience in online game development, particularly in the mobile sector. In addition, knowledge of grinding game...

...notifications, and in-app purchase functionality. This is a high priority project, and I need it completed as soon as possible. I would like to model it somewhat after this application or similar noise applications - Key Features: - Social Media Integration: The app should allow users to share content on various social media platforms. - Push Notifications: The app should be able to send push notifications to users to keep them engaged. - In-App Purchase Functionality: There should be options for users to make purchases within the app. Design Preferences: - Bold and Colorful Design: I prefer a design that is vibrant and stands out. - Custom Branding Elements: The app should incorporate specific branding elements to...

...developer to incorporate bank transfer as a payment method on my existing website. Currently, my site only supports PayPal and I want to add another layer of customer convenience by allowing bank transfers. I need to be able to sell theater tickets, so an interactive sitting map should be available. While I haven’t decided yet on a specific bank or service for processing these transactions, I am open to suggestions. If you have prior experience with multiple processors, that would be a significant advantage. Ideal skills and experience: - Proven background in E-commerce website development - Knowledge of various payment processors - Understanding of safe and secure payment gateways - Ability to integrate n...

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

I am in need of an Articulate Storyline expert to create an exciting, interactive game-based learning module targeted at adults. Requirements: - The module should have a moderate level of interactivity, including quizzes and drag-and-drop elements - The content must be engaging and challenging for adult learners, it should be both informative and entertaining - Attention to detail is crucial, the module should flow well and be free from technical errors - You are encouraged to bring creativity and originality to the project, it should not be a standard, uninspired e-learning module Ideal Skills: - Expertise in Articulate Storyline is paramount - Experience in developing game-based learning modules is a major plus ...

I'm seeking a savvy developer to create a 1D barcode (UPC, EAN) inventory management system. This should then be integrated with an existing product management system. Key requirements: - Design and develop a user-friendly barcode inventory control system - Experience with 1D barcodes, preferably UPC and EAN - Capability to integrate with existing product management software The main users of this system will be store staff members. Therefore, it should be easy to navigate, and seamless in functionality to support a fast-paced retail environment. Expected expertise: - Proven experience in building similar inventory management systems - Proficiency in working with 1D barcode technology - Expertise in software integration - ...

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

I need a simple Android app that can automatically send messages to a WhatsApp group at random times. The app should: - Allow me to adjust the number of messages sent daily - Send messages at truly random times User Interface: - A simple UI for: - Adjusting the daily message count - Customizing the message content The app does not need to include analytics to track the number and timing of messages sent. More information: Can someone develop an Android app that can do the following: Automatically send a message in a WhatsApp group at random times. For example, send 3-5 messages per day at random times. The number of messages should be adjustable within the app. The messages should be sent between 9:00 AM and 10:00 PM (always at random times). The ...

I'm in need of an experienced web developer to help me create a Business-to-Consumer (B2C) E-commerce website using PHP and Laravel. Key Features: - Product Search and Filtering: It's essential that the site allows users to easily search for products and filter them based on various criteria. - Shopping Cart and Checkout: A functioning shopping cart that allows users to add products, review their selections, and complete the purchase process with ease. - User Registration and Login: Users should have the ability to create accounts and log in securely. This will enable them to track orders and save preferences. - Payment Integration: The site must be able to accept payments securely and efficient...

I'm looking for a creative logo designer who can hel...looking for a creative logo designer who can help me convey my company's values and mission, product or service offerings, and target audience in a single, modern and persuasive logo. Key Requirements: - Design a logo that conveys Company values and mission, Product or service offerings, and Target audience. - Utilize the colors Blue, Red, Gold, Black, and White. - Complete the project ASAP. Ideal Skills and Experience: - Proven track record of creating innovative logos that effectively communicate a company's core values and resonate with their target audience. - Expertise in using color psychology to convey specific messages through a logo. - Ability to work under t...

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

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

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

My company has a logo, recently I noticed a very nice brush effect on another company's logo that I want to apply to my current one. I have the reference so it should be very quick and straight forward . thank you, the reference is attached below

I'm in need of an adept web designer with experience in logo creation to construct an appealing and user-friendly informational website for my therapy business. The website should include: - A home page with a few critical pieces of information, namely: - A comprehensive business overview - Contact Information - Client testimonials to build credibility - Educational materials on different types of therapy services provided - An 'About Page' giving insight into our company's values, mission, and team. - A 'Services Page' detailing the range of therapy services offered. Bringing in some expertise in UX/UI design will be beneficial for this project. Proven graphic design skills, particularly log...

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

This is for my College final project, I need to develop a simulation of AI based threat detection.

I am seeking a skilled graphic designer to craft a professional, distinguished logo for my company, ABC. Operating within the real estate sector, the logo should reflect our business niche and encapsulate the trait of professionalism we embody. The perfect candidate will bring: - Expertise in logo designing. - Background in real estate branding a plus. - Ability to interpret and convert our company values into a visually appealing logo. - A thorough and detail-oriented working style. The project will involve: - Drafting of initial logo concepts. - Refinement and finalization based on the feedback provided. - Delivery of the final logo in required formats. I'm looking forward to taking our corporate image to the...

...starting a project to develop a QR code payment application called "Metropol Pay" that will run on the Android platform. The application will be designed to perform the following basic functions, with a user-friendly interface: get tokens QR code creation Payment inquiry Cancellation and refund procedures These functions will be exposed via AIDL and can be triggered via App2App from another application. The application will manage Metropol Pay's payment processes, show the user the QR code and query the transaction details. When opened, Metropol Pay will receive a token with a 5-minute validity period from a Token API, then generate the QR code and display it on the POS screen. The screen will be designed to be user-friendly and...

Please Sign Up or Login to see details.

Functionalities of Chrome extension : 1: scan any buttons fields used computer vision or openai vision or Google gimini to recognize fields or buttons 2: creator record macro auctions in same time record/uploading voice and notes 3:export files then shared the files with others that have same chorme extension Output: macro working without in others that have same extension 4: deployment on marketplace

I'm looking for a couple of strong individuals who can disassemble two platform beds in one room, move them to another on the same floor, and reassemble them. - **Task**: Disassemble, move, and reassemble 2 platform beds. - **Beds**: Platform beds. - **Accessibility**: No concerns, rooms are easily accessible. - **Equipment**: The beds are heavy, and the job will require at least two people. - **Timeline**: The task should be quick, but precision is key so wood doesn’t get damaged Ideal candidates for this job should have experience with furniture disassembly and reassembly, good physical strength, and timeliness in their work.

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

I'm in need of a professional designer to create a 24-page A5 booklet for my estate agency. I want the design to be traditional and elegant, as our target is to attract new potential clients. Key Requirements: - The booklet should be 24-pages long, a5 sized (6 a4 sheets folded in half to A5 size). - The design style should be traditional and elegant. Content: - I'm keen to include information on local property values in the booklet. This is crucial for potential clients who are interested in the real-estate market in our locality. Skills and Experience: - I expect the designer to have experience in creating similarly styled elegant and traditional designs. - A good understanding...