Results 1 to 5 of 5

change date only if cell is changed

Threaded View

  1. #1
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    16,040

    change date only if cell is changed

    I have data in right column sorted as date and fields below... (attachment)...

    If some of cell in E column is changed (selected from drop down list in cell) I need date to change into today. If not leave last date...

    First time it look at E4 where is start date entered.
    A Report that you start to write.

    After that it look as it explained: if changed today() if not last date entered.

    If someone change start date it shouldn't affect dates below (Start date shouldn't be changed but you never know

    Every date should look only cells below it up to next date.
    Attached Files Attached Files
    Last edited by zbor; 05-09-2012 at 10:00 AM.
    Never use Merged Cells in Excel

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