Results 1 to 16 of 16

Copying Rows from one table to another table based on index

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,946

    Copying Rows from one table to another table based on index

    Hi Guys,

    i want to copy rows based on array with index from table1 to table2:

    a = {1,2,5}

    so only rows: 1,2 and 5 should be copied.

    i was thinking to use advance filter with indexes but i do not know if this is possible. Or fulfill some artificial array or range to get it in advance filter which is the fastest way to do this i suppose.

    How can i do this?
    It is possible to copy multiple row without looping ?

    Or just looping, unioning them into range and copying ?

    Please help,
    Jacek
    Attached Files Attached Files
    Last edited by jaryszek; 10-22-2021 at 10:10 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 08-29-2021, 04:26 PM
  2. Insert blank rows above a table based on unique values in one of the columns in the table
    By carlito2002wgn in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-08-2019, 01:06 PM
  3. Insert blank rows above a table based on unique values in one of the columns in the table
    By carlito2002wgn in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-06-2019, 07:52 PM
  4. Replies: 1
    Last Post: 03-25-2018, 04:16 PM
  5. Add rows to table based on PIVOT table - Excel 2010
    By Pettaylor in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-27-2015, 08:49 AM
  6. Replies: 1
    Last Post: 11-25-2014, 08:35 PM
  7. Replies: 2
    Last Post: 04-16-2013, 06:17 AM

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