As I just mean what is explained in VBA help …

The Macro Recorder as per its name and its purpose just records your actions to some VBA procedure.
So once that works manually, activate it, redo the same operations in order to get a code base …
From this base you will post here - with the codes tags (via # icon) as per this forum rules - I will revamp it
in order to work whatever the last column is, such a good start for you to learn !