active cell to populate date from same row into a particular cell help

[lilsnoop]

Looking for some help with a macro that could do the following. Looking for a macro that if a cell is selected in column H (H2 down to H6000) that the date in column D in the same row of the active cell will populate in cell I1. So as an example if I were to select cell H12, the date of 5/04/2021 would display in cell I1 and if I selected cell H20 the date of 09/20/2021 would show up in cell I1 as demonstrated in my sample workbook. Thank you!

[Croweater]

Try...

Please Login or Register  to view this content.

[lilsnoop]

Croweater-Your code worked perfectly! Really appreciate your time and help with this!

[Croweater]

You're welcome.