Copy a cell based another result [Closed]

Hi, I need some help here....

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.

Any help would be greate

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!