Copy cell value on double click

**wellous** · 12-01-2014, 01:24 PM

Hello Experts,

When i double click on any cell from range (B10:J40000)
I want to copy the cell value to same column but to row 7 .. i found the code below but it's doing different job , please help me to modify it in order to be able to perform the task i want.
Attached a sample for ref.

many thanks,
Wellous,

Please Login or Register  to view this content.

**simarui** · 12-01-2014, 02:43 PM

looks like this is working to me:

Please Login or Register  to view this content.

**wellous** · 12-01-2014, 02:47 PM

Yes it's working after your touch

thank you!

**rajeev_iritty** · 10-11-2015, 06:32 AM

Hi all i am a beginner
can any one help me to create a marco such a way that....
In a sheet
let b1 to b50 contains some data...
In same sheet
1. I selected cell a1 by clicking it
2. Now i double clicked b1 or b2 or .....b100
3. Then value in b1 or b2 or ....b100 must copy to a1 and cell a2 must selected to ready for next double click event

some please help me
thanking in advance