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
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