Hello, I need someone to do a few tasks in google sheets as i have data and want it to work a certain way with google scripts to make it work functionality wise to how i want it to work. Please only bid if you know how to work google sheets and make different types of functionality work with google scripts. Thank you
Need a basic Google Sheet Script created to that pulls emails from the search results based on domain. 1. The script will read domains from Google Sheets. 2. Then it will perform a search operation in Google from the search query, and scrape any emails it finds. If it does not find any, it will present a 0. 3. It must remove any duplicate emails
...document with 20 entries. I send it to my coworker and he sends me a second document with notes on specific entries. Each entry has a case number assigned to it. On the first excel sheet (the original sheet) I have 20 entries. On the second document I only have 8 entries with specific case numbers. I need to merge the notes with my original document. See
Hi, I have an expense report table that employees put their expenses. Employees have full read/write permission only to Column A,B,C,D,E,F and managers have full permission to the entire table. I need a script that once a manager puts "approved" status on column H, the corresponding rows on column A,B,C,D,E,F should be locked for editing. In order to edit the approved cells, manager ne...
A simple search tool which searches all values in 1 workbook in other work books and display than in which excel file, workbook and cell you can find that value. Should also be possible to give in an error margin i.e. + or - 10, if you have a value of 1000 in a work book than it searches in the other worksbooks and files for all matches between 990
I have handwritten pages of receipts that are entered under specific column headers. I want this typed into Google Sheets,transferring the data exactly as is into Google Sheets. I will share the Google sheet page that is set up with you by email so will need that to be able to work together.
Hello, I am building a new marketing reporting dashboard for measuring content and website performance. I'm building the spreadsheet with all the data sources right now, but i'm terrible at creating charts. I was hoping someone could step in and help build the charts in the spreadsheet so i could continue to update them with new data over time.
Hi, I have a expense report table that employees put their expenses. Employees have a full write permission to Column A,B,C,D,E,F and managers have full permission to the table. I need a script that once a manager put "approved" status on column H, the corresponding rows on column A,B,C,D,E,F should be locked for editing. In order to edit the approved cells, manager needs to change t...
I am creating a catalogue using Indesign- I'm taking product data from excel and importing it into Indesign. I have already started it and have a preferred layout. I just need someone to save me time. I have excel files and in each excel file there are 4 to 8 tabs. Each tab needs to be a seperate Indesign sheet- . the title of the Indesign file should
Project 1A: Add missing JS formula for a... Estimated hours: 3hrs. Project 1B: Data restructuring and API integration into 4 sheets. Estimated hours: 8hrs. Project 2: Data restructuring and API integration into 7 sheets. Estimated hours: 30hrs. Project 3: Data restructuring and API integration into 20 sheets. Estimated hours: 80hrs. Project 4: tbd.
Please re-do the VLOOKUP function in Column K using the data in the sheet titled "Current Members" If the email is present in column A then we want to mark that in a separate column or remove it from the sheet. Link to file: [login to view URL]
Looking for an excel/google sheets specialist/expert to: 1. Identity misspelt words within a set of 3-12 keyword phrase. 2. Extract these keywords into a list We are on a deadline. If you have more than 10 reviews, you'll be considered. Please do not bid if you do not have reviews. Please reply back with: - how much it would cost - time
Project 1: Database development, Data structuring, and API integration into 7 sheets. Estimated hours: 30hrs. [login to view URL] Project 2: Database development, Data structuring and API integration into 20 sheets. Estimated hours: 80hrs. [login to view URL] Project 3:
I have a CRM I want made in Google sheets. it needs to function the way I want and have multiple functions like a CRM with Google scripts to make it all work. Need to hire today. will send more details via freelancer messenger.
Hello, we need a basic macro written which 1. copies worksheets 1 to 12 to a new workbook 2. exclude any other sheets 3. save as a *.xlsx (non macro workbook) 4. new workbook name must be the same name as the orginal but in *.xlsx format. have attached sample file
We have around 20 Products that need a spec sheet and a mini catalogue made. We have all the info neccessary and images on an excel sheet. We need someone to design a very eye catching and professional spec sheet of each product and then to put this together into a mini catalogue
I want to create spreadsheet on google sheets that has the capability of scraping the lowest price of a product on amazon and to keep scraping it 24/7
...Find the 17 columns in Sheet 1 on FL3 Excel Sheet on the PowerPoint ‘FL’. For example, ‘PNZ1 Sat’. 3. Now find the 17 columns from Sheet 1 in the PowerPoint labeled ‘FL’ 4. Only use the 17 columns listed in Sheet 1 from the Excel Sheet ‘FL3’ when looking at PowerPoint ‘FL.’ 5. Add up the numbers into Sheet 1 on Excel<...
Cells currently shows #ERROR! Remove the =+ in the error cells to just show the number. Example #ERROR! is =+123456789 Cell needs to read 123456789 2001 cells total. Cells position on spread sheet need to be same. Accuracy a must Please confirm understanding
I need a google form coded into my website, not a google form linked or embedded, the same workflow with output to a google sheet but run purely on my website hosted by Squarespace. I just want the same series of custom fields all on the same page that clients can complete and submit which then populates a google sheet with the data to be picked up by another app from there.
I need you to fill in a spreadsheet with data. we have 100 to 120 pages.
Looking for a quick and efficient data entry specialist to carry data from a Facebook profile to Google Sheet. Data includes date, content, interactions (like &comments), engagement ranking, post type, topic.
...our warehouse on a google sheet with item information and quantity on hand. Just under 400 different items total at the moment. I want to create 'incoming' and 'outgoing' sheets to fill out that will add or subtract to the master list and save as a separate file as a record. For example. IN001 on 5/23/2018 shows the 10 different items that were added
Google Forms are setup to store form submissions in one google sheet. However, its possible to store results in individual sheets using a script. This is something I have seen done but I am not able to build that script. Should be pretty simple for someone familiar with Google Drive and scripts.
A vbscript program to obtain USB history information a pc/laptop is needed , and it should tabulate the info in a table with such vital info as usb name serial no pid vid dates. file should produce a csv / excel file.
We have a inventory google sheet that we manually put in and subtract inventory from. We need an automated way to subtract inventory when it is taken out. A script or form would be ideal. Perhaps a separate tab where additions and subtractions are made and then they reflect the change on the inventory tab.
I need form fill...that I think explains how to do this using google sheets and Google tag manager, but it is a little high level for me. See below for the link on what I mean. If this is what I am looking for I would be happy to pay someone to implement this for me. [login to view URL]
We are trying to make a dynamic calculation on our "Bid Sheet". The Bid Sheet should be where the calculations final output will be. The "Products/Services" and "Rates" sheets are for reference for the calculations. We want the drop down menu “Item" and “Model" on the Bid Sheet to select the appropriate item on the “Products/Service...
I need you to fill in a spreadsheet with data. we have 100 to 120 pages.
Looking for assistance on google sheets project. Need someone who is good with using google sheets for data mining.
I need 2 work sheets designed. Project brief video: [login to view URL] I have attached 2 rough outlines, which need to be used to make awesome well designed workshers 1) ref: 'funnel [login to view URL]': 2) ref: 'account organization [login to view URL]' They should be designed like an infographics and reflect my branding / colors.
I need a excel/google sheets formula/script to compare the values of: B2|C2|D2|E2|F2|G2 Which ever is the cheapest (ignore cell if there is no data in it to compare): 1 put the value in (I2) and olour code to the supplier 2, Show the diference in value to the next cheapest supplier in (J2)
I have a Google sheet that I need to extract information from to populate a Google Document. There are around 10 pieces of data that need to be transferred. One of the fields has multiple cells to extract from the spreadsheet to populate a list in the Google Document.
Hello I have a coded already, google sheets, I press a button and it automatically pulls the zestimate from Zillow to google sheets on the address I have there, but it stops if the address doesnt exist and I have to start from the beginning. I need that fix so that if doesnt have an address it keeps going so I dont have to restart each time. I will
I need a automatically updated Excel spreadsheet. I want it to take the days ASX (Australian Stock Exchange) top Gainers Losers Data from [login to view URL] or reliable website for each day from now onwards. I need the current price at close of market and % change, then I need the next day % change and the day after that % change. Essentially I want
Hello I want to be able to put an address in google sheets, then I press a button and the link for google earth or google maps shows up, but the sattelite view please. not the regular view.