Pulling certain groups to a second worksheet. Sorting by department to a second sheet.

[israelalvarado]

Hello there again guys!!


so, here is something, so I have a database with peoples names and with group numbers, i like to extract the names first and last name from group 1 to worksheet 1 and the first and last names from group 2 to worksheet number 2 and same with group 3,4,5.


so whatever group number i type in the mastersheet, i would like for the other worksheet to update. I did something like this, but it's not working...

=IF(Sheet2!C:C="1",A1&B1) what I want is if the column C has group 1 then add cell A1 and B2 ..... but it didn't work. haha,


thank you guys!!!