Replace "Notes" in Col D

Whereever Notes appears in Col D on Sheet "Data Import", I need macro to insert a formula by taking the cell to the left of it -1 for e.g.. if Notes ins in D1 and 1 is 2022 then D1 must be C1-1 i.e 2021

It woould be appreciated if someone could provide me with the code

try

Please Login or Register  to view this content.