Hello,
Attached is a excel file where sheet "Search" pull data from the another sheet "Data".
Depending on the selections of B2 - B10, or any combination of those, data from the "Data Sheet" will populate A29-J29 and on down.
Everything is working, except when B2 of the "Search" sheet is change to another Employee it doesn't work.
The following formula is found on K3 of the "Data" sheet:
=IF(AND(Search!$B$2="ALL",OR(Search!$B$3="All",B3=Search!$B$3),OR(Search!$B$4="ALL",G3=Search!$B$4),OR(Search!$B$5="ALL",H3=Search!$B$5),OR(Search!$B$6="ALL",I3=Search!$B$6),OR(Search!$B$7="",ISNUMBER(SEARCH(Search!$B$7,J3))),OR(IF(ISNUMBER(Search!$B$10),AND(C3>=TODAY()-Search!$B$10,C3<=TODAY()),AND(C3>=Search!$B$8,C3<=Search!$B$9)))),COUNT(K$2:K2)+1,"")
Basically B2 of the "Search" sheet only works when "ALL" is selected. When it is changed to another employee it no longer works.
Thank you for any help.
Nick
Bookmarks