VBA to autofill columns

[Doctor_H]

Good morning guys,

I need help with a macro to autofill columns. In the attached sample, column A contains account numbers, column C:E contains other pertinent information that needs to be autofilled along the blank cells following the cell value. As an example, i need the contents of Cells A4, C4, D4, & E4 to copy all the way down to A15, C15, D15, & E15. The same process should repeat through the entire worksheet, which is over 200 pages long. Is this possible with a macro?

Thanks,

Doctor_H