Search columns of worksheets, if the columns contain data, then form a list on another wor

I have a workbook that has worksheeets for every day of the month. The data in the worksheet consists of columns (employee #, name, clock in/out times, and break penalty). What I am trying to do is create another worksheet that searches all the other worksheets for a "yes" in the "break penalty" column and then create a list of all the employees that received a break penalty for the entire month. I would like this to be able to auto populate throughout the month as data is entered and not have to use a filter every time I want to compile this list.

Any help will be much appreciated, as I have been struggling with this for some time now.

Hi

Exactly which column has the break penalty?

rylo

Column K has the break penalty.
A=Employee Number
B=Employee Name
C=Time Clocked "In"
D=Time Clocked "Out"
E=Hours Worked (D-E)
F=Time Clocked "In"
G=Time Clocked "Out"
H=Hours Worked (G-F)
I=Length of Break (F-D)
J=Total Hours Worked (E+H)
K=Break Penalty (Cell is either blank, or contains "yes")

Hi

Ok, Create a sheet in the workbook that is called summary, and make sure it is the first sheet in the workbook.

Right click on the sheet tab and insert the code

Please Login or Register  to view this content.

This way, whenever you select the summary sheet, it will process all the following sheets, and add a unique entry for any relevant ID.

HTH

rylo