Am I able to automatically line up data

[tweacle]

What im trying to do is line up data.
I have the same heading at the start of every set of data which would be first of all in cells a1-e2 and g1-k2

What im trying to do is when the data thats shown in cells a1-e2 and g1-k2 re appear on next set of data I want them to line up together and start on the same row. The thing is that some of the data in columns a-e or g-k may be longer than the other column.


I was given some advise but dont know how it works or what to do with it

If Cells(Rows.Count,1).End(xlUp).Row >= Cells(Rows.Count,15).End(xlUp).Row Then
NextRow = Cells(Rows.Count,1).End(xlUp).Row + 1
Else
NextRow = Cells(Rows.Count,15).End(xlUp).Row + 1
End If I think the person told me that this works if theres no data underneath so something but these headings will go all the way down the workbook.

Can anyone help.

Thanks

 

[jindon]

Hi

I don't find any relation between your problem and the code posted.
Can you show us your data with before/after?