Macro to copy down columns of data

Hi,

I have a work sheet with data in the first 6 columns and I believe the data has a one to many relationship, in that the first four columns i.e. ‘A’ to ‘D’ are only populated once with the remaining two fields ‘E’ and ‘F’ populated down with the Work Order & Comments data until the next record is found.

What I would like is the macro code to copy and populate the data in the first four columns down ‘A’ to ‘D’ to the next row with data in i.e. in columns ‘A’ to ‘F’.

Any assistance in this matter would be greatly appreciated.

Many thanks in advance.


Rob

N.B. excel version 2010