+ Reply to Thread
Results 1 to 9 of 9

Migrate VBA that sets time stamp to Google Sheets

  1. #1
    Registered User
    Join Date
    03-26-2013
    Location
    Lebanon
    MS-Off Ver
    Excel 2010
    Posts
    29

    Migrate VBA that sets time stamp to Google Sheets

    I Have A Excel Google Sheet

    https://docs.google.com/spreadsheets...gid=1664593221

    I Need A script To Auto Fill Time Stamp if specified cells are Greater Than Zero

    If B6:B500 Or D6:D500 are above Zero

    To Set Time Stamp In This Format HH:MM:SS ( 10:12:55 )

    To The Same Cell Of Column A

    Thanks for your help In Advance

    Mark.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,531

    Re: Google Sheets Auto Set Time Stamp Script

    Permission is required to access this file.

    Is this an Excel file stored on Google Docs, or this is a Google Sheets spreadsheet? Those require two different scripting languages so you need to be specific.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    03-26-2013
    Location
    Lebanon
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: Google Sheets Auto Set Time Stamp Script

    I gave permission Now, can any one Help Now Pls.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,336

    Re: Google Sheets Auto Set Time Stamp Script

    Answer the question in post #2, please.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Registered User
    Join Date
    03-26-2013
    Location
    Lebanon
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: Google Sheets Auto Set Time Stamp Script

    Its an Excel file Uploaded to Google Docs

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,531

    Re: Google Sheets Auto Set Time Stamp Script

    If you make any change in column B or D and the update is >0 then a timestamp will be added/updated to the same row of column A.

    This is an Excel VBA solution and I don't know if it will run if you edit it online in Google Docs.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    03-26-2013
    Location
    Lebanon
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: Google Sheets Auto Set Time Stamp Script

    It worked exactly as needed but over excel file on my local pc but not when uploaded to google sheets. Google sheets need a special script,
    Can any one help
    Any way jazzar thanks for ur reply it was helpful i am using it over excel local .

  8. #8
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,531

    Re: Migrate VBA that sets time stamp to Google Sheets

    Moved from Excel General and updated title.

  9. #9
    Registered User
    Join Date
    03-26-2013
    Location
    Lebanon
    MS-Off Ver
    Excel 2010
    Posts
    29

    Re: Migrate VBA that sets time stamp to Google Sheets

    Thanks Jazzer,

    Any one Can Help To Create a Script For Google sheet to auto set up Time to specified columns as in excel attached pls.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  2. Time Stamp Active Cells and Record a History of Time Stamp and Active Cell Value
    By harishangaran in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-22-2017, 12:41 PM
  3. VBA - Private Sub to Copy Date/Time Stamp from other sheets to an Index sheet
    By order in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-02-2017, 12:24 PM
  4. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM
  5. Computer time stamp -> excel time stamp
    By j.petrut in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-27-2014, 05:49 PM
  6. How to get time stamp and user name stamp
    By eskains in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-07-2013, 09:44 AM
  7. Macro to use time stamp from two differnt sheets and export row #
    By jblewis in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2010, 01:36 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1