+ Reply to Thread
Results 1 to 10 of 10

Help Needed with Formula or Code for Attached Test Spreadsheet - Device Timestamping Help

  1. #1
    Registered User
    Join Date
    07-18-2016
    Location
    Illinois
    MS-Off Ver
    2010
    Posts
    53

    Help Needed with Formula or Code for Attached Test Spreadsheet - Device Timestamping Help

    Thank you for reading my post.

    Hello, thanks for your help. I'm looking to ping device list and enter current timestamp in column E if column D cell = "Online" as well as update the timestamp in column B. If the cell in column D = "Offline" I would like column E to keep the timestamp from column B. Basically trying to keep track of whether a device is online or offline and the last time it was online. Any help would be great. Thanks Again.

    See attached spreadsheet.

    Thanks Again.
    Kevin
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: Help Needed with Formula or Code for Attached Test Spreadsheet - Device Timestamping H

    Try this code in the sheet code module. (Right Click on sheet tab, Select View Code, and enter the code in that box)

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    07-18-2016
    Location
    Illinois
    MS-Off Ver
    2010
    Posts
    53

    Re: Help Needed with Formula or Code for Attached Test Spreadsheet - Device Timestamping H

    Maniacb, thank you for helping me. The above code didn't work (see attached photo). I entered the code into the box and saved, clicked ping and just the ms and Online/Offline show up. I've attached a photo to show you where I put the code and the result on the spreadsheet.

    Thanks,
    Kevin
    Attached Images Attached Images

  4. #4
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: Help Needed with Formula or Code for Attached Test Spreadsheet - Device Timestamping H

    It may be that your enableevents is turned off. I also made the assumption that your ping code would change the value from Offline to Online. To turn on enableevents, run:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    07-18-2016
    Location
    Illinois
    MS-Off Ver
    2010
    Posts
    53

    Re: Help Needed with Formula or Code for Attached Test Spreadsheet - Device Timestamping H

    Good morning maniacb,

    Would it be possible for you to put the code in the spreadsheet for me on the attached "Test.xlsm" spreadsheet. The ping code only goes out and determines a ping. It doesn't set the value of Offline to Online. I just had a helper cell with "=IF($C2=" ms","Offline",IF($C2="","","Online"))" that populates the online/offline status.

    I tried right clicking, sheet 1, enter code, and put the enableevents into the code and saved, no luck.

    Can you try to get it workin for me and upload/overwrite the attached Test.xlms? Thank you so much.

    Kevin

  6. #6
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: Help Needed with Formula or Code for Attached Test Spreadsheet - Device Timestamping H

    You put it in the right place. Changes by formulas don't execute an event. I've rewritten the code key off column C instead.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    07-18-2016
    Location
    Illinois
    MS-Off Ver
    2010
    Posts
    53

    Re: Help Needed with Formula or Code for Attached Test Spreadsheet - Device Timestamping H

    Good afternoon maniacb,

    I've been trying to figure out how to manipulate the code and playing with it but no luck on my end. Please see the below screenshot with comments. Thanks for your continued help with this.
    Attached Images Attached Images

  8. #8
    Registered User
    Join Date
    07-18-2016
    Location
    Illinois
    MS-Off Ver
    2010
    Posts
    53

    Re: Help Needed with Formula or Code for Attached Test Spreadsheet - Device Timestamping H

    @maniacb Still with me on this excel problem? Your help would be very helpful.

    Thanks,
    Kevin

  9. #9
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: Help Needed with Formula or Code for Attached Test Spreadsheet - Device Timestamping H

    Here's an update. Let me knowhow it fares.

    Please Login or Register  to view this content.

  10. #10
    Registered User
    Join Date
    07-18-2016
    Location
    Illinois
    MS-Off Ver
    2010
    Posts
    53

    Re: Help Needed with Formula or Code for Attached Test Spreadsheet - Device Timestamping H

    This worked pretty well in my test file. Let me apply it to my production and i'll give you an update in a few days. Thanks for coming back =)

+ 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. Formula Help with Attached Spreadsheet Needed -Many Thanks in Advance
    By kcstier in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-23-2020, 05:27 PM
  2. [SOLVED] VBA Check if Sheet Exists, if it does, run code. Test File Attached
    By unit285 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-14-2016, 01:23 PM
  3. [SOLVED] VBA Code that can split the contents of a cell into two cells? (Spreadsheet Attached)
    By Chad Bateman in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-28-2015, 09:11 PM
  4. [SOLVED] Needed: VBA code to edit/update data (sample workbook attached)
    By MileHigh_PhD in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-23-2015, 01:30 PM
  5. FIFO-LIFO UDF function not working if DataRange are apart from each other
    By Par in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-12-2014, 06:02 PM
  6. Replies: 8
    Last Post: 10-28-2013, 07:36 PM
  7. [SOLVED] Formula needed for auto fill across multiple worksheets-see attached spreadsheet
    By excelteam777 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-11-2013, 10:38 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