+ Reply to Thread
Results 1 to 8 of 8

Cell change --> date change macro

  1. #1
    Registered User
    Join Date
    02-05-2014
    Location
    Bratislava, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    18

    Post Cell change --> date change macro

    Hi there, here is my problem. I do have several columns (B,J) in which i can change some data. The thing i want is, to automaticaly write the date of last change in any of these columns in column K.
    In my search the best i found was this :

    Please Login or Register  to view this content.
    The problem is the offset. I can't figure out, how to set it, to change the data always in column K.
    Appreciate any help, thanks
    Last edited by K3mp3r; 02-05-2014 at 06:39 AM.

  2. #2
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Cell change --> date change macro

    Hi !

    Welcome to the forum...

    Can you please check if below is working!!

    Please Login or Register  to view this content.
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  3. #3
    Registered User
    Join Date
    02-05-2014
    Location
    Bratislava, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Cell change --> date change macro

    Works perfectly, thank you.
    One last question, but i not sure if this one is possible. Can it be made, that change of Rows 4-5 goes to K4, change of Rows 6-7 goes to K6, Rows 8-9 to K8 and so on ? Cause 2 rows always refer to 1 thing and if i merge K4 and K5, the changes in row 5 will not be displayed.

  4. #4
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Cell change --> date change macro

    In this scenario.. try this.

    Please Login or Register  to view this content.
    PS: Merge Cell & VBA are never a good friend.. try not to met them as much as possible.
    Last edited by Debraj Roy; 02-05-2014 at 07:35 AM.

  5. #5
    Registered User
    Join Date
    02-05-2014
    Location
    Bratislava, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Cell change --> date change macro

    Unfortunatelly, there is no change

  6. #6
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Cell change --> date change macro

    Please upload sample file for testing..

  7. #7
    Registered User
    Join Date
    02-05-2014
    Location
    Bratislava, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Cell change --> date change macro

    Here is the sample:

    Sample.xlsx

  8. #8
    Registered User
    Join Date
    02-05-2014
    Location
    Bratislava, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    18

    Re: Cell change --> date change macro

    Because of no further replies, i believe the last thing i wanted to know is not possible

+ 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. Macro to Change color of cell after cross referencing date with a given date.
    By liajet24 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-24-2013, 12:33 PM
  2. IF Function to change Date, on change of cell.
    By chrisa112 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-15-2012, 11:27 AM
  3. Replies: 5
    Last Post: 05-17-2006, 03:00 AM
  4. Run a macro with date/cell change
    By Darren in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-10-2006, 06:10 AM
  5. Cell value change to trigger macro (worksheet change event?)
    By Neil Goldwasser in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2006, 10:00 AM

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