Consulting

Results 1 to 3 of 3

Thread: Custom data transfer based on criteria

  1. #1

    Custom data transfer based on criteria

    Hi All,
    I have yet another tough situation on hand.. I have an excel workbook, with names on one work sheet. I have the same names or more on the next with additional information like age, class and so on. I'm in need to create a new workbook, such that if the name is present in the first sheet and the same is available in the second as well, then I will need the entire row copied and pasted in a new workbook. This will need to happen
    for all the names in the first sheet. I have huge records to take care off. Currently I do this manually and its tiring. Please help guys.. Looking forward to your help and much appreciated. I've attached a sample workbook,that might be of help. If you can help me with a sample workbook with the solution it would be of great help and help me learn as well.

    Thanks,
    Richard Smith

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Examples?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    My Apologies xld.. i forgot to attached the excel

Posting Permissions

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