google

Is there some how have bbs code to access GOOGle calendar . I used Google but find nothing.

Hi Is there any way to pull tables from the following website into a google sheet? https://stats.europeantour.com/widgets-v2/stats.html?season=2018&widgetNo=0#tableSGoffTee Have tried IMPORTHTML but with no luck. Thanks

Is there a way to allow group / ungroup in a protected excel sheet that is on google sheets? Thank you

Hello! I need to create an Excel spreadsheet on Google Docs, in order to be used by a Facebook group. Giving the large number of its members (> 100.000), I want the posted data to automatically be secured, so that once an input being operated the information can’t be modified by the next...

Hi Guys, Hope you are well I hope you would be able to help me. Is there a way for multiple selection listbox to be able to select the items in that listbox automatically, depending on a cell value when the button is pressed ? For example: I have a multiple choice listbox with eBay...

I have a formula in a Google sheet, it works great but the way I'm writing it I'll be here for years as I still need about 200 more IFs! So is there a shorter way of writing this? =IF(A4=5191,QUERY('Calibrated Gauges'!A2:Z,"select B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R where A='5191'")...

Can someone point me to code that uploads a file to Google Drive? I have many metrics that we want to automatically post to the cloud.

Hello Guys, Below is my VBA code request, i need to reduce my work load. Place all the files in a folder & run the macro, so all the data will merge in a single master file. Feature: Macro will consolidate the data as per sheet names,example Google --> Google Microsoft...

Hi Once, I saw a site which has .xlsx files which demonstrate cool applications like Analog clock, games, digital clock, thermostat etc. I tried to google but no success. Have you seen such website or do you know one. Thank you so much.

I am currently using the German version and it works great but I always end up having to retranslate alot of the text when it generates HTML code. I can setup a Google Drive Folder for the files to be placed inside for other users if someone has it? Please let me know, thanks!

I have a bunch of data in a Google Sheet and I’m trying to create a simple script that’ll loop and copy it over into the correct place in a second Google Sheet. DM SAMPLE SHEET (SOURCE) SM SAMPLE SHEET (DESTINATION) Rules for copy and paste: Loop through each row in the source sheet. If...

I have a spreadsheet with thousands of lines but I will just show one line because each row is independent. For the life of me I cannot figure out how to format the example in this message space, so I put a public link to a Google Sheet, but I am using EXCEL for the actual spreadsheet not...

Hi there, recently been trying to use Query function in google sheet. What I'm trying to do is combine certain data from all the tabs into 1 Master Summary for easy review. However I'm kind of stuck at the part where I need put multiple tabs in the formula, much appreciated! <style...

Hello there, I’m not sure this is possible (or even strictly legal), but I’ll ask in the vain hope it is. Is there an automated way to collect data from Google maps into Excel? I have a starting point (location/post code) in Cell A2, and a destination in Cell B2 (location/post code). I...

Hi I had this working last year but am unable to replicate this however hard I try!! I have some data which is importing into Google Sheets. I am now wanting to import the whole sheet into Excel. Last time whatever I did I just had to click on refresh and the data would automatically update...

Hi All, So I built this cool VBA coded heat map in Excel BUT...... having moved to a new role they do most of their work in Google Sheets so they can be collaborative. Problem is I need to recreate my heat map but, obviously, Google Sheets does not rely on VBA (it's Javascript instead isn't...

I need to calculate the distances between my company head office and a range of customer addresses. Is there a way of doing this in excel perhaps using google maps?. I am in the UK so the distance needs to be calculated between postcodes.

I have a google tracker which I updated everyday by uploading data from Excel. The process is cumbersome as many times the sheets/excel freezes. If there a VBA code/excel add-in that I can use to upload my data to google tracker from excel. The code should delete the old data on sheet and...

The problem starts when I import a table from Google Sheets, I use the option to publish on the web in the file menu from the sheet, the result is this: and in excel, after extracting data the result is this: what can be wrong when extracting?

Hello! I have been using google sheets but I now want to use Excel instead. I am using Excel 2010 with Win 8.1 and Chrome all on desktop. I had a formula made for me to display some data in a certain way, but it doesn't seem to work in Excel. Can anyone help with the Excel version please? I...