Google sheets filter data from another sheet jobs

...proficient in handling Outlook PST files and cloud storage services to relocate my PST folder from OneDrive to Google Drive. - I use Microsoft Outlook for email and have been encountering storage space limitations with my current setup. - The size of the PST file is between 2GB and 10GB. - The main goal of this project is to alleviate the storage issue while ensuring a seamless transition of my email data to Google Drive. Ideal candidates should have: - Strong experience with Microsoft Outlook, including handling and migrating PST files. - Proficient knowledge of both OneDrive and Google Drive to efficiently move the PST folder. - A clear understanding of data migration best practices to ensure all data is securely transitioned with...

I have an html form php file on my server. I would like a passcode (no username) adde...username) added to the form that captures the user connected to the passcode when the form is submitted. I would like the data sent to Google Sheets when a user submits the form. The Google sheet is complex. I would like the form data sent to 1 of 13 sheets. It should search for the sheet name, date, and user (from the html form) to find the correct sheet and row to insert the data from 5 fields. Can you help with this? We have an form in the laravel, these are three main tasks : 1) Secure the form with 6 code passcode. 2) Update the URL of the form. 3) Save the form data in google sheet. There ar...

I need an experienced web developer who can create an e-commerce website with a professional and corporate aesthetic, targeted at a middle-aged audience. The website needs to feature embedded subscription services, via API integration, from another website ("White Label"). Key requirements: - Design, create and host a professional Subscription site. - Integrate subscription services via API from another service provider. - The website should appeal to a middle-aged demographic. Ideal skills and experiences: - Proven experience in e-commerce web development and design. - Expertise in API integrations. - A strong understanding of target markets and designing with them in mind.

...seeking a skilled freelancer to help us capture high-quality screenshots and record demonstration videos of our mobile app for both Google Play and the Apple App Store. The freelancer should have access to both Android and iOS devices to perform the tasks effectively. Requirements: Screenshots: Android: Capture 10 high-quality screenshots showcasing all key functionalities of the app. iOS: Capture 10 high-quality screenshots for each device size: iPhone 6.7" iPhone 6.5" iPhone 5.5" iPad 13" iPad 12.9" Screenshots must be taken directly from each device; resizing from other screenshots is not acceptable. Ensure all screenshots comply with the guidelines of both Google Play and the Apple App Store. Screenshots should highlight the mai...

Hello, I am looking for a Google Ads expert to assist me with the following tasks: 1. Set up Google Analytics and Google Tracking. 2. Launch and manage a single Google Ads campaign. 3. Optimize the campaign for better performance. My monthly budget for this project is $100. If you are interested and believe you can meet these requirements, please get in touch. Thank you, Azmi

I am in need of an experienced SQL database administrator to help me move an entire SQL database from one server to another. The new server has Windows Server 2012 R2 installed and the SQL software is up and running. However, I am unsuccessful in attempting to access this via the network. Key Tasks: - Transfer the entire SQL database to a new server - Setup proper network access - Continue all ongoing operations from the source server on the new server Ideal Skills: - Rich experience with SQL and Windows Server 2012 R2 - Understanding of maintaining active operations during server shift - Firewall setup and operations Security isn't to be compromised during this relocation. The current server has a firewall in place for the SQL database that requires careful ...

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 inclu...WhatsApp group to take an alcohol test and post the video of the test in the WhatsApp group. The purpose is to monitor an individual with alcohol dependency to ensure they do not consume alcohol. The other members of the WhatsApp group will then review the posted video. These 3-5 prompts should appear at random times in the WhatsApp group each day. If it is too difficult to implement with WhatsApp, another messaging service could be c...

I need an expert to retrieve a missing Excel document from my Windows configured laptop. This document has been missing since February 2024, and I have no backup available. The document was created using an unknown version of Excel, so the freelancer would need to check the specifics during the recovery process. Key requirements: - Recover the missing Excel document which was lost for unknown reasons - No backup available - The document was created using an unknown version of Excel Skills and experience needed: - Proficient in data recovery - Experience in retrieving files from Windows systems - Familiarity with different versions of Microsoft Excel

SEO Audit tool need to make using google lighthouse Hello, 1, We want to make an SEO audit tool, by the help of integrating the google lighthouse to generate an SEO Audit report. Here is a link to how you can do it. Here is an example how these people have integrated and using google lighthouse to generate reports. We need exactly the same. 2, need an admin panel where admin can add or import the list of the website url,and website owner name , number and email address. So report can generated by the system and keep sending the email pdf report to the owner of the website like its work in front side for this site

I'm in need of a Bulgarian resident who can assist me in obtaining a certificate of fiscal residence from the Bulgarian tax office for my company. Your role: - You don't need to be the company owner, but you should be living in Bulgaria. - I don't have the legal authorization to obtain the certificate on behalf of the company, so you should have experience in navigating this process. - The certificate will be used for tax purposes in another country Ideal Skills and Experience: - Residency in Bulgaria. - Legal expertise in obtaining documents on behalf of a company. - A good understanding of the Bulgarian tax system (optional)

Google Business Profile We are looking for a Growth Manager who can grow us with his work and help in taking your business forward.

- Moving from Iubenda to Mirasvit (I will buy and install extension) - Fixing Alpinejs and Google consent exceptions (as seen on Firefox), double check exceptions cross browser. - Check Mageplaza blog (): for example it seems that is needed by extension, I removed it because is useless in frontend, but need to be double checked.

I am in need of a Flutter-based image editing tool that can perform specific functions. The main requirements for the project are: - Development of a tool that can work seamlessly on both Android and iOS platforms. - The tool must be capable of copying a part of an image and pasting it in another location. - It should support different image formats, ensuring compatibility with various image types. The user interface for the tool is expected to be: - Interactive: The tool should engage the users and provide smooth navigation. Ideal skills for this project include proficiency with Flutter, knowledge of image editing functionalities, and experience in developing user-friendly interfaces. Successful completion of this project will require a thorough understanding of the requirement...

...to review 50 past papers - containing approx 50 questions each. For each question, I need someone to: - cut & paste an image of the question into a Google slides / Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page number of Google Slides document that the question appears on Key Requirements: - The questions are from primary school level math exams, so a good understanding of these topics is crucial. - You w...

I need assistance creating a UA tracking ID for my Google Analytics account.

Hello, I'm looking for a professional developer who can create an app for Android camera that can receive live video streams from OBS and broadcast them directly onto the primary screen of the smartphone's camera. The app should be able to convert the stream sent from OBS into a format compatible with the phone's primary camera and display it in high quality. The app should be capable of playing the video directly without the need for an external application, but I need a skilled developer with experience in integrating with OBS and efficiently programming the app. The app should be compatible with the latest versions of the Android operating system. Please provide a detailed quote along with a timeline for delivery if interested. Thank you.

1 Need to build a website monitoring program to monitor changes in sub-pages of the landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monitoring 3 Filter duplicates and monitor changes in subpages of the website Set a custom time to refresh the web page

I already hired one person for this position but work is increasing so I am looking for a second one. A plus if you can do video editing or graphic design. I need a fully bilingual professional (I will interview in English via video) to do some tasks for my agency, such as: Social media Content editing or creating CRM management Email marketing Writing an ebook Researching Organizing data in spreadsheets Copywriting Basic Wordpress (change text, add a button, upload a file, etc) And others related to the position You must be a FAST learner, attentive to details, curious, with great writing skills. Looking for someone that pays attention and doesn’t keep making the same mistakes over and over. Attention to detail. Common sense. This job will part-time as a test peri...

Hi. On my shopify website the links tot the product page have gone missing. I need to urgently correct this. I also need to urgently set up another page titled events, and list two events on there like you would a product in the womenswear section. Can someone help with this today? I need it resolved by 5pm/Irish time. Thank you. Kind regards, Angela

i want a simple landing page like this : (is mine landing web) i need for another proyect a "whatsapp bot" Please fell free to contact me.

I'm in need of a skilled automation specialist to help me streamline and optimize a multi-step process that involves audio analysis and documentation. Key Responsibilities: - Develop a solution (on ) that initiates from an audio file recording and proceeds to: - Audio-to-text conversion using Google Cloud Speech-to-Text - Running the transcript through ChatGPT for analysis - Summarizing the outcome in Google Docs - Maintaining a daily list of patients' names in a Google Sheet Key Objectives: - The primary goal of this automation is to enhance productivity, allowing staff to focus on more intricate tasks. - All stages of this process need to be fully automated. Additional Details: - The daily list of patients' names will ...

Please Sign Up or Login to see details.

I have a sizable amount of numeric data that needs to be inputted from handwritten documents. This is a meticulous task that requires attention to detail as the data must be entered accurately. Key tasks include: - Transcribing data from handwritten documents into a digital format. - Ensuring the data is accurate during the entry process. Skills/Experience required: - Proficient in data entry, especially numeric data. - High level of accuracy and attention to detail. - Previous experience with handwritten document data entry is preferred. - Understanding and application of data validation techniques.

I'm looking for an expert who can run Google Ads from India to generate service inquiries in the UK. The target audience for this service is both businesses and individuals in the UK. Key Responsibilities: - Creating and optimizing Google Ads campaign. - Targeting both businesses and individuals in the UK. - Focus on generating service inquiries. Ideal Skills and Experience: - Proven experience in running successful Google Ads campaigns. - Understanding of targeting strategies for international audiences. - Previous work generating service inquiries. Looking forward to hearing from skilled professionals who can help me achieve my lead generation goals.

...can expertly run Google Ads campaigns targeting active pharmaceutical ingredient (API) marketing at multiple exhibitions. Key Requirements: - Proficiency in running location-based Google Ads: You should have a proven track record of running successful campaigns at pharmaceutical trade shows, industry-specific exhibitions, and across various countries. - Understanding of the pharmaceutical industry: Knowledge of the industry is a must, especially in relation to marketing APIs. - Worldwide targeting expertise: You will be tasked with targeting countries like the United States, China, Germany, MENA regions (Gulf Cooperation Council (GCC) and North Africa) and Latam regions (Mexico, Brazil, and Argentina). Your role will primarily involve: - Strategizing and executing G...

...tell me if it's possible to develop it: Based on the list of all the tokens, I would like to create filters that, based on a specific timeframe, tell me the minimum variation of X previous candles. I'll give you an example: Suppose that from the filter I choose - Timeframe 4h - Previous candles 3 - Minimum variation 20% The filter should return all the tokens that have generated at least 20% (e.g. 20%) for each candle. I hope it was clear. The second development step should be that of the automatic purchase of the tokens returned by the filter and the possible sale, therefore the order should be entered with SL and TP. Each token can only be purchased once at one time. As you can understand, it is a long-term project and what I a...

We have built a customized website in core php and need another experienced developer to join the team to fix some bugs, We are looking for a very experienced php developer for our project, you must have at least 12-15 years of experience with a good reference . Must have experience in multi-user programming, must know how to do quality coding, fix sql injections Conditions: You must be a independent freelancer. and share with some of your customized applications that u have worked on.

I want to Rank Keywords at the 1st Position of the Google Search and payment will be done after ranking the keywords at 1st position of the google search only otherwise no payment will be made. Weekly and monthly backlinks creation and work done report is mandatory. Keyword : Target URL 1) bharatiya nyaya sanhita 2023 pdf: 2) bharatiya nyaya sanhita pdf: 3) section 69 bns: 4) bns section 69: 5) bns 352:

Fixed cost & developers from Uttar Pradesh only . I'm looking for a skilled freelancer who can help me develop a real-time temperature display system using NodeMCU ESP8266. Key Project Requirements: - Integration with 3 or more Bluetooth BLE sensors - Real-time temperature display on an LCD screen - Parsing advertisement data from nearby paired BLE sensors - Data sheet will be supplied for reference Ideal Skills/Experiences: - Proficient in programming with NodeMCU ESP8266 - Experienced in working with Bluetooth Low Energy (BLE) technology - Familiarity with parsing advertisement data - Knowledge of connecting and operating LCD displays This is a fixed cost project with a budget under $100. Please provide your quote for the project, ...

We have a selection of AI images that need to have a transparent background to enable use within our business. Standard removal tools in Photoshop remove too much of the actual image.

I already have a Twilio account set up to forward incoming calls to a mobile phone number (phone number 1). If that call cannot be answered after 10 seconds, then I would like to forward the call to another number (phone number 2).

Preparing financial statements for the year 2023 typically involves gathering data from various sources such as income statements, balance sheets, and cash flow statements. This data is then organized, analyzed, and compiled into the appropriate financial statement formats following accounting principles and standards. Additionally, any necessary adjustments or reconciliations are made to ensure accuracy and compliance with regulatory requirements.

I'm in need of a professional with expertise in HubSpot and its integration with our app Primary Objectives: - Increase customer engagement - Streamline our onboarding process - Improve our lead generation process Key Tasks: - Develop and implement a strategy for CRM integration between HubSpot and Sheets - Optimise the use of HubSpot features with Sheets integration The ideal person for this task should have proven experience with HubSpot, excellent understanding of CRM systems, and an ability to streamline processes for optimal efficiency. Capability to troubleshoot and resolve any issues that may arise during the transition period is crucial.

Hi Joshua, the client liked your previous work and we would like to hire you for another article. Would you be interested?

I urgently need a CodeIgniter expert with 2-3 years of experience to help me complete a project in 7 days. The project involves developing a new feature for my existing website. More specifically, I require the integration of search and filter options. These additions are crucial for the website's user interface and overall functionality. Key responsibilities include: - Understanding current website structure and design - Implementing search and filter options - Ensuring seamless performance and user experience Ideal candidate should possess: - 2-3 years of hands-on experience with CodeIgniter - Strong proficiency in front-end technologies like HTML, CSS, and JavaScript - Proven track record of developing and integrating new website features - Ability to work efficie...

I need help with data entry and formatting for a Google Sheet. The data is to be sourced from ONLY 1 Website. Key Tasks: - Copy-pasting text information and images or screenshots from Website 1 into a Google Sheet. - Formatting the data in the Google Sheet with columns and tables. Ideal Skills: - Proficiency in data entry, specifically with Google Sheets. - Strong attention to detail to ensure accuracy and completeness of the data. - Ability to organize data efficiently using columns and tables along with images etc for capturing the User flow in a tree form . Example the website has Question 1 and N number of responses. Based on the responses there are different questions...

...lines as follows: 1 circle 1.5 5.3,1.2 Begin 2 rectangle 6,2 5.3,2.5 Find node that represents the itemset 3 line 1,2 This file would mean to: 1: Draw a circle with radius 1.5 at point (5.3 across,1.2 down) with the word "Begin" in it. 2: Draw a rectangle with width 6 and height 2 at point (5.3 across,1.5 down) with the words "Find node that represents the itemset" in it. 3: Draw a line pointing from 1 to 2 I don't care how the definition works other than how general it is. The above is just to show what I mean. 1. You could provide the flowcharts that some app allows you to make manually. 2. You could provide what the attached 30 files (or a subset) show. 3. You could propose the capabilities as a specific spec for what the input text file contains. ...

I am looking for help building my landing page design wordpress site. I have purchased the domain and theme plug-in (envato travel tour) but i need help installing it, and editing the home page. Then I need help editing a template for a tour page, where I can copy it and create similar other tour pages, along with a contact page and...help building my landing page design wordpress site. I have purchased the domain and theme plug-in (envato travel tour) but i need help installing it, and editing the home page. Then I need help editing a template for a tour page, where I can copy it and create similar other tour pages, along with a contact page and FAQ page after. I also need help installing a plug in where the site is GEO-blocked from Mexico and the US, along with yoast seo and ...

I am seeking a skilled and experienced designer who can help me with a simple yet crucial task: changing the color of my product images. I have 2 products with around total 9 images, all of which are currently yellow, and I need them to be transformed into Red, Blue, and many more variants. This project is straightforward for someone who is proficient in using the Hue/Saturation filter in Adobe Photoshop. Scope of Work: - Your task is to change the color of these products to given color, ensuring that the new colors look natural and appealing. - I will provide one reference image with the exact colors I desire. You will use this reference to match the colors accurately in the other images. The main objective is to update the color scheme of our products. The new color scheme will ...

I'm look...extension should have include: - CRM Integration: The extension should seamlessly integrate with vTiger CRM for maximum efficiency - Contact Synchronization: It should be able to synchronize contacts between Outlook and vTiger CRM - Lead Generation: The extension should support lead generation functionalities with vTiger CRM - Email Tracking: Ability to track emails in Outlook that are related to data in vTiger CRM The ideal candidate for this project should have: - Experience in developing Outlook extensions - Proficiency with vTiger CRM - Strong background in CRM integrations - Excellent understanding of lead generation processes - Familiarity with email tracking mechanisms Please provide examples of similar projects you've worked on to help me evaluate you...

Convert 2 page brochure from PDF to AI files. Recreate source files from PDF for easy editing. Create a layer from each section. Copy the text from each section. i.e. each image is a layer, each text block is a layer, each text heading is a layer For reference-page1 should contain approximately 19 layers.

...of a web crawler that can extract specific data from a large online ads website. The extracted data should then be neatly exported to a Google Sheet. Key requirements: - The crawler should not be intrusive to the host website. - I want the crawler to crawl current and expired ads based on links present in the site map, as historic data is also of importance to me - You should be able to provide a way for me to run this crawler myself at any time - ideally on a monthly basis. I haven't yet decided on the precise fields to be extracted. I'm looking for someone with the skills to recommend suitable fields that could be beneficial for my project. It's important that the extracted data is organized and easily readable once ...

As an innovative company, we're in need of a dotnet expert who will focus on improving ou...a dotnet expert who will focus on improving our MSSQL database. Your tasks will include: - Safely migrating data from one source to another - Optimizing our MSSQL database for enhanced performance For the successful execution of these tasks, we expect you to have extensive experience with dotnet and MSSQL databases. In particular, we value the following skills: - Proficiency in using dotnet for database management - Hands-on experience in data migration strategies - Expertise in database optimization techniques We're looking forward to working with a problem solver who can effectively boost the performance of our MSSQL database through optimization and ...

...set up Google Ads specifically with the goal of generating leads from local customers. Key Project Details: - **Goal**: My primary objective is to generate quality leads for my business. - **Preferred Google Ads Type**: I'm interested in utilizing Search ads for this particular project. - **Target Audience**: The ads should be optimized to reach and engage local customers effectively. Your Role: - Setting up Google Ads: This includes keyword research, ad copywriting, and creating a compelling ad structure. - Location Targeting: It's crucial that the ads are specifically targeted at our local audience. - Lead Generation Focused: The ads should be designed to not only attract clicks but also convert these clicks into solid leads for my business. Id...

I'm seeking a professional auditor to conduct a comprehensive annual financial audit for my company in Vancouver, Canada. The primary goal of this audit is to validate financial statements, with a keen focus on the balance sheet, income statement, equity, and cash flow statement. Ideal Skills/Experience: - Proven experience in financial auditing, particularly annual audits - Excellent knowledge of financial regulatory compliance - Skilled at identifying financial irregularities - Proficient in reviewing and validating balance sheet, income statement, and cash flow statement. This engagement will require a meticulous individual who can handle the complexities of a comprehensive financial audit while upholding the highest degrees of professionalism and integrity.

...scraping expert who can help me compile a database of local businesses. The data I need should include company name, physical address, email, phone numbers and their social media profiles. Key requirements: - Data extraction from multiple websites: I'm looking to collect this information from a variety of sources, not just a single site. This will require the ability to navigate various structures and formats, so experience with diverse web scraping is a must. - Targeting local businesses: The focus of this project is to gather data specifically from local businesses. This implies you should have the know-how to identify and extract data from these specific types of entities. - Data fields: The most crucial data...

...specific page. The collected data should be simultaneously sent to GoHighLevel (GHL) CRM for automated text and phone call follow-ups, as well as to an Excel sheet for manual review and further action. Key requirements: - Pixel Integration: Develop and implement a pixel solution that captures lead data. - Real-Time Collection: Ensure the system collects data instantly when a lead lands on the specified page. - GoHighLevel (GHL) Integration: Connect the system to GHL for automated text and phone call follow-ups. - Excel Integration: Enable the system to send collected lead data to an Excel sheet via email. Ideal skills and experience: - Proficiency in WordPress and pixel integration. - Experience with CRM systems, particularly GoHighLevel (GHL)...

I'm seeking a seasoned SEO specialist to perform a comprehensive audit of my website with a focus on improving rankings on Google. Key Requirements: - Audit: Review the current state of my website from an SEO standpoint. - Recommendations: Provide actionable suggestions to enhance my Google search engine rankings. - Keyword Optimization: Work with a list of specific keywords I aim to rank for. Ideal Skills and Experience: - Proven track record in SEO, particularly with enhancing Google search rankings. - Strong analytical skills to assess the current website's SEO performance. - Excellent understanding of keyword research and optimization techniques. - Ability to provide clear and strategic recommendations for improvements. - Good communication skil...

...photo editor that can remove an extensive glass reflection from one of my photos. Key Responsibilities: • Utilize photo editing software to remove a dominant glass reflection from a single image. • Ensure the integrity of the important details is maintained after the reflection has been removed. Skills & Experience: • Expertise in photo editing tools such as Photoshop or Lightroom. • Extensive experience in reflection removal, specifically glass reflections. • Strong attention to detail, particularly regarding maintaining the image's original components. Please note that this reflection is substantial and covers significant parts of the image. I’m depending on your expertise to retain as many original aspects as possible. Bids ...

* Please deliver a locally working (DDEV!) composer based installation of TYPO3 v12. * Use Bootstrap for Frontend! * You will receive a PSD file and 2 Font files * Page Template Header (see attached JPGs): ** main navi (should come from TYPO3 page tree), 2 levels, burger menu for mobile ** logo, Insta-Icon and red "bubble" can be hard coded in template * Page Template Footer ** hard coded button: "Jetzt Kontakt aufnehmen" with link to "contact" page in page tree ** hard coded link: "Impressum" with link to "impressum" page in page tree (hidden in menu) * Content Elements: ** Please style the "Text with media" appropriatly (see ""): Image, Headline etc ** Element "Card Group" to display a variable amou...