Results 1 to 11 of 11

Update current dates in different cells when value in a Target column cells changes

Threaded View

  1. #1
    Registered User
    Join Date
    03-25-2013
    Location
    New Delhi
    MS-Off Ver
    Excel 2003 and 2007
    Posts
    37

    Update current dates in different cells when value in a Target column cells changes

    Hello Everyone,

    I am back here with another problem I am facing with a tracker.

    I have a workbook wherein there are multiple status in Column N (Data validation list) and I would like to get current date in different cells whenever the status in Column N (range "N2:N1000") changes.

    If a cell value in Target Column “N” changes current dates should get updated in the respective cells under different headings (column “V” to “AC”, “AG to “AJ”, Column “AO” to “AU” and Column “AZ” and “BA”.

    E.g
    If Cell N2= “Status 1” then current date should get updated in Cell “V2”, If Cell N2=”Status 2” then cell W2 should be updated with current date, If Cell N2=”Status 3” then cell X2 should be updated with current date and so on…

    Please check the attached workbook wherein there’s a Status column (in Red), when the value in any cell (N2:N1000) in this column changes current date gets updated in the corresponding cells under the columns “V” to “AC”, “AG to “AJ”, Column “AO” to “AU” and Column “AZ” and “BA” (headers in Red font) not in sequence.

    I can use the "IF" formula but, Each time I open the workbook the current dates will get updated automatically which is not the purpose I would like the current date to remain unchanged once updated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Adapt my current VBA Code to update pivot based selection in 2 cells
    By michelle 1 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-24-2015, 03:34 AM
  2. Replies: 9
    Last Post: 02-12-2015, 03:53 AM
  3. Code to update cell with current date & time when other cells are modified
    By gjtbackwards in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-12-2014, 07:54 PM
  4. Vba code to update a cell value based on its current value and another cells value
    By g.h0st.snwbrd3r in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-12-2013, 02:52 PM
  5. [SOLVED] Worksheet_Change(ByVal Target As Range) - set to only update when 3 target cells changed?
    By trillium in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-07-2012, 06:40 PM
  6. lock all cells before current date (Dates are in Column)
    By Sanoj in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-07-2012, 12:36 PM
  7. Replies: 3
    Last Post: 03-07-2012, 11:04 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