Copy data to another sheet a double click option vba

Hi all,
I am using the following code to double click the cell in column 'Q' in sheet2
This copies data to sheet1 and works perfect.

The copy resize is done upto columns 8 in sheet2
I also want column 'P' cell in sheet2 copied and pasted to column 'I' in sheet1 by modifying the code.

I need help here please

Please Login or Register  to view this content.

Please help

Kind regards

Hi KK1234, this may be a start (in the Sheet2 module):

Please Login or Register  to view this content.

See how that works for you and if I understood you correctly.

Cheers, berlan

Hi all,

I have resolved it simply by rearranging the columns in sheet 1 & 2 and changing the resize to 10 and it works fine.
Simple but effective.

Please Login or Register  to view this content.

thanks to all those have viewed it
Kind regards

Hi berlan,
Thanks for your kind help.
I have tried your solution and it works fine too.
I will save it for future reference.
Before I could view your answer I had found a self solution, hence I had closed the thread.
I have clicked * to thank you.
Kind regards