anglais428
Well-known Member
- Joined
- Nov 23, 2009
- Messages
- 634
- Office Version
- 2016
- Platform
- Windows
Hi Guys,
I am looking at taking the following:
<tbody>
</tbody>
and replicating it (full rows) by 'X' times. I would like a Message Box to ask for the number of times it should be replicated.
If the user was to enter '2' then, on the same Sheet, it should look like:
<tbody>
</tbody>
i.e. the original plus the 2 duplicates.
Ideally, I would like this to be a VBA solution as the number of rows is very large.
Thanks,
I am looking at taking the following:
A | 100 |
B | 500 |
C | 250 |
<tbody>
</tbody>
and replicating it (full rows) by 'X' times. I would like a Message Box to ask for the number of times it should be replicated.
If the user was to enter '2' then, on the same Sheet, it should look like:
A | 100 |
B | 500 |
C | 250 |
A | 100 |
B | 500 |
C | 250 |
A | 100 |
B | 500 |
C | 250 |
<tbody>
</tbody>
i.e. the original plus the 2 duplicates.
Ideally, I would like this to be a VBA solution as the number of rows is very large.
Thanks,