Cells copying and pasting in a empty cell of another sheet [Solved/Closed]

Question

Cells copying and pasting in a empty cell of another sheet [Solved/Closed]

Report

Parker - Jan 7, 2020 at 09:46 AM
TrowaD

Posts: 2695
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: January 28, 2021

- Jan 30, 2020 at 11:36 AM

Hello,

One Excel file has 2 Sheets. First sheet called "source" and second one called "Bestand"
In sheet "source" one cell (a1 for example) must be copied and paste in sheet "bestand" in row 1.
In Row 1, I could have already datas in cells a1,b1,c1,...., cn. So pasting must be done in the next free cell of row1

How can i do this with VBA-Macro?

Thanks

System Configuration: Windows / Edge 17.17134

Cells copying and pasting in a empty cell of another sheet
Copying cell from one sheet to another - How-To - Excel
Copying cells from one sheet to another ✓ - Forum - Excel
How to copy cells from one sheet to another in excel using formula - How-To - Excel
Excel copy cell from one sheet to another if a condition is met - Forum - Excel
Excel - Copy data into next empty cell in new sheet - How-To - Excel

1 reply

Ask a question

TrowaD · Accepted Answer · 2020-01-30T11:36:33-0500

Answer 1 / 1

TrowaD

Posts: 2695
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: January 28, 2021

457
Jan 30, 2020 at 11:36 AM

Hi Parker,

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

Cells copying and pasting in a empty cell of another sheet [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!