Search Data from one Workbook and copy it into another Workbook

G

Guest

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
 
R

robert111

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

splitting data from one column into two 2
How to copy a range of cells and paste into a new workbook in differentcolumns 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
update data from one workbook to another 4
Search and copy 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Copying data from one workbook to another dependent on user select 1
Copy data from one workbook to another? 1

Top