Results 1 to 8 of 8

Make selection from Data Validation list and post current date stamp in different cel

Threaded View

hsmith Make selection from Data... 02-17-2012, 12:07 PM
Winon Re: Make selection from Data... 02-17-2012, 01:19 PM
hsmith Re: Make selection from Data... 02-17-2012, 01:47 PM
Winon Re: Make selection from Data... 02-17-2012, 02:48 PM
OnErrorGoto0 Re: Make selection from Data... 02-18-2012, 06:01 AM
hsmith Re: Make selection from Data... 02-17-2012, 02:56 PM
Winon Re: Make selection from Data... 02-17-2012, 03:09 PM
Winon Re: Make selection from Data... 02-18-2012, 03:11 AM
  1. #1
    Registered User
    Join Date
    02-13-2012
    Location
    Lakeland, FL
    MS-Off Ver
    Excel 2010
    Posts
    20

    Make selection from Data Validation list and post current date stamp in different cel

    I have this spreadsheet I am working on and have data validation lists set up in 2 columns currently A, B. Columns C- G currently are set up just for typing in data. In column H I want to automatically have current date entered when changes are made to any of the columns A-G and need to have this on the entire sheet. I'm pretty sure a macro is my best bet but have no clue how to even begin to start this one. I tried recording a macro and when I look at the code it produces it doesn't make any sense to me. Any help with this would be greatly appreciated.

    This is what I get when I record the macro

    Sub Macro2()
    
        ActiveCell.Offset(0, 7).Range("A1").Select
        ActiveCell.FormulaR1C1 = "=now"
        ActiveCell.Offset(1, 0).Range("A1").Select
        ActiveCell.FormulaR1C1 = "=now"
        ActiveCell.Offset(1, 0).Range("A1").Select
        ActiveCell.FormulaR1C1 = "=now"
        ActiveCell.Offset(1, -7).Range("A1").Select
    End Sub
    Last edited by hsmith; 02-20-2012 at 03:05 PM.

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