Macro to copy and paste value every nth row

 pc -
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!


1 reply

this might be a start to solving your problem. This macro will highlight the data that you need so that you can extract it. don't have advice on the rest of the problem