vba required in the second workbook for getting data from first workbook

[hsandeep]

I have 2 workbooks WB1 & WB2 for input & output respectively & both kept opened.

WB1: Range: A1:E1085476


Sheet1

	A	B	C	D	E
1	Date	Name	N1	N2	N3
2	14-Sep-14	ABCD	128.25	138.55	140.29
3	14-Sep-14	ABMN	128.25	138.55	140.29
4	15-Sep-14	ABCD	128.25	138.55	140.29
5	15-Sep-14	ABMN	128.25	138.55	140.29
6	16-Sep-14	ABMN	128.25	138.55	140.29
7	16-Sep-14	XYZAD	128.25	138.55	140.29
8	17-Sep-14	XYZAD	128.25	138.55	140.29

<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 93px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
</tbody>

In WB2:
Output required as:

Sheet1

	A	B	C	D	E
1	Date	ABCD	N1	N2	N3
2	14-Sep-14	ABCD	128.25	138.55	140.29
3	15-Sep-14	ABCD	128.25	138.55	140.29

<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 93px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
</tbody>

Example 2:

Sheet1

	A	B	C	D	E
1	Date	ABMN	N1	N2	N3
2	14-Sep-14	ABMN	128.25	138.55	140.29
3	15-Sep-14	ABMN	128.25	138.55	140.29
4	16-Sep-14	ABMN	128.25	138.55	140.29

<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 93px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
</tbody>

In B2, I would be manually punching 1 name which is contained in B column of WB1. IF matched;
ANSWER: All related data (related to B2) should appear in A2:A1085476; C2:C1085476; D2:D1085476 & E2:E1085476

VBA required for this.
I am using Excel 2007.
Thanks for the help in advance.

 

[hsandeep]

Can someone have a look at my requirements & do the needful. Any clarity sought would be provided happily.