Clicking data in one sheet..Saving all those clicked in another.Solved/Closed

Question

Hello, 
I'm working on excel which has names(Col A) numbers (Col B). I'm looking to create a sheet, who by clicking on the number, stores the number in another sheet, collect all numbers in a similar way and save/submit. 
I could figure out to save entered data to store. But need help to save data which is already there and saves by a click. 
Any level of inputs are really appreciated...!!



Configuration: Windows 7 / Chrome 44.0.2403.157

TrowaD · Answer

Hi Sram,

How about this:
Hold CTRL while clicking on the numbers to save. Once done, right-click to copy and paste them in the desired sheet.

Best regards,
Trowa

TrowaD · Answer

Hi Sram,

In the code below, the destination sheet is called Sheet2 and the values will be pasted in the A column. Look up Sheet2 and A to change them to suit your needs:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Offset(1, 0).Value = Target.Value
End Sub

To implement the code: right-click the sheets tab you want this to work for (so not Sheet2) and select view code. Paste the code in the big white field.

Best regards,
Trowa

Clicking data in one sheet..Saving all those clicked in another.

2 replies

Subscribe To Our Newsletter!