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
Date	Name	N1	N2	N3
ABCD
ABMN
ABCD
ABMN
ABMN
XYZAD
XYZAD

<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>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]14-Sep-14[/TD]

[TD="align: right"]128.25[/TD]
[TD="align: right"]138.55[/TD]
[TD="align: right"]140.29[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: right"]14-Sep-14[/TD]

[TD="align: right"]128.25[/TD]
[TD="align: right"]138.55[/TD]
[TD="align: right"]140.29[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: right"]15-Sep-14[/TD]

[TD="align: right"]128.25[/TD]
[TD="align: right"]138.55[/TD]
[TD="align: right"]140.29[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: right"]15-Sep-14[/TD]

[TD="align: right"]128.25[/TD]
[TD="align: right"]138.55[/TD]
[TD="align: right"]140.29[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: right"]16-Sep-14[/TD]

[TD="align: right"]128.25[/TD]
[TD="align: right"]138.55[/TD]
[TD="align: right"]140.29[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: right"]16-Sep-14[/TD]

[TD="align: right"]128.25[/TD]
[TD="align: right"]138.55[/TD]
[TD="align: right"]140.29[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]
[TD="align: right"]17-Sep-14[/TD]

[TD="align: right"]128.25[/TD]
[TD="align: right"]138.55[/TD]
[TD="align: right"]140.29[/TD]

</tbody>

In WB2:
Output required as:

Sheet1

	A	B	C	D	E
Date	N1	N2	N3
ABCD
ABCD

<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>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="bgcolor: #ffff00"]ABCD[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]14-Sep-14[/TD]

[TD="align: right"]128.25[/TD]
[TD="align: right"]138.55[/TD]
[TD="align: right"]140.29[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: right"]15-Sep-14[/TD]

[TD="align: right"]128.25[/TD]
[TD="align: right"]138.55[/TD]
[TD="align: right"]140.29[/TD]

</tbody>

Example 2:

Sheet1

	A	B	C	D	E
Date	N1	N2	N3
ABMN
ABMN
ABMN

<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>
[TD="bgcolor: #cacaca, align: center"]1[/TD]

[TD="bgcolor: #ffff00"]ABMN[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]14-Sep-14[/TD]

[TD="align: right"]128.25[/TD]
[TD="align: right"]138.55[/TD]
[TD="align: right"]140.29[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: right"]15-Sep-14[/TD]

[TD="align: right"]128.25[/TD]
[TD="align: right"]138.55[/TD]
[TD="align: right"]140.29[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: right"]16-Sep-14[/TD]

[TD="align: right"]128.25[/TD]
[TD="align: right"]138.55[/TD]
[TD="align: right"]140.29[/TD]

</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.