Clicking data in one sheet..Saving all those clicked in another.
Solved/Closed
Related:
- Clicking data in one sheet..Saving all those clicked in another.
- How to automatically transfer save data from one sheet to another in excel - Guide
- How to automatically transfer data between sheets in Excel - Guide
- Automatically transfer data from one sheet to another ✓ - Forum - Excel
- Macro to copy data from one sheet to another based on criteria ✓ - Forum - Excel
- How to auto populate data from multiple sheets to a master ✓ - Forum - Excel
2 replies
TrowaD
Sep 3, 2015 at 11:21 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Sep 3, 2015 at 11:21 AM
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
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
Sep 7, 2015 at 11:17 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Sep 7, 2015 at 11:17 AM
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:
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
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
Sep 3, 2015 at 01:53 PM
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!