+ Reply to Thread
Results 1 to 4 of 4

Date Modified Formula/Macro?

  1. #1
    Registered User
    Join Date
    08-27-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    11

    Date Modified Formula/Macro?

    When a cell is Column AK is updated, how do I reflect the date modified in the corresponding cell in BY?

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Date Modified Formula/Macro?

    Hi shootingstarz,

    You could use event code such as:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    08-27-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: Date Modified Formula/Macro?

    Hi-

    I'm sorry, for some reason this doesn't seem to be working? This is all a foreign language to me, so I apologize if I'm missing something - would I need to edit any of the above assuming 37 and 77 were the correct columns?

    Also, are there any formulas that can be inputted in the actual cells to calculate this as opposed to VBA?

    Thank you!!

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Date Modified Formula/Macro?

    The code goes in the worksheet module - you could put:

    Please Login or Register  to view this content.
    in BY1 etc

+ 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