+ Reply to Thread
Results 1 to 2 of 2

Copy and paste certain rows of a table to create a new table

  1. #1
    Registered User
    Join Date
    06-13-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Copy and paste certain rows of a table to create a new table

    I have a table that had a couple thousand rows in it. The first column has a bunch of number IDs in it. A specific ID may be in the column multiple times. I have a separate column outside the table that has a list of unique IDs. What I would like to do is create a new table where the first column only contains IDs from the separate list of IDs. For instance:

    my sample table: the column of unique IDs:

    ID value | unique ids
    1---44--|---1
    2---41--|---2
    1---39--|---6
    3---26
    6---17
    12--15
    12--14
    2---14
    2---12

    new table I want to create based on the above table and ID list:

    ID value
    1---44
    2---41
    1---39
    6---17
    2---14
    2---12

    In the above example, I specify the IDs 1, 2, and 6 so the resulting table I want to create can only have IDs 1, 2, 6 in the first column. The resulting table is a subset of the original table. Can I write a formula or something that does this without writing a macro? I am sure I could write a macro to do this but would like to know if it can be done without a macro. I have turned the data into a table and I can click on the column and uncheck all the values I do not want and that works if you just have a couple of ones you want to select or deselect but I have ~200 IDs I need to select so I would like it to be automated. Like take all the values in Column O and cross reference then with Column N and all the rows that match in the table, copy them to some box.
    Last edited by redhawk87; 04-12-2013 at 11:42 AM.

  2. #2
    Registered User
    Join Date
    06-13-2012
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Copy and paste certain rows of a table to create a new table

    I think I decided to just write a macro. Will post a similar thread in the VBA forum. I am not sure how to delete this post so if someone could enlighten me on how to delete the post that would be greatly appreciated!

+ Reply to Thread

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