I am having several excel Master1.xls, Master2.xls with content as below S. No. Solution ID Employee ID Categroy Date 1 13279-5-48P 201962 Complex 2-Jan 2 13279-5-32P 201966 Complex 2-Jan 3 13344-13-1TF 300780 Simple 2-Jan 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.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Consolidating Workbooks content in Sheet 1 to single sheet

Thread starter rajamsc2003
Start date Jan 10, 2015
Tags

consolidate workbooks

rajamsc2003

New Member

Jan 10, 2015

I am having several excel Master1.xls, Master2.xls with content as below


S. No.	Solution ID	Employee ID	Categroy	Date
1	13279-5-48P	201962	Complex	2-Jan
2	13279-5-32P	201966	Complex	2-Jan
3	13344-13-1TF	300780	Simple	2-Jan

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.