testRow = Nametest.Range("B20:N29").End(xlUp).Offset(1, 0)
Tried wording it this way, it copied the correct data to the correct columns on the correct sheet. But it pastes it in the first available row, in this case the first row, instead of pasting it in the next available row between rows 20-29.