Cells copying and pasting in a empty cell of another sheet
Solved/Closed
Parker
-
Jan 7, 2020 at 09:46 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jan 30, 2020 at 11:36 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jan 30, 2020 at 11:36 AM
Related:
- Cells copying and pasting in a empty cell of another sheet
- Excel macro to create new sheet based on value in cells - Guide
- If cell contains specific text then return value in another cell ✓ - Excel Forum
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Compare 2 text cells and show difference in the third cell ✓ - Excel Forum
- Little alchemy cheat sheet - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Jan 30, 2020 at 11:36 AM
Jan 30, 2020 at 11:36 AM
Hi Parker,
The following VBA code will do as requested:
Best regards,
Trowa
The following VBA code will do as requested:
Sub RunMe() Sheets("Bestand").Cells(1, Columns.Count).End(xlToLeft).Offset(0, 1).Value = Sheets("Source").Range("A1").Value End Sub
Best regards,
Trowa