I have a large spreadsheet full of data where the first line (and every 5th line after that) has information that I want to be copied into the next 4 rows and then moving onto the next record (which is on the 6th row) and so on until it reaches the end of the document. I was wondering if it was possible to complete this task using a macro?

Thanks