copy and paste table in another existing worksheet

  • Thread starter Thread starter Andreas Aust
  • Start date Start date
A

Andreas Aust

Hi friends,

I have a little challenge for you and a big problem for me.

I need a macro, which is able to copy the table of on one worksheet
(worksheet1) in another worksheet (worksheet2).
In worksheet2 is already a table. The macro shall be able to find in
worksheet2 the first empty row after the existing table. The row begins
for example then with cell A2563. After the macro has found this cell
the table of worksheet1 has to be pasted.

Maybe you have a solution for me.

Thanks in advance
 
Dim LastCell As Range
Set LastCell = Worksheets("Sheet2").Range("A1").End(xlDown)
Worksheets("Sheet1").Range("A1:Z100").Copy Destination:=LastCel
 
Worksheets("Sheet1").Range("A1:Z100").Copy _
Destination:=LastCell.offset(1,0)

to drop down one cell after the last used cell.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do Excel define the application area? 3
matching multiple columns on different worksheets 1
trigger worksheet activate event in another worksheet 2
Paste into next blank row in a different worksheet 10
Go To Worksheet.Cell Referencing Another Worksheet.Cell 2
copy from dbf and paste to xls 1
Slow code when used as VBA code instead of macro (copying visible columns) 3
Copy a row down a column for the same number of rows of data in another workshee 6

Back
Top