double click function on cell that selects row and copy and paste on another sheet

[francescoslash77]

Hello, I'm here again asking for your precious help.
Thanks to Mumps1's patience and help I was able to create the file I needed. Now I need a function, what I would like to do is use the double click function. Double clicking on a row in column "E" I would like that would copy the data into the "Archive" Sheet, as if you were using the Userform. for example if from the Userform I select "TP" he selects all the "TP" values in column "B" but I would also like to select them individually, that's why I would like to use the double click. what do you think?
Thank youTEST.xlsb

[AliGW]

Your thread title does not really convey what you want to do - please make it more descriptive.

You must do this NOW before any further help is offered. Thank you.

[francescoslash77]

Hi all, can anyone help me?