+ Reply to Thread
Results 1 to 6 of 6

Import rows of data based on vlookup value

  1. #1
    Registered User
    Join Date
    03-03-2008
    Posts
    3

    Import rows of data based on vlookup value

    Hi there,

    I need assistance in regards to the following:

    I need to import rows from an existing worksheet to a new worksheet based on a list of names existing on a second worksheet. I know how to get the first row imported using a vlookup , but can someone tell me how to import the associating rows considering the name I used as reference for the first row does not exist in the associated rows.

    Please help me as I really need to solve this.

    I am not sure if this is a macros or a straight forward formula. My guess is this requires a macro.

  2. #2
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    The example below assumes all your data is on sheet1 (list of names in column A), your list to find and import is on sheet2 column A and that you want all the found results in sheet3.
    Please Login or Register  to view this content.
    hope this helps!
    Not all forums are the same - seek and you shall find

  3. #3
    Registered User
    Join Date
    03-03-2008
    Posts
    3

    Exclamation Need more help!!!

    Hi Simon,

    I am getting an error at the following line:

    Please Login or Register  to view this content.
    Any ideas why there would be an error there? I have made sure that the appropriate worksheets have been named correctly.

    Dimple
    Last edited by VBA Noob; 03-04-2008 at 05:54 PM.

  4. #4
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    Try swapping it for this!
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    03-03-2008
    Posts
    3

    More Help Needed

    Hi Simon,

    Can I please send (email) you the file so you can help me better with the macro?

    Dimple

  6. #6
    Forum Expert Simon Lloyd's Avatar
    Join Date
    03-02-2004
    Location
    locked in the cage
    MS-Off Ver
    All the ones my homepage shows
    Posts
    3,161
    PM sent, solution will be posted here for the benefit of others!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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