rajamsc2003
New Member
- Joined
- Jan 10, 2015
- Messages
- 8
I am having several excel Master1.xls, Master2.xls with content as below
[TABLE="width: 378"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]S. No.
[/TD]
[TD]Solution ID[/TD]
[TD]Employee ID[/TD]
[TD]Categroy
[/TD]
[TD] Date
[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD]13279-5-48P[/TD]
[TD="align: right"]201962
[/TD]
[TD]Complex
[/TD]
[TD="align: right"]2-Jan
[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"]2[/TD]
[TD]13279-5-32P[/TD]
[TD="align: right"]201966[/TD]
[TD] Complex
[/TD]
[TD="align: right"]2-Jan[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"]3[/TD]
[TD]13344-13-1TF
[/TD]
[TD="align: right"]300780[/TD]
[TD] Simple
[/TD]
[TD="align: right"]2-Jan
[/TD]
[/TR]
</tbody>[/TABLE]
Wish to consolidate all the counts in 30 Workbooks based on Employee ID. Please help me. All the excels having Master1.xlsx,......Master30.xlsx. with same column header. The variable is employee number.
[TABLE="width: 378"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]S. No.
[/TD]
[TD]Solution ID[/TD]
[TD]Employee ID[/TD]
[TD]Categroy
[/TD]
[TD] Date
[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"]1[/TD]
[TD]13279-5-48P[/TD]
[TD="align: right"]201962
[/TD]
[TD]Complex
[/TD]
[TD="align: right"]2-Jan
[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"]2[/TD]
[TD]13279-5-32P[/TD]
[TD="align: right"]201966[/TD]
[TD] Complex
[/TD]
[TD="align: right"]2-Jan[/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"]3[/TD]
[TD]13344-13-1TF
[/TD]
[TD="align: right"]300780[/TD]
[TD] Simple
[/TD]
[TD="align: right"]2-Jan
[/TD]
[/TR]
</tbody>[/TABLE]
Wish to consolidate all the counts in 30 Workbooks based on Employee ID. Please help me. All the excels having Master1.xlsx,......Master30.xlsx. with same column header. The variable is employee number.