Macro to copy and paste value every nth row
Closed
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
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
Related:
- Excel every nth row
- Saints row 2 cheats - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Gif in excel - Guide
- Kernel for excel - Download - Backup and recovery
- Number to words in excel - Guide
1 response
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
https://support.microsoft.com/en-us/help/213438
