Forming String from Selected Items

Thanks for these ideas, guys.

Bob

I have a listing of schools, some records selected with a "Y". When all of the desired schools have been selected, I want to run a macro that will scan through those cells and, for each one that is selected, put the school name into a string. I want that resultant string to be written to a cell.

Here's an example of the data:

Please Login or Register  to view this content.

The resultant string should then read "East, Northside, The Meadows"

TIA

Bob

You can use this function:

Please Login or Register  to view this content.

And this array-entered formula:

=Cat(IF(A1:A10="y", B1:B10, ""), ", ")