(Solved) – How do you match a name to values in multiple columns Excel VBA?

(solved)-–-how-do-you-match-a-name-to-values-in-multiple-columns-excel-vba?

How do you match the names to the event number if event numbers are in multiple columns on a separate sheet in excel VBA? I need the names of the athletes based on event number.

CLEANED INPUT FORMAT

enter image description here

Body Num,Preferred Name,Last Name, Gender, Age Group,Age,USA #, USA Club,LSC 5K Event, 5K Wave, 3K Event, 3K Wave, 1K Event, 1K Wave, 1/2K Event, 1/2K Wave,
all have separate columns

Desired output

enter image description here

Leave a Reply

Your email address will not be published. Required fields are marked *