I could build a list(array?) of matches then go through and copy each match's stuff over. I could find matches and copy data into in Sheet2 as I go.
I could add rows between matching names until A matches A, then copy and paste the whole block of cells at once. I tried to figure out a way to code this that makes sense, but fell on my face because I cant figure out how to go about it without making it overly complicated. I used that pivot (copy/paste) to create the normal sheet I am copying into with this task. I tied to use a pivot table, but the pivot brought over 0s and 1s instead of the actual data in sheet1, though it did bring over the headings. I need to get 12 columns of data from the names in sheet 1 into the right rows of sheet 2.
Sheet 2 has the headings there in row 1, but the rest of the cells in those 12 columns have been left blank. The name list of sheet 1 is much shorter than the name list on sheet 2. Two sheets, both with names in 'last, first' descending in A.
