google

  1. I

    Password a folder

    Morning. I have some zipped files that I need to keep for future reference. I wish to keep them in a folder on my pc & this is for my web site. I don’t wish to use google drive etc. Can the folder be password protected ?
  2. TAPS_MikeDion

    Google Sheets (Excel) - Always highlighted sheet?

    Would anyone happen to know why every time I go to one specific sheet in the Google Sheets/Excel workbook I'm working on, that particular sheet has all of its cells highlighted? I'm guessing it's something simple I'm missing. Every time I go to that one sheet, even if I click a cell to remove...
  3. L

    Search, find, highlight cell - cells are hyperlinks

    Hi All I'm in need of some help - i'm trying to use conditional formatting to highlight individual cell when a word is typed. So if i start to type the word google - the cell containing the word google highlights red with a yellow font. So if i type g or goo the cell containing the word...
  4. B

    Need VBA to interact with PDFMaker addin

    Hi all, I have an Excel file with internal links that needs to be saved as PDF. I have found a way to manually do this using the PDFMaker add-in, but am now trying to automate this but am really struggling. I've tried to Google some results but have had no luck there either. Does anyone have...
  5. L

    Minimizing utility

    Hello guys, I have a file at work that has interesting functionality. It has a minimize set up for each month that you can expand to see per day. It's very convenient and i would like to replicate it, but I'm not sure what to even google for, maybe you have some ideas? Image of what i mean can...
  6. D

    Syncing w Google Calendar

    Is there a way to put a date/time in a cell in Excel and have that then synced to my Google Calendar?
  7. G

    Google sheets vlookup

    I have a vlookup in Google Sheets that isn't making sense to me. =MID(A3,search("(",A3,1)+1,6) returns 263972 =vlookup(263972,$S$3:$X$158,3,0) returns the expected result =vlookup(MID(A3,search("(",A3,1)+1,6),$S$3:$X$158,3,0) returns N/A. (Did not find value '263972' in VLOOKUP evaluation.)...
  8. S

    Google Datastudio alternative when using Excel

    Dear all I'm currently using Google Sheets to manage my stock portfolio. The system is to enter day which is tweaked and analyzed in many ways. To visualize data, current status and that I'm (hopefully) on track I use Google Datastudio. Actually I would like to move from Google Sheets to Excel...
  9. R

    Having a right nightmare with exporting Tab Delimited from 2003 to .txt format for Google Shopping Upload

    Hi I have been tearing my hair out with this conundrum and still no nearer to solving. We have a TXT feed from our website to Google Shopping which uploads every morning at 6:00am largely without errors. From time to time, we need to edit items and re-upload during the day. I have downloaded...
  10. E

    Split Column to text in google sheets custom

    I need to split the column into text please can someone tell me how to do this in google sheets <tbody> AJANTPHARM19JAN1180CE CE AJANTPHARM 19JAN 1180 ADANIPOWER19AUG65CE CE ADANIPOWER 19AUG 65 APOLLOHOSP19AUG1400CE CE APOLLOHOSP 19AUG 1400 </tbody> Above is an example of how the column...
  11. C

    Formula deduction

    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...
  12. R

    IMPORTHTML Help (Google Sheets)

    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...
  13. S

    Show cell number or text by referencing several cells and select the highest of all(more than 3 items)

    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...
  14. M

    Google sheets - trying to convert formula to a script

    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
  15. A

    Remove Columns

    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.
  16. H

    Textbox value to cell

    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
  17. Q

    VBA - Search Google

    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 "&" -...
  18. S

    [VBA] Runtime Error 3004 - Write to file failed

    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...
  19. Y

    Return a google drive share link from the google drive folder in VBA

    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
  20. M

    Button with link url based on cell

    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...

Some videos you may like

This Week's Hot Topics

Top