Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy and paste table in another existing worksheet
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy and paste table in another existing worksheet
Dim LastCell As Range
Set LastCell = Worksheets("Sheet2").Range("A1").End(xlDown) Worksheets("Sheet1").Range("A1:Z100").Copy Destination:=LastCel -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy and paste table in another existing worksheet
Worksheets("Sheet1").Range("A1:Z100").Copy _
Destination:=LastCell.offset(1,0) to drop down one cell after the last used cell. "BrianB <" wrote: Dim LastCell As Range Set LastCell = Worksheets("Sheet2").Range("A1").End(xlDown) Worksheets("Sheet1").Range("A1:Z100").Copy Destination:=LastCell --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to copy and paste over existing files | Excel Discussion (Misc queries) | |||
Creating pivot table to Existing worksheet | Excel Worksheet Functions | |||
copy Data selection from one workshhet into an existing worksheet | Excel Worksheet Functions | |||
Copy / paste from a table in word .doc to excel .xls worksheet | Excel Discussion (Misc queries) | |||
adding a pivot table to an existing worksheet- HELP!! | Excel Discussion (Misc queries) |