+ Reply to Thread
Results 1 to 2 of 2

Search Data from one Workbook and copy it into another Workbook

  1. #1
    Matz
    Guest

    Search Data from one Workbook and copy it into another Workbook

    Hi,
    I need to have a Procedure/Macro for searching data from one Workbook and
    copy these data into a new row in a List .

    I would like to search in Column A and get the Values from C and D for
    corresponding row.
    These Values should be inserted into a new Column in an existing
    Workbook/Sheet.
    For each request, the new column should contain actual date/time in first
    Column and than the values.

    Example Data source:
    A B C D
    1 Cat 23 White Africa
    2 Dog 234 Yellow Africa
    3 Bird 2345 Black Australia

    Example Data tarkget (searching for Dog):
    A B C
    1 2006-07-04 Yellow Africa
    2 2006-07-05 Yellow Africa
    3

    Is there any chance to get help??? I would really appreciate!!
    Matz

  2. #2
    Forum Contributor
    Join Date
    02-28-2006
    Posts
    690
    assuming date is in column A of sheet 1

    in B1 enter

    if(sheet2!A1="dog",vlookup(sheet2!A1,lookuptablename,3),"")

    same for C1 but change the 3 to a 4

+ 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