ktgoodlund
New Member
- Joined
- Jun 22, 2022
- Messages
- 1
- Office Version
- 2016
- Platform
- Windows
I need a VBA loop that will create the number of rows and repeat the text in column A, for example (animal in A, quantity of rows in B):
Cat 4
Dog 3
Horse 2
Desired result:
Cat
Cat
Cat
Cat
Dog
Dog
Dog
Horse
Horse
For possibly hundreds of lines.
Thanks!
Cat 4
Dog 3
Horse 2
Desired result:
Cat
Cat
Cat
Cat
Dog
Dog
Dog
Horse
Horse
For possibly hundreds of lines.
Thanks!