+ Reply to Thread
Results 1 to 2 of 2

Timestamp Update Using Formula in Excel But Different Sheet

  1. #1
    Registered User
    Join Date
    11-10-2019
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    Excel 2013
    Posts
    2

    Timestamp Update Using Formula in Excel But Different Sheet

    For Timestamp Update Formula:

    =IF(B4″”,IF(AND(F4″”,CELL(“address”)=ADDRESS(ROW(B4),COLUMN(F4))),NOW(),IF(CELL(“address”)ADDRESS(ROW(B4),COLUMN(B4)),F4,NOW())),””)

    Works fine when it is on the same sheet, but its not working for different sheet even after changing the reference all B4 into Sheet1!B4 and looking output in the Sheet 2 in F4 Cell

    I want my result into Sheet 2 where data will be enter in Sheet 1, any idea or solution?

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Timestamp Update Using Formula in Excel But Different Sheet

    Hi, welcomde to the forum.
    Please use code tags when embedding code or formulas, makes it readable and leaves the quotes as quotes

    Please Login or Register  to view this content.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ 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. timestamp comments on creation or update
    By shani908 in forum Excel General
    Replies: 4
    Last Post: 09-08-2016, 08:08 AM
  2. [SOLVED] Update timestamp only first time
    By asterixo500 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-18-2015, 02:39 PM
  3. How to update sheet references in excel formula?
    By meng.lee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2012, 11:48 AM
  4. update timestamp if change_event for all column in row
    By dainova in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-07-2012, 01:29 AM
  5. If cell A1 already contains a value don't update timestamp in B1
    By BEERCAN in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-25-2011, 01:26 PM
  6. Is there a Timestamp function that does not update in Excel?
    By Guard 823 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-25-2005, 11:06 AM
  7. Timestamp function that does not update in Excel?
    By Guard823 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-25-2005, 10:06 AM

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