Google sheets copy row to another sheet based on cell valuedela

Monthly Seo Ongoing With weekly work reports and google ads for

I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column ...

I'm looking for an experienced domain broker to assist with selling a high-value domain in the technology industry. Key Points: - **Domain Expertise**: Familiarity with the technology niche is crucial. Understanding of the potential buyers and market, as well as the ability to articulate the domain's value. - **Negotiation Skills**: Proven ability to negotiate and secure high-value sales. Past experience in selling high-end domains would be a significant advantage. - **Professional Network**: A well-established network in the tech industry, particularly among potential domain buyers, would be highly beneficial. - **Confidentiality**: Ensuring all transactions are handled with the utmost discretion and confidentiality. I have a target p...

...and motivated Google Ads and Facebook Ads Specialist to join our dynamic marketing team. The ideal candidate will have a proven track record in managing and optimizing paid advertising campaigns on Google and Facebook to generate high-quality leads. You will be responsible for strategizing, executing, and analyzing ad campaigns to drive conversions and achieve business goals. Responsibilities: Campaign Strategy and Planning: Develop and implement comprehensive lead generation strategies using Google Ads and Facebook Ads. Conduct market research to identify target audiences and create detailed customer personas. Set clear objectives and KPIs for each campaign to measure success. Ad Creation and Management: Design, write, ...

...with basic CSS, and Figma designing. **Preferred Qualifications** - Proficient understanding of TypeScript with ReactJS - Working knowledge of Tailwind CSS - Able to replicate Figma design to React code. - Experience in optimizing components for all browser platforms - Strong portfolio of both front-end and back-end development **What We Offer** - Competitive compensation package with an attractive hourly rate - Collaborative, fast-paced work environment - Opportunity to work on a variety of exciting projects - A supportive team that values your input and creativity If you are passionate about technology, constantly seeking to learn and improve your skill set, then you are the type of person we are looking for! We are offering superb career growth...

...with persuasive sales skills and familiarity with the digital marketplace. Your mission, should you choose to accept it, will be to sell a wide variety of '.com' internet domain names - approximately 150 in total. Here's what you'll need to do: - Present domain names to potential buyers * Examples: , , - Be able to familiarize yourself with the full list of domain names when making sales. Key Notes: - This is a commission-based role, and I intend to reward successful sales generously. - No website design or layout is required as the sale is purely for the domain names. - There are no specific keywords or phrases related to the domain names as they cover an extensive range of subjects. Ideal Candidate:...

...talented designer to create a minimalist and modern facade for my clothing store. The design should be both aesthetically pleasing and practical, reflecting the essence of a contemporary retail space. Key Requirements: - The selected materials for the facade are Glass, Metal, Wood, acp, aluminium pipe, and acp alternate sheet. Experience with these materials is a must. - The desired color scheme for the facade includes violet (#47143d), golden (#b99750), and white (#ffffff). However, I'm also open to other corporate-looking 3-color palettes. Store dimentions: Height- ground level to ground floor roof= 12 feet, remaining till top= 44 feet, total = 56 feet Width- 50 feet wide (at only ground floor, there are 2 shops having front space of 25 feet each) {r...

I'm in need of a proficient CSS Animation expert, comfortable with both vanilla JavaScript and React. Your task will involve...JavaScript and React. Your task will involve incorporating specific animation effects into a project. Key Features: - Apply 'Fade in/out' and 'Rotate' animation component based on the value of the a sliding scale. - Work uniformly across both mobile and desktop devices. Ideal Skills: - Expertise in CSS and SVG animation - Familiarity with vanilla JavaScript and React - Strong understanding of responsive web design and development Flexibility in your use of vanilla JavaScript or React is preferred since I have no strict preference between the two. Anticipate demonstrating your ability to innovate and effectivel...

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

I'm looking for a skilled android developer to create a professional application for me. The app will be targeting professionals as the primary users. Key Features: - User Login and Registration: The application should allow users to create accounts and log in securely. - In-App Purchase Functionality: I'd like to have the option for users to make purchases within the app. - Push Notifications: The app needs to be able to send notifications to users. Design: - I want the icons in the app to be designed in gradient and pastel shades. These should be visually appealing yet suitable for a professional audience. Ideal Skills: - Proficiency in Android app development - Experience with in-app purchase integration - Ability ...

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.

I need a general audience-focused, 800-1000 word article on club chair office furniture. The article should provide a comprehensive overview of the design, comfort, ergonomics, and durability of club chairs for office use. Key Points to Include: - Design and Aesthetics: Describe the aesthetic features of club chair office furniture and how they contribute to the overall appearance of an office space. - Comfort and Ergonomics: Highlight the comfort levels and ergonomic designs of club chairs, explaining how they can improve workplace productivity and employee satisfaction. - Durability and Quality: Emphasize the durability and quality standards of club chairs to ensure long-term use and value for money. - General Information: Provide general and informat...

...that introduces the reader to the world of large conference tables. This article should be between 1,200 and 1,500 words, and provide a mix of information and benefits that really sells the concept of these tables. Key Points to Cover: - Introduction to different types of large conference tables available in the market - Factors to consider when choosing the right large conference table - Benefits and advantages of utilizing large conference tables in a professional setting - Article needs to reference l3-5 links which will be provided upon awarding the project The target audience for this article is general, so the content should be approachable and informative to all readers. The tone should be professional and engaging, keeping the reader i...

Upload application on google play console.

I require an adept senior-level Chartered Accountant/Chief Financial Officer (CFO). My ideal candidate will maintain resp...ideal candidate will maintain responsibility for: - Rigorous financial reporting - Diligent budgeting and forecasting - Effective cash flow management -Supervision of existing staff to facilitate GAAP processes and timely monthly close processes A deep and demonstrated understanding of auto parts industries is non-negotiable. With your experience, you will add significant value to my company's financial standing and strategic growth. Proven track record in similar roles is highly valuable. You will be working remotely, using the data we provide and other data that you gather to advise our leadership team on all financial matt...

I am seeking an experienced programmer, whose task will be to integrate the Trilliant Provider Directory API into another system. Must have experience with Trilliant and Databricks. It's noteworthy that I am open to working with a freelancer proficient in any programming language. Ideal qualifications are: - A solid general programming background - Experience with API integration - Capable of interpreting and applying API documentation The API must deliver the following functionalities: - Ability to search providers - Retrieve provider details - Seamless integration with another system Freelancers who demonstrate evidence of past experience particularly in Trilliant / Databricks API integration will be highly considered.

Se solicita asistente administrativo para descargar contenido y organizarlo. Debes tener tu propio google drive para compartir la carpeta. Debes tener conocimiento en google sheets y google adwords, debes ser una persona comprometida, cumplida y responsable. Es un trabajo sencillo pero requiere dedicación. La tarea solo requiere un día de trabajo. Pago: 25 euros Requisito: Idioma nativo: Español

I'm seeking a proficient mobile application developer to construct a ride booking app similar to Ola, Uber, or Rapido. This application needs to be created and optimized for both Android and iOS platforms. Key Features Required: - Implementation of GPS tracking to facilitate real-time location tracking - Integration of a payment system to make transactions seamless and secure - Incorporation of a user rating/review system to maintain a standard of service The potential developer should have substantial experience in the above-mentioned areas. Furthermore, the ability to schedule rides in advance is another functionality I'm looking for in my application. This feature should allow users to plan their trips ahead of...

I'm seeking a skilled developer to create a versatile e-signing utility. This tool should allow users to select the DSC ( usb token) inserted to 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) -...

I'm doing the google ads setup and have a campaing already but it's not visible Need help through team viewer to set it up and see the clicks as I did earlier.

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

I'm looking for a professional to perform a comprehensive SEO audit, with a focus on Google, for my website. The ideal candidate should have: - Strong expertise in SEO, particularly Google optimization - Experience in identifying and resolving technical SEO issues - Ability to work with minimal analytics and previous SEO reports Key objectives for this project: - Identify technical SEO issues: My website has been live for a while but is not getting any search traffic. I need a thorough review to pinpoint any underlying technical issues that may be hindering its search visibility. - Recommendations for improvement: Based on the findings, I would like actionable recommendations on how to improve the technical SEO of...

I'm searching for a talented designer capable of re-creating an existing brochure for my renting kitchens company. I have an example brochure to use as inspiration, but certain elements must be changed to make it unique. These include: - Layout Modifications: Rearrange sections or resize elements to create a fresh look, avoiding a straight copy from the example. - Color Scheme Alterations: Implement different hues aligning with our branding. - Graphic Changes: Replace images or graphics with ones that better reflect our company identity. Ideal candidates should have a keen eye for design and a portfolio showcasing their proficiency in creating distinct and engaging brochures. Experience in interior design or kitchen related fields is a bonus. Please reply...

I am in need of an experienced video editor to help me replace a face in 4-6 scenes of my video with another face. The ideal candidate will have a good eye for detail and the ability to make the replacement look as natural as possible. Key Requirements: - Replace face in 4-6 scenes - Make sure the replacement looks natural - Deliver high-quality video editing work Skills & Experience: - Proven experience in advanced video editing - Familiarity with face replacement techniques - Ability to seamlessly integrate new face into scenes - Strong attention to detail Please provide examples of similar work you've done in the past. I'm looking to hire someone who can deliver high-quality work within a reasonable timeframe.

I've created an Android app and n...seeking a skilled developer who has experience with Google Play Console to deploy this app for me. Key Project Requirements: - The app is ready for deployment, so the main task is publishing it on the Google Play Store. - The developer should have a deep understanding of Google's app deployment process and the ability to navigate the Google Play Console efficiently. Ideal Skills: - Proficient in Android app development and deployment. - Prior experience with Google Play Console. - A good understanding of app store policies and guidelines. - Strong communication skills to ensure a smooth deployment process. Please note that I currently don't need assistance with creating promoti...

...are seeking a highly organized and tech-savvy Virtual Assistant to join our team for a 6-month fixed contract, with the possibility of renewal in 2025 based on performance. The ideal candidate will have experience with content creation and management, using tools such as ChatGPT, WordPress, and social media platforms. This role is perfect for someone who is passionate about technology, fashion, beauty, lifestyle, and the metaverse. Responsibilities: -Assist in planning and executing a comprehensive content calendar for our blog, podcast, and social media channels (LinkedIn, Instagram, TikTok). -Create engaging and high-impact content, including blog posts, social media updates, and podcast summaries. -Conduct thorough research on current trends in tech, fash...

Develop an WhatsApp bot to sell to our clients, based in IA chat and voice like Twillo, with Integration of the clients CRM/ERP's so that the bot can answer to the client with human language. with the Intranet. 2 When the CUSTOMER CALLS DETECT FROM AND Customer or not. 3 Hello Mr (name of the client) , how are you? 4. Hello, we have verified that you are not yet our Client 5 . What do you intend. 6. Speak to Our Commercial Department: Technical department Another subjects. After answering the questions, read our intranet If there is no response, I will pass it on to my colleague and pass it on to Human.

...selected. Another issue is related to the language, it should be in Spanish, but wocoomerce is showing in English instead If the developer can fix this, there are a few small changes required to the implementation. You can check this on Key requirements: - Expertise in WordPress and WooCommerce: The ideal candidate should have a strong background in dealing with these platforms and resolving related issues. - Theme compatibility resolution: The theme I'm using isn't displaying correctly on every device and poses a challenge for me. Therefore, I need someone who can ensure the theme works seamlessly across all devices and is compatible with the latest version of WordPress. Communication: - I prefer to use an instant messaging platfor...

Hi, Looking for a person to create an spread sheet monthly for sales records during that month. Will need to take information off of individual sales order sheets/emails and transfer it onto a spread sheet... buyer/address/item(s) they bought/amount they paid etc. Will be a reoccurring task per month. Will pay per month, expecting 100-200 sales per month. Please show rate per entry.

I need assistance in integrating an automatically generated Order ID within my Google Forms. Many people do it so, AT THE END the form, it will generate an ID number that will go into the Google Sheet where the responses go. In this case, I need it to be in form of a Short Question INSIDE THE GOOGLE FORM, Not at the end. So this way, the number generated will be part of the info the client sunbmits like Name, Phone Number, Zip Code, etc. Please ask questions before agreeing to begin.

...a reliable professional to help me with monthly inventory updates from the dealers and the sales department. Key Tasks: - Quantity Update: Ensure all stock levels are accurately reflected in our records. - Product Description Update: Make sure all product descriptions are up-to-date and accurate. - Product Code, UOM (Kit/Vials), Rupee Value: Cross-check and update product codes, Unit of Measure (Kit/Vials) and Rupee Value accordingly. Format: I have a specific format that the inventory updates need to be in. You will need to use this template to ensure data consistency and compatibility with our existing systems. Frequency: This is a monthly task and I would need your support on an ongoing basis. Ideal Skills: - Proficiency in...

...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. - Possess a keen e...

I am seeking a skilled developer to create a comprehensive multi-vendor e-marketplace. It should allow users to upload items for sale or auction - a feature thoughtfully designed like a chat system to facilitate communication before purchases is a must. It should also allow the ability for users to be ranked and achieve different tiers for purchases completed and track volume / dollar value of total transactions to date. Key Requirements: - Design: The interface should be clean and minimalistic, delivering a user experience that is simple yet effective. - Categories: The e-marketplace will need to cater to "Clothing and Accessories". - Seller Profiles: Profiles should be feature-rich, including options for ratings and re...

...digital advertising company based in Israel, seeking a talented and creative freelancer to join our team. We need a skilled copywriter and designer to create compelling ad banners in English for various advertising campaigns. Responsibilities: Write engaging and persuasive copy for advertising banners. Design visually appealing and effective ad banners. Collaborate with our marketing team to ensure the ads align with our branding and campaign goals. Meet deadlines and manage multiple projects simultaneously. Requirements: Proven experience as a copywriter and banner designer. Strong portfolio showcasing previous work in advertising. Excellent command of the English language. Proficiency in design software such as Adobe Photoshop, Illustrator, or si...

As the client, I am looking for a skilled audio editor who can add value to my project with their expertise in creating seamless transitions between audio segments. My main objective is achieving a consistent, smooth sound for my audio files. Here are the main tasks involved in the project: - Conduct concise audio editing on the provided files. - Implement crossfade for the transitions to create a uniform sound throughout. The perfect freelancer for this project will have significant experience in audio editing and specialize in creating smooth crossfade transitions. Prior experience with professional audio production and a great understanding of minimising noise interference will also be highly beneficial.

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

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

Responsibilities: Develop and execute a Twitter growth strategy. Create engaging, explicit content aligned with our brand. Analyze metrics and optimize strategies. Cultivate relationsh...Twitter growth strategy. Create engaging, explicit content aligned with our brand. Analyze metrics and optimize strategies. Cultivate relationships with influencers and partners. Stay updated on Twitter trends and features. Requirements: Proven social media experience, especially on Twitter. Deep understanding of Twitter's platform and algorithms. Creative and analytical mindset. Comfortable with explicit content. How to Apply: Submit your resume and a brief cover letter showcasing your relevant experience and successful Twitter campaigns. We value diversity and encourage...

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 looking for an SEO expert to optimize my website for Google search engine rankings. The primary focus will be on improving the visibility and ranking of our product pages. Key requirements: - Demonstrable experience in SEO, particularly with a focus on Google. - Strong understanding of on-page optimization techniques. - Proven track record of improving search engine rankings for product pages.

...programmer who is able to Build arduino code for a Waveshare ESP32 s3 Touch LCD 4.3 and recognize data from I2C ADS1115 interface a display grafically Display have to rappresent data in 4 different page changeable touching icons placed in down part of display In each page are displayed more rounded bar with % value received from 3 x ads1115 i2c connected Key Responsibilities: - Program the ESP32 to recognize and interpret the data from the I2C ADS1115 sensor module - Integrate a responsive touchscreen control and an LCD display on the Waveshare ESP32 s3 Touch LCD 4.3 - Ensure the system is user-friendly and able to display the sensor readings accurately - Implement the system in a way that is easy for someone with an intermediate level of pr...

I'm looking to create a Facebook ad campaign to find a missing person last seen in a public space. This project calls for a strategic approach to deliver the message across all relevant audiences. Key requirements include: - Compelling Ad Copy: The ideal freelancer should have strong copywriting skills, able to craft engaging and compassionate text that effectively communicates the urgency of the situation. - Targeted Outreach: Experience in defining and reaching specific demographic groups on Facebook is key. They must optimise the campaign to maximise visibility, specifically for those located in the same area as the public space where the person was last seen. - Customer Engagement: They need abilities to handle potential ...

i have Pojo class where it is picking property value from api response as integer in the Pojo Class: @JsonProperty("intensity") private Integer intensity; public Integer getColor() { return color; } public void setColor(Integer color) { = color; } and in parser class (INTENSITY, ((), 0)); The problem is sometimes the Api giving the color value as string not as interger but only on on checkbox config we add and this already defined in java if(checkVariant is true) then consider it string and parse it what i have to do to fix my code based on that condition so i can parse the string value this way: updateProperties("color", ((), ));

I need an in-depth SEO report, comparing my website to a competitor's on Google. This is an urgent task that needs to be completed ASAP. Key Aspects to Compare: - **Keyword Rankings**: I want to know where my website stands in comparison to my competitor's in terms of keyword rankings. - **Backlink Profiles**: A thorough analysis of backlink profiles for both websites is crucial. - **Site Structure and Content Quality**: Lastly, the report should assess the site structure and the quality of content on both sites. Experience and Skills: - **SEO Specialist**: I'm looking for someone with a strong background in SEO, particularly in competitor analysis. - **Data Analysis**: The ideal candidate should be proficient in d...

...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 of logo w...

I am blending Google Sheet data with Google Ads and Analytics data but getting an error message. Need someone to help via screenshare. Thanks!

...for an experienced developer to create a Hangman game using React and utilising a specific API for generating 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 ...

I need a virtual assistant for a daily one-hour task to input visitor information into a Google Sheet. Key Requirements: - Attention to Detail: It's important that all information is entered accurately and completely. - Manually need to collect data from various source Ideal Candidate: If you are a detail-oriented individual with prior data entry experience and can commit to a daily one-hour task, I'd like to hear from you.

...professional familiar with Google Ads, Google Analytics, and Clickfunnels to assist with setting up conversion tracking on my Clickfunnels funnel. - Your primary task will be to configure Google Ads conversion tracking through Google Analytics and Google Tag Manager on my Clickfunnels website. - I've already set up Google Analytics on my Clickfunnels website, so the main focus is on the conversion tracking aspect. - The specific event I'd like to track is Calendly bookings on my funnel. It's crucial for me to monitor the number of Calendly bookings generated through my Google Ads campaigns. Your expertise in the following areas is essential for this project: ...

...SEO expert to enhance my Google profile. Here's the full scope of the project: - **Keyword Optimization**: My website currently has a moderate ranking on relevant keywords. I need you to optimize the keywords for better search engine visibility. - **Profile Updation**: I'm looking to update my Google profile to better cater to local customers. This may involve changes in the description, contact information, or other details to make it more appealing to my local audience. Ideal candidates for this project should have: - Proven experience in SEO and Google profile optimization - A strong understanding of keyword research and optimization - The ability to analyze and act on the current s...