+ Reply to Thread
Results 1 to 2 of 2

Date Stamp column when any cells in specific range are changed

  1. #1
    Registered User
    Join Date
    08-09-2012
    Location
    Qld
    MS-Off Ver
    Excel 2003
    Posts
    1

    Date Stamp column when any cells in specific range are changed

    I am fairly inexperienced using Excel, and am seeking some assistance finding the right code for a date stamp issue.
    I would like to be able to have the current date inserted into a specific column when any of the cells between column A to I in that row are changed.
    I would like the cell in column J to have the current date inserted when the any cells in columns A to I are changed within the same row. At the moment I have managed to have a date stamp inserted into the relevant row of column J when I enter/modify contents of cells in column A, using the following code:

    Please Login or Register  to view this content.
    If anyone knows what code I should be using to have the date stamp in the same column but enable this to happen when ANY cell in the same row between column A and I are modified, that would be fantastic.
    Last edited by Cutter; 08-09-2012 at 09:19 PM. Reason: Added code tags

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Date Stamp column when any cells in specific range are changed

    @ Isabell

    Welcome to the forum.

    Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
    Thanks.

+ 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