Information to copy are from sheet2.
It works like an index match but I want to try an alternative method.
lastrow = sheets("sheet2").Cells(Rows.Count, 1).End(xlUp).row
lastcolumn = sheets("sheet2").Cells(1, Columns.Count).End(xlToLeft).Column
For Each Headers1 In sheets("sheet1").Range("a1", "h1")
For Each Headers2 In sheets("sheet2").Cells(1, lastcolumn)
If Headers1 = Headers2 Then
Headers2.Cells(headers2.row + 1, lastrow).Copy Destination:= sheets("sheet2").Cells(Headers1.row + 1, Headers.Column)
End If
Something like that but does not work as both headers1 and headers2 never seem to match.
Bookmarks