Copying info from row into the next four rows and then doing the same for remainder

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

I cannot post the exact workbook due to security restraints. I can put together a random workbook to give you an idea if necessary. I guess I wasn't too clear. Its basically one column that has information in a row that I want copied to the next 4 rows and then move through the workbook to row 6 and perform the copy of information from row 6 to rows 7,8,9, and 10 and so on until it reaches a blank cell.

Let me know if this is ok. Haven't uploaded here before.

thanks

Simple enough. Thank you!

One thing I noticed when I was running the macro on my workbook was that it wouldn't take into account an empty cell. It would continue to fill the all the cells with the same information until it saw something different. For instance from my "dummy" workbook say EX_COL_C was blank it would fill EX_COL_B all the way down until it 'sees' EX_COL_D. Is there a remedy for that?

New workbook example.

If it is like you mentioned in your first post, every 5 rows, try this

Please Login or Register  to view this content.

JieJenn.. If you notice on the workbook that the bottom is different because it is missing the EX_COL_C record. Whereas the first workbook that I posted had that record in there