I’ve got data records on one sheet (source) that includes a column of the names (of people) associated with each record.  In another column, I have a 1 in each record for those persons that have expressed a desire for being a volunteer.  I would like to find a way – using the criterion: a 1 in the ‘wanting to volunteer’ column – to copy the names from those records in the source sheet to a list (a column of cells) in a destination sheet, in the same workbook.  I’ve attempted to use the advanced filter option in the data tab, but either that’s not the right tack or I’m not setting it up right.  Any thoughts?

​  I’ve got data records on one sheet (source) that includes a column of the names (of people) associated with each record.  In another column, I have a 1 in each record for those persons that have expressed a desire for being a volunteer.  I would like to find a way – using the criterion: a 1 in the ‘wanting to volunteer’ column – to copy the names from those records in the source sheet to a list (a column of cells) in a destination sheet, in the same workbook.  I’ve attempted to use the advanced filter option in the data tab, but either that’s not the right tack or I’m not setting it up right.  Any thoughts?   Read More

​