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 modulePlease Login or Register to view this content.
- 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