Macro help required

Closed
Report
Posts
1
Registration date
Wednesday September 30, 2015
Status
Member
Last seen
September 30, 2015
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
for first set of data, hard code 1
then create a loop to copy the data as many times as you want