I need to copy Cell B2 & B3 to another work sheet if cell H2 = "text" and create a list.
What I have is a list of employee that work in different departments and I want to break down the department into work sheet tabs using a master list without having to re-type everyone.