google

I have created a spreadsheet in google sheets and I am having problems with the following formula. Please see attached link to the google sheet. In column K the formula works out the figure after a number is entered in column M but I need the figure in column K (after calculation) to also be...

Hi, I have previously used =IMPORTHTML to return the list data for all of the names under the headings: Goalkeepers, Defenders, Midfielders, Forwards - from the below webpage. https://fantasy.premierleague.com/player-list/ However, this page has been redesigned and suddenly my formula N/As...

Hi all, This is my first time asking question online for excel(mostly just google and have the answer) but i struggle to think of a good way to ask this question on google. Basically I am making a cell at E2(shown below) to show subject 1 OR A2 <tbody> A B C D E 1 subject 1 subject 2...

Good afternoon Demigods, I have the following formula in google sheets: What i am after is the formula converting to a google script. Any ideas please? Best regards manc

One of my worksheets stops at column "Z" and there's nothing to the right of it. How did I do this ? Can't remember and can't find how from Google. Thanks.

I need some Help to get Value from 16 differens Textbox to set value in Specific cell's on my Userform12 textbox 1 to cell P7 textbox 2 to cell P8 and so on to Textbox 16 i have search around google but not find the answer i want

I have the following code which triggers when the user double clicks on a field: Application.FollowHyperLink "http://www.google.co.uk/search?q=" & BusinessName This works fairly well and opens Google to search for the value in the BusinessName field. However, some Businesses contain "&" -...

Hello, so I have a code to download a google sheet as excel to my computer. I'm getting the following error in my code and can't figure out what's wrong: (line highlighted in red) Sub ImportGoogleSheet() Dim URL, Location, FileName As String Dim objWeb, objWrite As Object URL = "Google...

I'm looking for a way to create a macro which will go to my local google drive folder and the folder name (let's say in cell A1), make it shareable to anyone (manually it's mouse right click >> Google Drive >> Share >> Get shareable link) and write in cell A2 that shareable link

Hello. I am trying to figure out a way to have a single button send the user to google based on the content of a cell. For example. If F1 has JANE DOE... then once the button is pushed it would send the user to google and JANE DOE would already be in the search. I would think a simple google...

Hi Friends, I have constructed list of Google CSE JSON API urls with keywords to extract Linkedin profiles data into excel. I have VBA script which can extract Google CSE ATOM results. But, unfortunately Google has change ATOM results to JSON API results. So, the script is not useful anymore...

Hi Virtual Friends, I'm a newbie in VBA coding and would need your great help. I have a list of incomplete customer names (our internal system truncates the name based on character restriction) and I'm trying to retrieve their respective address leveraging Google API capabilities and VBA. The...

Hello there, This might be a really dumb question, if it is, just tell me it is! As part of my job, I have to get the time and distance between two post codes and with over 200 to do, it's bit of laborious process! I used to literally copy and paste every post code into Google, I've improved...

G'day all, I see that Google now has it's own macro functionality using a non-VBA language. I'm thinking of exploring it's potential, importing a macro etc., does anyone have any thoughts or experience on this yet? My macros all use features like dictionaries & arrays, will Google Sheets be able...

Hello, I am having trouble coming up with a macro that searches google based on a cell value, then returns the Google review score. I tried modifying the below code to suit my needs but keep getting a Run-time error 91 Object variable or With block variable not set. Any help would be greatly...

Hi, I'm looking to create a macro that will allow me to setup a spreadsheet template whereby the user is prompted to select one value, then another and on the basis of these 2 other values are populated. So for example, the user is prompted to choose a category and then a division, which then...

Hi, Can anyone please help? I have the following code and I am looking to Google Maps to return the url of the final page. At present it is only returning the intitial load up url. Below is my simple code so far, Sub GotoAddress() Dim IE As New InternetExplorer IE.Visible = True...

Hi, I'm after a macro that will automatically open links as they populate in Google Sheets. Using Zapier and API I have links that are automatically loading into Google Sheets. Lets say each time a new row is made and a new link is inserted in Column A, how would I then get my computer to...

Every time I click outside of a pivot table the fields on the far right disappear. I'd like to keep them on all the time. Is there a way to do this? Google hasn't shown a solution.

I've written VBA that reads emails when they arrive on my PC at home, extracts relevant details, looks up necessary info and saves or updates records in an Excel sheet. This enables me to leave my PC running and have it automatically load new orders while I am on the road. Because two of us...