Cells copying and pasting in a empty cell of another sheet

 Lameidiot5 -

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?


System Configuration: Windows / Edge 17.17134

1 reply

Here is an article that will help you in your quest....ccm.net/faq/53497-how-manipulate-data-in-excel-using-vba

Have fun.