I have a sheet called Table. in that sheet i have 1 to x number of
columns (max thus far is 40 with column header of Col1, col2, and
etc...) under each column header has a list of names under it (total
number of names is 8) for each column.

What i am looking for is a macro to create a new sheet and call it
UseList. Based on the total number of columns Headers in the Table
sheet, List all unique names under one column and then tell me which
column Header it found that name in....

example:

Col1-------Col2----------Col3----------Col4--------Col5
James----Mark---------Edward------Tammy----Nicole
Mark------Nicole-------James--------George----Mike
Henry-----Chuck-------Loren---------James----Tammy
Edward---Henry-------Mark----------Loren------Chuck
Nicole----Tammy-----Henry---------Mark-------George
Mike------Edward-----George-------Nicole------Edward
Pat--------Victor--------Kevin---------Mike--------Mark
Victor-----James------Pat------------Victor-------Pat

New Sheet

Names-------Col1------Col2-------Col3-------Col4--------Col5
James-------Yes--------Yes-------Yes--------Yes--------
Mark---------Yes--------Yes-------Yes--------Yes--------Yes
Henry--------Yes-------- --------Yes------- --------
Edward-----Yes---------Yes------Yes-------- --------Yes
Nicole-------Yes---------Yes------ ---------Yes--------Yes
Mike---------Yes--------- ------- --------Yes--------Yes
Pat-----------Yes--------- -------Yes-------- --------Yes
Victor-------Yes---------Yes------ --------Yes--------


Any and all help in this matter is greatly appreciated...

Thanks