Google sheets pull data from another workbook jobs

I'm in need of a detailed Excel sheet for my company, specifically for the Operations department. This sheet should include various registers and time sheets, all interlinked with formulas for seamless data flow. Key Components: - Invoice Register - Expense Register - Salary Register - Employee Time Sheet - Invoice Incoming - Invoice Outgoing - Outgoing Purchase Order - Purchase Order Incoming (Sales Order) - Apex and Opex Register - Asset List - Billing Forecast - Expense Forecast - Hire Employee List and Salary Register - Payroll Master and ESOB Calculator and Register The project also requires the creation of a single dashboard. The main purpose of this dashboard is to track the financial performance of the company. It should prominently display: - Total revenue ...

I'm looking for a skilled Ex...worksheet modification that will control data entry into cell H8 based on the status of cell D8, and enforce data type constraints. Requirements: - If cell D8 is BLANK: Allow user to enter data into cell H8. - If cell D8 IS NOT BLANK: Populate cell H8 with data from cell H12 and lock the cell from user changes. - Implement numeric-only validation for cell H8. Additional Information: - Cells D8, H8, H12 are unlocked and the sheet is password protected. - The functionality should persist for future users, even after data row 8 has been saved and cleared by an existing VBA script. Ideal skills include: - Proficiency in Excel and VBA - Experience with implementing data validation and conditional cell...

Please Sign Up or Login to see details.

I have two individual drawings that need to be manipulated in Photoshop and combined into a seamless pattern. The primary use of this pattern will be for digital art. Ideal skills and experience include: - Proficiency in Adobe Photoshop - Experience with pattern design - Ability to work with hand-drawn elements - Keen eye for detail

Following are the requirements of task to be fulfilled. 1- Task is to visit the ''Senes UNETEC'' physically and take 10 to 15 geotagged photos of with name board captured and from outside/inside the building. Moreover, you have to made a video from inside if possible, but from outside, you have to make a video while capturing the signboard of the location, and both of its surroundings. Just take a 360 degree view of it in a video. 2- Get the verification form filled, signed and stamped by the HR of Senes UNETEC, Germany, and also stamp the certificate. 3- Get the details of verifier, Name, Designation, Department and Contact. 4- In case of refusal to fill form, take the written refusal with stamp or sign as a proof. 5- If Senes UNETEC, Germany, doe...

I'm looking to hire a freelancer who can assist in populating a spreadsheet with data by conducting web research. Key tasks: - Conducting basic web searches to gather data - Populating a spreadsheet with the collected data The ideal candidate should be capable of conducting web searches efficiently and accurately. Attention to detail is crucial, as the quality of the data collected will directly impact the project's success.

I'm looking for a talented Photoshop expert to replace a head on one of my photos and perform some general touch-ups to enhance the image for print. Key Tasks: - Replace a head on one photo with another - Color correction to enhance the visual appeal - Skin smoothing to ensure a flawless appearance - Object removal to maintain a clean image The final image should have a dramatic, high-contrast style. This is intended for print, so the final output will need to be high quality and suitable for physical distribution. Ideal Skills: - Proficiency in Adobe Photoshop - Experience with photo editing and retouching - Ability to work with a specific style or mood - Excellent attention to detail

I'm looking for a...who can help me optimize my Google search campaign. The primary goal of this campaign is to generate leads, specifically targeting B2C leads. Key Skills and Experience Required: - Expertise in Google Tag Manager (GTM) and Google Analytics - Proficiency with WordPress and its various plugins - Prior experience in optimizing Google search campaigns - A track record of successfully generating B2C leads The ideal candidate will have a deep understanding of tracking and analytics, using GTM, Google Analytics, and various WordPress plugins to monitor, assess and improve campaign performance. Your primary role will be to help me enhance the effectiveness of my campaign in generating B2C leads. If you have a proven history of success i...

I'm seeking an expert who can manage Google Ads and LinkedIn Ads campaigns for my tech industry clients. This is for a marketing agency I'm running. Key Responsibilities: - Oversee and optimize Google Ads and LinkedIn Ads campaigns, aiming primarily to boost sales. - Utilize a variety of content types, including articles, videos, and images, to create engaging and effective ad content. Ideal Candidate: - Fluent in Spanish, with excellent communication skills. - Demonstrable results from previous campaigns, particularly in the tech industry. - Proficient in using diverse content types to drive campaign success.

I need assistance entering SKU numbers from Catalog 3 and Catalog 4 into various catalogs. Use Catalog 1 as a reference, but do not use SKU's from Catalog 1. Requirements: - Proficient in data entry - Able to work with PDF format - Attention to detail - Able to accurately transcribe information from images and text - Able to navigate randomly listed information Ideal candidates should be meticulous, able to work under minimal supervision and possess a keen eye for detail. Familiarity with SKU systems and catalogs is a plus.

I need a professional to help improve my reputation across social media and Google. - Focus: Primarily on enhancing my social media presence and removing negative content from Google. - Skills: Expertise in social media management and SEO, with a proven track record in online reputation management. - Goal: To foster a positive online presence and mitigate negative impacts.

...elegant and classy tone. Design Requirements: - Incorporate specific images: our logos - Use your creativity, impress me - An idea is to incorporate an illustration of bread or a symbol of circularity. But feel free think creative. - Understand and apply color theory to create a visually appealing color palette, using primary colors that you suggest. - Look at PDF to get some more inspiration and data on what to do. - Preferably make a illustrator design. - Some regulatory information is needed. so make room for that. Barcode etc. You can see that oin existing designs. But space can be smaller than on existing labels. Ideal Skills and Experience: - Graphic design experience, with a focus on minimalistic elegant style design. - Proven ability to integrate specific images and...

...pricing is another important consideration when creating your freelance account. Research industry standards to determine what rate is reasonable for your level of experience and expertise. Some platforms allow freelancers to set hourly rates, while others work on fixed pricing per project. It’s important to find a balance between being competitive and ensuring you’re compensated fairly for your work. Managing your freelance account involves maintaining clear communication with clients, meeting deadlines, and handling payments. Most platforms offer payment protection and dispute resolution services, providing a layer of security for both freelancers and clients. It’s also essential to build a positive reputation by consistently delivering high-quality work and ...

I'm in need of a comprehensive, user-friendly platform that connects student Chartered Accountants (CAs) with companies in need of auditing, ITR filing, and CS work. Key Features: - Dual User Interface: One for student CAs and another for companies seeking CA services. - Job Posting & Work Allotment: Companies can post their CA/CS work requirements and we will mutually allot the work. - Payment Processing: The platform must handle all payment transactions, including invoicing and payment processing. Ideal Skills: - Full Stack Development: Proficient in both frontend and backend development. - E-Commerce Platform Experience: Prior experience in developing a platform with integrated payment processing. - UI/UX Design Skills: Ability to create intuitive and engaging user in...

...who is capable of launching the products from inception to success! We are excited to present a unique opportunity for a dynamic individual to join our team as a new Product Manager. We are going to launch on the Tech platform 40 programs linked with international schools. In this role, you will play a pivotal part in both new product management and marketing strategies, contributing to the growth and success of our innovative education platform. YOUR MISSIONS Marketing Management Responsibilities: Ø Brainstorming: Explore creative ideas with creatives and marketing team to market the launch of the new programs. Ø Market Research: conduct market studies to identify industry trends, student needs, and competitor positioning. Analyze feedback from candidat...

...devices to ensure a smooth experience on all screen sizes. Admin Dashboard: Admins will have access to a dashboard to manage orders, users, restaurants, and content on the platform. Technical Requirements: CMS (Content Management System): Preferably WordPress, but open to other recommendations. Frontend: HTML, CSS, JavaScript (React or similar frameworks preferred). Backend: PHP, Node.js, or another suitable backend technology. Database: MySQL, MongoDB, or a suitable alternative. We are seeking a developer who can work efficiently, communicate well, and bring creative solutions to the table. The project should be completed in a reasonable timeline, with regular check-ins and updates. Deliverables: Fully functional website with all the required features. Clean, commented, and m...

I need 40 perfect 5sec videos out of photo-footage. There are only few (max 8 must have photos) which are had be done at the end and the other Videos can be choosen by you - so you can take this videos, which achieve the best result in AI. Requirements: AI-output HD 2. Length: at least 5 sec each video 3. No strong artefacts in the video (like strong sharpening or missform) 4. No changing of contrast and color 5. The persons have to be look like on the photos 6. No unwanted actions

I'm in need of a seasoned SEO professional to help my website rank on the first page of Google for local keywords. Key Requirements: - Expertise in local SEO strategies - Proficiency in keyword research and implementation - Proven track record of improving website rankings - Up-to-date with the latest SEO trends and algorithm changes - Ability to provide regular progress reports Please include examples of previous successful projects in your bid.

I'm in need of a simple, yet effective design to the main page of my website. The primary task will involve following a reference design I will provide, with a few additional elements i will provide. (Symbol,Price Tag,Order button) Ideal Skills: - Web Design - E-commerce Design Experience - Attention to Detail Specific Tasks: - Modifying a reference design - Adding a symbol from another website - Including a price info bubble - Adding an order button The work is straightforward and does not require any creative input, just the implementation of specified modifications. I need this completed today. Please note: As I have received a high volume of automated bids, I request a demo before awarding the project. To confirm you have read the details, please include the wor...

I'm looking to pull data from a cricket scoring app called play cricket scorer on both iOS and Android to display on a Raspberry Pi. The job primarily involves: - Extracting score updates from the app as they happen - Delivering this data in real-time to the Raspberry Pi The data should be displayed on the Raspberry Pi in a text-only format. Ideal skills for this project include: - Proficiency in data extraction and manipulation - Experience with Raspberry Pi and its programming - Understanding of cricket scoring and terminology would be beneficial I need a reliable freelancer who can ensure the data is updated accurately and promptly.

I'm looking for a Google Sheets expert who can design scripts and custom functions to automate data manipulation and analysis, generate automated reports and integrate with internal data sources. Key Responsibilities: - Create Google Sheets scripts and custom functions to handle large datasets and perform complex calculations. - Automate the process of data manipulation and analysis. - Generate automated reports. - Integrate data from internal spreadsheet sources. Ideal Skills: - Proficient in Google Sheets, including script writing and custom function creation. - Strong understanding of data manipulation and analysis. - Experience with automating reporting processes. - Ability to handle large datas...

Hi, I will help to grow your Google my business I will do 30 Listings for your Google My Business. Let's approve this Quote Thanks

I'm looking for a detail-oriented in...individual who can read and write Chinese fluently. Your primary task will be to gather specific information from our invoices and purchase orders (POs) and enter it into a Google Sheet in a specified format. The job should take approximately 10 hours. Key Responsibilities: - Extracting information from invoices and POs, including: - Product details - Pricing and quantities - Supplier information - Customer information - Inputting this data into a Google Sheet in a combined view with filters Ideal Skills and Experience: - Proficiency in reading and writing Chinese - Previous experience in data entry - Familiarity with Google Sheets - Attention to detail to ensure accurate data...

I'm seeking a professional to create an Engineering drawing package for the Belt Roller Support assembly. The package needs to convert dimensions from Metric to English units, select appropriate tolerances for mating parts, and modify the design to accommodate commercially available bushings. Key Tasks: - Choose suitable materials for the components. - Create 3D models using SolidWorks. - Deliver a comprehensive report with: a) A Drawing Package including A4 sheets with individual part drawings, sub-assembly drawings, and assembly drawings. b) Tolerances for parts ensuring a proper fit. c) Justifications for the selected tolerances. Ideal Skills: - Proficient in SolidWorks. - Extensive experience in engineering drawing and design modification. - Knowledgeable in...

I'm seeking a seasoned Google Ads professional for a long-term project aimed at generating sales and leads for my services. This role requires daily management of bidding to ensure profitability. Key Responsibilities: - Daily monitoring and adjusting of bids. - Implementing strategies to maximize lead generation and sales. Compensation Structure: - Minimal fixed payment. - Additional percentage from profit generated through Google Ads. Please share your previous experience with Google Ads, specifically in promoting services on the Search Network.

...oceanic yet natural feel. ✅ Subtle creative elements (not overpowering): - A pollock fish representation (as it’s the collagen source). - A subtle Alaskan symbol (mountains, waves, glaciers, or something uniquely Alaskan). Logo: please use the AC-I letter for now. We are currently having another contest for our logo. Please take a look for more ideas: https://www.freelancer.com/contest/Minimalist-Modern-Logo-Design-for-ACI-2515321/entries Front Label Content: Product Name: Alaskan Collagen Description: Sourced from wild-caught fish skins, supports health & beauty Category: Dietary Supplement Flavor: Unflavored Net Weight: 240G (8.4oz) Badges: ✅ FDA Facility ✅ cGMP Certified ✅ Non-GMO ✅ Lab Tested Back Label Content (Distributed By): Alaskan Collagen 12700 Ho...

I'm looking for a freelancer to assist with data entry into a spreadsheet. The data is primarily numerical and will be sourced from scanned documents. Ideal skills and experience include: - Proficiency in Excel and other spreadsheet software - Keen attention to detail to ensure accurate data entry - Experience working with numerical data - Ability to handle and process scanned documents - Good time management skills to meet project deadlines.

page written in wordpress using SiteOrigin Page Builder after transferring to another server stopped working. Original appearance of the page in the attachment. List of plugins in the attachment.

...administrator - send messages to the client - request additional data from the client (additional fields appear in the client's profile in the personal cabinet) - edit the request - add comments, statuses, additional information to the request 3. the system should be able to send messages to the client and/or administrator when the status of the request changes and/or at the administrator's choice via email/ SMS/WA/ internal messages. It will also be necessary to build a site with which CRM will work, using or analogue. Another important thing is that the site must be multi-lingual. All the tools used should be from international services (not your own development, but customisation of existing services, starting from CMS site, CRM-sys...

My Google Merchant Center account has been rejected for misrepresentation issues. I have 4 skincare products that I ship domestically (New Zealand) and internationally (Australia). Key Requirements: - Experience with Google Merchant Center troubleshooting - Knowledge in eCommerce, particularly in skincare products - Proven track record in resolving misrepresentation issues I'm looking for a professional who can promptly and efficiently address this issue, ensuring compliance with Google's policies and returning my account to good standing. Payment will only be made if issue is resolved and misrepresentation issue fixed.

...some specific questions, which are: Our Needs: 1. WhatsApp Contact Management: • We receive a high volume of messages, both from existing customers and from people interested in our products who have not yet made a purchase. • When someone contacts us via WhatsApp, a lead is automatically created in Kommo with their phone number, but no additional data is associated with it. 2. Synchronization with WooCommerce: • We sell through WooCommerce, where each order includes detailed information such as: Order number Product Address Phone number Other relevant details • This data is transferred to Google Sheets and then to Kommo, generating a new lead for each order. 3. Data Consolidation: • We want all information re...

I'm looking for an experienced Google Ads professional to optimise my account for increased local traffic. It's crucial that this expert is adept at improving: - Keyword selection: Identifying the most relevant and effective keywords for my local audience. - Ad copy: Crafting compelling and engaging ad content that drives clicks. - Landing pages: Enhancing my landing pages for better user experience and conversion potential. The main aim of this project is to increase website traffic through these optimisations. If you have a proven track record in Google Ads management, particularly for local campaigns, I'd love to hear from you.

I need a Node.js expert to create a script that will: - Extract articles from a Google Sheet. The articles are in Rich text format. - Convert them to HTML using an AI API (any of your choice: OpenAI, DeepAI, Hugging Face). - Structure the HTML with headings and subheadings. - Save the final output in a JSON file. Ideal candidates for this project should have: - Proficient knowledge in Node.js. - Experience in working with Google Sheets API. - Familiarity with various AI APIs for text processing. - Ability to structure HTML code correctly.

I need a skilled Python developer who can scrape text data from a website for me. Key Requirements: - Experience in web scraping using Python - Familiarity with handling table data - Ability to output scraped data into a CSV file If you possess these skills and have prior experience with similar projects, I look forward to receiving your bid. There are three websites which I needs this for: (1) all race results for all seasons (seasons can be changed in the top right hand corner) for all categories on this website - noting that all seasons are needed (and future seasons) (2) all results from this link: (3) another link that should return results similar to (1) but will be the method going forward so needs to be

A couple of years ago you implemented captcha on my website contact page. I now got an email from google saying I need to migrate this to some new system. Please send me your offer to do this and I will make the payment to you.

Project: Correlating Inter-Account Transfers and Transaction Analysis Objective: To analyze and correlate inter-account transfers across multiple bank accounts, match transactions that flow from one account to another, and reconcile these with descriptions of the source, origin, and purpose of funds provided in previous submissions. Scope of Work: Data Consolidation: Compile transaction data from all provided bank accounts (FNB, Bidvest, etc.) into a unified format for analysis. Inter-Account Matching: Identify and correlate transfers between accounts (e.g., Account A to Account B) by matching amounts, dates, and any available references. Flag any unmatched or ambiguous transactions for further review. Transaction Categorization: Use the previously pro...

Need some one to quickly edit and format our googel docs. add some relevent images from internet change colours heading add images in googel docs to make it look good. Google docs expert can do in few hrs Need it urgent exper google docs exper needed will share google docs once you confirm

I'm seeking a skilled professional to assist me in migrating my ClickHouse cluster from using Zookeeper for data replication to ClickHouse Keeper. Key Details: - My ClickHouse cluster currently has data size ranging between 1TB-10TB. - There are only a few custom settings in my current Zookeeper setup. - The ClickHouse version used was not specified but needs to be considered in the migration plan. The ideal candidate will have robust experience with ClickHouse, Zookeeper, and ClickHouse Keeper. They should be capable of handling a mid-sized data cluster, with the ability to adapt to a few custom configurations. A thorough understanding of data migration processes and potential challenges, alongside excellent problem-solving skills, will be essent...

I need assistance with my workflow that channels data from Google Sheets into PrestaShop. Data from Google sheet module (in ) to Prestashop module (in ) In outing of the Google sheet module in we have this data : Bundle 1 (Collection) Id order (A) : 11313741201740 SKU (shopify) (B) : PRO-TOP-1620,PRO-TOP-1419 Product ID (C) : 21,21 Product Attribute ID (D) : 40,42 Quantity (E) : 2 So I have 2 products in this order : Produit 1 : Id_Product : 21, Id Attribut : 40 Produit 2 : Id_Product : 21, Id Attribut : 42 My question : In order to add those products in the Prestashop Module (on make), how to split the data in order to get this result : Bundle 1 (Collection) Quantity : 1 Product ID : 21 Product Attribute ID :40 ...

...informative and factual videos aimed at energy enthusiasts, focusing on promoting the device itself. - Payment Structure: I will pay $5.00 USD upon completion of each video, which must include the provided link and the subject matter of the link. - Video Specifications: The videos must come from different creators, be clearly distinguishable and not repetitive. - Approval Process: Payment will be issued once I approve the video. - Additional Milestones: Once we reach a total of $20.00, another milestone of $20.00 will be created at the same rate. Ideal Skills and Experience: - Proficiency in YouTube content creation and promotion. - Ability to produce informative and factual content. - Experience targeting energy enthusiasts. - Access to multiple distinct content crea...

...printing on T-shirts. Design 1: Man Holding a Rubik’s Cube Requirements: Focus on the man’s hands and Rubik’s Cube from a first-person perspective (from his lens). Show the hands gripping the cube as if he is about to solve it. Use a mix of monochrome for the hands and vibrant colors for the cube (classic Rubik’s Cube color scheme). Avoid showing the man’s face or other body parts. Suggestions: Use minimalistic art or sketch-style lines for the hands. Add subtle shading or lighting to create depth. Experiment with 3D perspective to make the cube stand out. Design 2: Rectangular Dice (One on Ground, One Mid-Air) Requirements: Depict one rectangular dice on the ground and another dice mid-air, as if being thrown. Create a sense of mot...

I need a skilled photo editor who can not only perform color correction but also assist in sourcing an appropriate background for another image. Key tasks: - Color correction: Enhance the visual appeal of the photos through color balancing, brightness and contrast adjustments. - Background sourcing: Help me find a suitable background image to replace the current one. Ideal skills and experience: - Proficiency in photo editing software like Adobe Photoshop or Lightroom. - Creative thinking to find suitable backgrounds. - Experience in color correction and photo retouching. - Good communication skills to understand and execute my vision.

...to assist with setting up conversion tracking on my Google Ads campaign for a B2B business. The primary focus of this project is not to manage the Google Ads, but to ensure proper tracking of form submissions & other conversions via Google Tag Manager. Key Requirements: - Install and configure Google Tag Manager for tracking form submissions & other conversions on my WordPress site. - Link google tag manager to google ads as required. - Provide assurance that all necessary tracking is functioning correctly. - Troubleshoot any potential issues with tracking or configuration. Ideal Skills and Experience: - Proven experience with Google Ads and Google Tag Manager. - Strong knowledge of WordPress and its potential compatibil...

I need assistance entering SKU numbers from Catalog 3 and Catalog 4 into various catalogs. Use Catalog 1 as a reference, but do not use SKU's from Catalog 1. Requirements: - Proficient in data entry - Able to work with PDF format - Attention to detail - Able to accurately transcribe information from images and text - Able to navigate randomly listed information Ideal candidates should be meticulous, able to work under minimal supervision and possess a keen eye for detail. Familiarity with SKU systems and catalogs is a plus.

...the testimonials from previous freelancers whom we have hired. We are an established employer. Quick and correct work will earn you positive feedback and timely payment. ************************************************************************************************** Project description : This is an intensive, manual work project that will take at least 4 hours of dedicated Excel skills Please proceed with reading further, only if you are willing to work hard and devote time to complete the task correctly. It CANNOT be automated or run via a script. It CANNOT be outsourced via code. It cannot be "done using AI" . Please do not waste your valuable time trying to do either. The task: There are Some handwritten notes with approximately 1000 records. These are stu...

I am a data analyst in need of assistance with creating a sales report in MS Excel. Ideal skills for this project: - Expertise in MS Excel - Strong data analysis skills - Experience in sales report creation Looking forward to your bids.

I'm looking to increase the traffic to my e-commerce site using Google Ads. The preferred campaign type is Search Ads. Ideal skills and experience for the job: - Proven experience with Google Ads, specifically Search Ads - Expertise in driving traffic to e-commerce sites - Ability to strategize and implement effective ad campaigns - Knowledge of SEO and keyword optimization - Excellent analytical skills to track and improve ad performance

I'm looking for an expert in Google Sheets to help me create a fillable personal budget spreadsheet. This spreadsheet will need to track my income, expenses, and savings goals. Ideal Skills: - Proficient in Google Sheets - Experience in creating budget spreadsheets - Understanding of personal finance The final product should be user-friendly and interactive, allowing me to easily fill in my income and expenses, and track my savings goals.

I'm looking for a skilled professional who can help me acquire data from the Stake Crash betting game. The data of interest is specifically betting patterns. You may choose any of the following methods: Python coding, using a bot, or screen reading software. Key Requirements: - Collect betting patterns from the game - Implement data acquisition methods: Python coding, using a bot, or screen reading software - Set up mobile notifications for alerts based on specific requirements Ideal Skills and Experience: - Proficient in Python programming - Experience with developing and using bots - Familiarity with screen reading software - Previous experience with data acquisition from online betting games would be a plus - Skills in setting up ...