copy and paste table in another existing worksheet

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
 
B

BrianB

Dim LastCell As Range
Set LastCell = Worksheets("Sheet2").Range("A1").End(xlDown)
Worksheets("Sheet1").Range("A1:Z100").Copy Destination:=LastCel
 
D

Dave Peterson

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

trigger worksheet activate event in another worksheet 2
How do Excel define the application area? 3
Go To Worksheet.Cell Referencing Another Worksheet.Cell 2
matching multiple columns on different worksheets 1
Paste into next blank row in a different worksheet 10
Using cell value to reference another cell 2
copy from dbf and paste to xls 1
Copying the last used cell only 4

Top