Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel
Previous Topic Next Topic

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

Report
-
 sram -
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...!!



2 replies

Answer 1 / 2
Posts
2774
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 13, 2021
 465
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
Report

Hello,
I click on one.. It goes and saves in new sheet.
I click another.. I want that to be pasted right below in the new sheet.
I'm looking to create an interface. Not just regular data copy paste.
Thanks for your reply, though.
I appreciate any further useful inputs!
Answer 2 / 2
Posts
2774
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 13, 2021
 465
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
Report

Thank you @ TrowaaD
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!