Need a Google sheets app script and macros which does the following. - Runs every 15 mins - Fetches the data from a website and populates the sheet with that data - And Applies conditional formatting on the newly added data.
I have a working file with excel for Drop down menus, I want to be able to use this file with google sheets, its seems google sheets does not work with dependant drop menus. So i need the attached file to be modified to work with google sheets.
About us We're an Australian small eCommerce business primarily selling on eBay. Initially in the phone accessories industry and having success there we're moving away from that product line due to the maturity and saturation of the market. We're now starting our new venture looking for the next big exciting product niches to sell that will be profitable
I have the scanned copies of 500-1000 survey sheets which contain 31 questions and its answers written with pen. Most of the questions are yes/no questions and the rest are like country, city, site id, date and time of survey, temperature, age, height, weight, blood pressure measurements(3 measurements with a total of 9 values), BP apparatus manufacturer
I have about 150 addresses in a google sheet. They are now in a single cell. I would like them changed so they follow the format: Name (Column A), Address 1 (Column B), Address 2 (Column C), City (Column D), State (Column E), Zip code (Column F). I will provide the link to google sheet for this work. Also, there are 10 addresses that I would like you
Hi, We need to create a code within Google Sheets that will pull data from SKUVAULT API: 1. Products Report: [login to view URL] 2. Kits Report: [login to view URL] And will save each report to a specific sheet. 3. I want this to code to be scheduled to run every day. For more info about
I have the scanned copies of 1000-1333 survey sheets which contain 31 questions and its answers written with pen. Most of the questions are yes/no questions and the rest are like country, city, site id, date and time of survey, temperature, age, height, weight, blood pressure measurements(3 measurements with a total of 9 values), BP apparatus manufacturer
I need you to develop some software for me. I would like this software to be developed for Windows using SQL.
1) Windows 10 pro, Excel 2016 2) User should be able to identify target folder for process to run on all excel sheets in the folder as a batch. 3) Source data is Excel sheet (no more than 4 columns, and max. 100 rows) 4) Output is csv (12 columns, and no more than 100 rows) 5) Some columns in source will be split into many columns in output
I have the scanned copies of survey sheets which contain 31 questions and its answers written with pen. Most of the questions are yes/no questions and the rest are like country, city, site id, date and time of survey, temperature, age, height, weight, blood pressure measurements(3 measurements with a total of 9 values), BP apparatus manufacturer name
I have a list of 1000 products on a website, I need the following to be extracted from URLs I provide: 1) Serving size [g] 2) Calories [kcal] 3) Carbohydrates [g] 4...Calories [kcal] 3) Carbohydrates [g] 4) Protein [g] 5) Fat [g] 6) Saturated Fat [g] 7) Fiber [g] 8) Sodium [mg] Please only apply if you can finish this for less than $25 and in 2 days
Looking for someone to enter approx. 220 0 k pdf pages and form fill...to enter approx. 220 0 k pdf pages and form fillings worksemailadresses from PDF to Excel. I attached an example of the pdf data. Please look at it before making a bid. Only the email address [login to view URL] 2 columns. If all goes well there will be lots of work like this in the near future
...to Google Sheets. There are 10 columns labeled "announcements" where twitter messages will land along with requested Date/Time to post to Twitter. We need a script to automate the process of: 1. Querying Google Sheets for new entries 2. When a new entry is found & we have marked a particular column with "1", then the announcements in th...
I need a house drafted in Revit 2018. I will need 6 sheets created with dimensions, basic annotations, and some schedules. This is a 2000 SF rancher with nothing too complicated to deal with. The main challenge is that we are working off of old paper plans that I have taken pictures of. As such I will need an extra set of revisions. That said,
I am looking to randomize the scheduling for my employees. I currently entire their requested time off via a google sheet. I am looking to create a script that will a...that will allow me to randomly assign them positions for the day based on who is present, and who recently had a day off. The script should be contained fully within google sheets.
...somebody to write a complex formula that will look up barcodes and return the results accordingly. I am VERY experience in Google Sheets formula's myself, do not apply for this job if you don't have a complex understanding of Google Sheets Formulas. Watch the video of what I want: [login to view URL]
I have a spreadsheet that has needs to be sorted into multiple sheets. I don't think it's extremely complicated, but more than I can do. There are only 3 columns. I need to pull info from the first column - but not based on the entire col A info - not day, date - just the name of the city.
...who is expert with Google Sheets, Excel or SharePoint for automated extraction of data from websites. I'll provide a list of URL's for data extraction and the freelancer will need to design and create a product for scheduled automated extraction and filing. In summary, I'm creating a database to capture open source data that will automa...
I have data of attendees/employees in a facility and I want to use this data to create two reports, one report to view the vacancies, the second will be used to calculate Payroll for the employees the reports must be dynamic, showing the last vacancies and Payroll data once updated by any team member I think we may need Google Script for the project
...PERFECT ( APEX GLOBAL TRADING AND MARKETING ) Location : we work world wide, and are creating many branches worldwide, we now have branches in ; Malaysia, Germany, USA, India, South Africa and are negotiating one in Uk at the moment Operation : WORLDWIDE SECRETARIAL AND OFFICE ONLINE SERVICES, TRADING, ENTREPRENEUR Products : - Typing from images
i have two sheets in excel,i want combine rows in one sheet if match with particular column value in excel
...google documents that contains a list of names that I need transferred into a Google Sheet. The documents contain names, file numbers, and a short description. They are not in a table, so I cannot just cut and paste the documents into the Google Sheet. The Google Sheet will be used to maintain a client contact list. There are around 5,000 entries to
I create new project workbooks based on predefined templates from many existing workbooks...create new project workbooks based on predefined templates from many existing workbooks. What I would like is a new project workbook with drop down menus that lets me choose sheets from different workbooks and copies all selections to the new project workbook.
Consolidate data from 91 Excel worksheets to a single sheet for bulk upload. The first sheet in the attached file is the bulk upload file; the first data set has been imported as an example.
Hi everybody, This is task for someone with google app script knowledge + advanced google sheets knowledge I am trying to create a Stock Portfolio Spreadsheet that can automatically search my Gmail inbox for (specifically titled emails, that have specifically titled) CSV attachments, and then import them onto a secondary Sheet of the aforementioned
Hi, I'm looking for someone with experience in conditional formatting etc within Google Sheets. The project is to format the relevant cells in an existing Google Sheets spreadsheet to reflect the progress of: - The total project - Each phase of the project - The completion of each task The end result to be a Gantt style chart to help us with our
Super easy project. For the 2 sheets labeled "Purchase Letter -Peo" and "Purchase Letter - QC", create a macro on each sheet that prints all the groups individually. Cell A2 needs to change each time. The value in A2 goes: 1, print, 2, print, 3, print....and on until the end of the list. Please ask questions before bidding. Again, this should
I have al...and insert data into google spreadsheet Step2 Update form to include the ability to have checkboxs, user input textbox, options that display in a checkbox and is able to both send and print on submit what i have followed so far that doesnt work [login to view URL]
Some Stats needs to be udpated in spreadsheet with little research over Google results.
I'm working on arcgis database designing, I prepared the database model in excel sheets I need a tool or script to convert the model into geodatabase without me having to create the feature classes and the attributes one by one
Need VBA code that will search for individual cells of from one sheet to and find the match in a different sheet and copy and paste what you find a separate sheet
Addon required for a Google sheet for saving sms received on a number from a specified number only. Addon should ask for both the number...a Google sheet for saving sms received on a number from a specified number only. Addon should ask for both the numbers when applied to a sheet. The receiving number would be in a phone permanently and receive sms.
Convert Written Spreadsheet to a computer document capable of being opening in Excel/Google Sheets/etc. Total of 27 Pages which have only limited information on it. Simple Quick Data Entry - 1 Page attached as Sample
I need you to fill in a spreadsheet with data. Data Entry I have spread sheets of names and email addresses I need entered into probably Google Spreadsheets. Data Processing, Data Entry, Excel, Virtual Assistant, Web Search $10 USD 18 minutes ago - 23 bids bids
...html and uses Google Sheets as the data source. The data table should be editable as inline and through the "New", "Edit" and "Delete" should be in real time so anytime the data is changed in the table it should be updated in real time in G Sheet. Make sure to use Bootstrap 4 as CSS framework and the latest v...
Need formula for google sheets I have a link attach to this. - need to get the sum from T2:T49 for cell O54 but sum need to be filtered by services from column S2:S49. - need to get the sum from T2:T49 for cell O55 but sum need to be filtered by Insurance from column S2:S49. -need to get the sum from T2:T49 for cell O56 but sum need to be filtered
We have a Google Form that posts...a Google Form that posts automatically to Google Sheets. There are 10 columns labeled "announcements" where twitter messages will land along with requested Date/Time to post. We need a script to automate the process of posting the tweet to "Tweetdeck" by the Date/Time triggered by updated Row in the Google Sheet.
I have a google sheet on which complex calculations are done to input provided. I want my users to e...google sheet on which complex calculations are done to input provided. I want my users to enter inputs through a form on webpage and get results after populating that data on google sheets. in real time The web page form has to be very simple one.