Results 1 to 3 of 3

Append table values from one workbook to existing table in another workbook

Threaded View

  1. #1
    Registered User
    Join Date
    04-06-2013
    Location
    Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    10

    Post Append table values from one workbook to existing table in another workbook

    Hello,

    I am new to VBA and am working on my first serious use of VBA to automate some things in my forecast spreadsheet.

    I have a workbook each containing a worksheet named "Details" with a table named "Tabel1".
    I want to copy the values of table "Tabel1" and append those to the top (or bottom) of table "Tabel2" on worksheet "Blad2".
    I have been able to write code which copies and overwrites it, but I can't find how to append it.

    Code used for copy:

    Sub Append()

    'Append values of table 1 to table 2
    Range("Tabel1").Copy
    Sheets("Blad2").Range("Tabel2").PasteSpecial Paste:=xlPasteValues
    Application.CutCopyMode = False

    End Sub

    See the attached file which is a test version I am working with to develop the basic code.

    Thanks in advance for your help and advice.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1