Hi there,

I have this code that's corresponding to a table that pulls the total amount but I'd like to know if there is a way to also make an additional table that you can "edit" or press a button/search bar to look for a person's name/employee # and it pulls just their data? My goal of this table is to show the overtime Month over Month differences for both individual and whole.

Code:
=SUMIFS(Table1[OT Prem],Table1[EoM],">="&EOMONTH(J5,-1)+1,Table1[EoM],"<="&J5)
This is pulling the correct info, it's taking the End of Month formula that's within this table of data and sums up all of the overtime amount from another table. I just don't know how to go about getting the individual's overtime in another table or possible other column of this table? I have about 40 people I need to add, individually and I can use either their names or their employee ID's to filter.

Thanks a lot.