A little more info:
I have multiple worksheets and one master list containing 6 columns: First,
Last, Birthday,Phone, and Address, and class. In the class column is a
variety of class names. I would like to write a macro (I have never done
this before!) ,if possible, that will allow me to automatically search for
all of one particular kind of class and then copy columns first, last,
birthday, phone, and address to another sheet in the same workbook to creat a
seperate class list without having to copy and paste. I have 200 names that
need to be seperated out into 17 different class lists. Can anyone help??????

"cdcam" wrote:

I have a worksheet containing names and address that are repeated onto other
sheets based on criteria in another column. What formula if any can I use to
determine if that person meets that certain criteria to automatically copy
the 3 columns that the name, phone, and address are located in to another
sheet?