I came across the below VBA and need some help to modify it.
First it auto fills the date and time in I1 whenever you selected from a drop down in H1.
I have also added another to it that adds date and time to cell J1 whenever you choose "Closed" in cell E1.
This all works great for what I want...