Macro to copy and paste value every nth row

Hi all,

I need to copy cell value in D:1 onto a range of cell (O:3 to O:31) and from D:34 onto (O36: to O66) and so on... i.e. every 33 rows

I have a few hundred of these excel files to grapple with so it's really not an option to do it manually. Also each excel file has different size, e.g. some starts from 1960 and ends at 1981 while some starts from 1965 and ends at 1971.

I would really appreciate it if someone can suggest a macro that will do the job. Many thanks!


JA