Macro help required

Closed
jk_1 Posts 1 Registration date Wednesday September 30, 2015 Status Member Last seen September 30, 2015 - Sep 30, 2015 at 02:35 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 6, 2015 at 04:15 PM
Hi, If anyone can help me to create the excel macro on-

I have 12 rows data in excel with cell position A to BT. My requirement is- I want to copy this 12 rows data up to more 1 lakh time with a continuous serial number ( eg. from 1,2,3...). That means first 12 rows will be 1 and then 2nd 12 rows will be 2 and so on up to more than 1 lakh.


Thanks in advance for your help.

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Oct 6, 2015 at 04:15 PM
for first set of data, hard code 1
then create a loop to copy the data as many times as you want
0