Hello,
I need to have cell H2 populate the date when cell H8 is changed.
Can someone please assist me with this?
Thanks!
Hello,
I need to have cell H2 populate the date when cell H8 is changed.
Can someone please assist me with this?
Thanks!
Hello & Welcome to the Forum,
This will require VBA...
Paste the code in a Sheet modulePrivate Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("H8")) Is Nothing Then Range("H2").Value = Date End If End Sub
- Where to paste code
- Highlight macro to copy >> Ctrl + C >> Open your workbook
- Right click on sheet tab >> View Code >> opens the Visual Basic Editor (VBE)
- Ctrl + R >>opens the Project Explorer (if not already open on left side of screen)
- Paste code >> Ctrl + V (right side of screen)
- Alt + Q >> exits VBE and returns to Excel
- Now simply make a change in cell H8
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks