I have two Excel 2007 worksheets with identical formats. How do I append the second one to the first one to form a single resulting worksheet?
If its a simple copy paste, just select the data in the 2nd sheet (without the headers, so start at row2) and press Ctrl+C and then go to your last row of the first worksheet and press Ctrl+V.
If you want to do it thru macro use this code -worksheets(2).rows("2:10").copy worksheets(1).range("A" & rows.count).end(xlup).offset(1,0)
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
S O L V E D !Originally Posted by arlu1201
One suggestion -- include instruction that the worksheets to be combined must be visible. Best way is to place them into the Desktop before performing the steps outlined. When I'll have a little more time, I will try your suggested macro coding.
Thanks! <CharleyDog>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks