hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,223
- Office Version
- 2010
- Platform
- Windows
- Mobile
I have 2 workbooks WB1 & WB2 for input & output respectively & both kept opened.
WB1: Range: A1:E1085476
Sheet1
<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
<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
<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.
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.