Results 1 to 2 of 2

Thread: VBA code to copy data from tables on different worksheets and put them in one table
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2018
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default VBA code to copy data from tables on different worksheets and put them in one table

    Hi,

    I have 3 tables in 3 different worksheets. I want to setup a Macro to copy and paste the data from all 3 tables into another workbook (pre-existing), pasting one below the other and keeping the set of headings from the first table.

    The headings of the 3 tables are all identical.

    The number of rows in the table will change every time I use this Macro as data is constantly being added to these 3 tables.

    So let's assume:

    Sheet1
    Table range:
    - columns A:C
    - rows: currently 1-5, but could be longer

    Sheet2
    Table range:
    - columns A:C
    - rows: currently 1-5, but could be longer

    Sheet3
    Table range:
    - columns A:C
    - rows: currently 1-5, but could be longer


    I'm new to Mr Excel so forgive me if I've written anything incorrectly.

    Really appreciate anyone who can help.

    Happy to answer any more questions if need be.

    Kind regards,

    Jonny

  2. #2
    Administrator starl's Avatar
    Join Date
    Aug 2002
    Location
    Everywhere!
    Posts
    5,859
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VBA code to copy data from tables on different worksheets and put them in one table

    There are many existing example of this at the board if you do a search. Like this one:
    https://www.mrexcel.com/forum/excel-...ease-help.html

    Very similar to your request.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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