Previous Topic Next Topic

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 4478 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 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

A required download missing
PRAMOD -
dwebb -

1 response
itunes 64 bit problem
amazingman849 -
DoucheLeRoux -

16 responses
Help! Volume does not contain a recognized fi
sabik13 -
jack4rall -

1 response
Code for macro that conditionally inserts rows
bfleming -
bfleming -

4 responses
Execute Macro On Calculated Cell change
Notar -
rizvisa1 -

5 responses