ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   I need a macro to copy each of 2000 rows 12 times in same sheet (https://www.excelbanter.com/excel-programming/370037-i-need-macro-copy-each-2000-rows-12-times-same-sheet.html)

cyn

I need a macro to copy each of 2000 rows 12 times in same sheet
 
I have a spreadsheet with over 2000 rows (records). For each row, I want to
copy it's values 12 times. Does anyone know how to create a macro for this?

Mark

I need a macro to copy each of 2000 rows 12 times in same sheet
 

Cyn wrote:
I have a spreadsheet with over 2000 rows (records). For each row, I want to
copy it's values 12 times. Does anyone know how to create a macro for this?


I think your approach will vary depending on the size of your records
(A:?) and where you want to copy each one (12x) to. With that info I
will be able to help you.



All times are GMT +1. The time now is 06:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com