Hi There,

Looking for a macro to do the below. Much appreciated.

Sheet1:
ColA ,ColB , ColC,ColD ,ColE
Row1: Name , Address, ID , Company, <Blanks>
Row2: aaaaa , bbbbbbb,111 ,ccccc , <Blanks>
Row3: ddddd , eeeeeee, 333, fffff , <Blanks>

Sheet2:
ColA
Row1 Name
Row2 ID
Row3 Company

Once we run the macro, the results in Sheet1 should be below.
ColA , ColB , ColC , ColD, ColE
Row1: Name , Address, ID, Company , Name-ID-Company
Row2: aaaaa , bbbbbbb,111 ,ccccc ,aaaaa-111-ccccc
Row3: ddddd , eeeeeee, 333, fffff , ddddd-333-fffff