+ Reply to Thread
Results 1 to 2 of 2

How can a timestamp in an Excel row be automatically updated if a.

  1. #1
    dt
    Guest

    How can a timestamp in an Excel row be automatically updated if a.

    I need a time stamp in each row of a ca. 300 row spreadsheet of user
    information such that the timestamp is automatically updated if any cell in
    its respective row is changed.

    My question: is this possible using Excel?


  2. #2
    Duke Carey
    Guest

    RE: How can a timestamp in an Excel row be automatically updated if a.

    Only with VBA code

    Assuming your time stamp is in column A. If some other column, change the
    column number in the code below

    right click the tab for the sheet in question and choose View Code, then
    paste this in

    Private Sub Worksheet_Change(ByVal Target As Range)
    ' next line assumes column A - change the number if a different column
    Const ColumnNumber = 1

    Cells(Target.Row, ColumnNumber).Value = Now()

    End Sub





    "dt" wrote:

    > I need a time stamp in each row of a ca. 300 row spreadsheet of user
    > information such that the timestamp is automatically updated if any cell in
    > its respective row is changed.
    >
    > My question: is this possible using Excel?
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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