RahulA1
04-05-2018, 01:56 PM
Hi Members
I am stuck at a situation. I have a excel sheet with two columns. Column A has Departments and Column B has corresponding "employees". This sheet is named as IN sheet in all the excel files. There are only 2-3 departments but for each department there are multiple Employee names. I am writing a code and I need help with looking for a sheet named "IN" or "IN*" in the given workbook and look for column Department and print the unique values in these departments and the corresponding number of entries in Employee Column.
Sheet format with two columns
DEPT EMPLOYEES
ZZZ ABC
ZZZ ASD
ZZZ BVC
YYY XYZ
YYY AAA
YYY XCV
YYY XRT
Result Expected: (any Cell is OK)
ZZZ 3
YYY 4
Any help will be of great help. Thanks
I am stuck at a situation. I have a excel sheet with two columns. Column A has Departments and Column B has corresponding "employees". This sheet is named as IN sheet in all the excel files. There are only 2-3 departments but for each department there are multiple Employee names. I am writing a code and I need help with looking for a sheet named "IN" or "IN*" in the given workbook and look for column Department and print the unique values in these departments and the corresponding number of entries in Employee Column.
Sheet format with two columns
DEPT EMPLOYEES
ZZZ ABC
ZZZ ASD
ZZZ BVC
YYY XYZ
YYY AAA
YYY XCV
YYY XRT
Result Expected: (any Cell is OK)
ZZZ 3
YYY 4
Any help will be of great help. Thanks