Macro to copy and paste value every nth row

[Closed]
Report
-
 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!


JA

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

https://support.microsoft.com/en-us/help/213438
10
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month