Macro help required

Closed
jk_1 Posts 1 Registration date Wednesday 30 September 2015 Status Member Last seen 30 September 2015 - 30 Sep 2015 à 02:35
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 6 Oct 2015 à 16:15
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 response

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