Copy selected cell content into D1, then D2, D3 etc.

Hello;

Hope everyone is doing great. I have a simple Excel question to ask and would like to know if there is a solution for it

1- I have a list of operations in Column A1:A30 (for example, A1=MS10, A2=MS15, A3=MS20 and so on)
2- What I need is to copy and paste the content of any clicked cell, ranging from (A1:A30) into Column D1, then my next click in column A should appear in D2 and so on
3- In other words, If I click A1 then copy A1 to D1, If I click A5 then copy A5 into D2, If I click A20 then copy A20 into D3
4- If a cell in column A is clicked for 2nd time then ignore and do nothing

Is this possible?

Best Regards

Adsk

Good Morning Alpha

This is much appreciated. I will try your code and will let you know

Best Regards

Hello Alpha

Just wanted to let you know that your code worked like a charm.
Thank you very much for your help

Best Regards