I am trying to create a directory database for a church to help group people by certain criteria. I'm struggling to figure out how to make an if statement that will say if column B equals this criteria (like a number 1 for group one), move the entire row to worksheet 1. I need to do it for 14 groups. Any ideas on how I could do this?? I have a feeling the answer is very basic and I'll feel dumb, but I'm asking anyways! :0)
Bookmarks