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
Bookmarks