I have a worksheet that records a name and 18 scores for many golfers. I want
to create a list with names, that when you select a name it will copy and
paste the name and all 18 scores in a line. Can this be done? Any help
greatly appreciated.

Thanks
John