theloveofwisdom
New Member
- Joined
- Nov 20, 2015
- Messages
- 10
Please help me write a vba that can create the data in the second column. Any help will be appreciated. There will be a large amount of tickets, and each individual may purchase as many tickets as they like... probably no more than a few hounded.
[TABLE="width: 247"]
<tbody>[TR]
[TD]# of tickets[/TD]
[TD]ticket #[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1,2;3;4[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]5;6;7[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]8;9[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]10;11;12;13;14;15[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]17;18;19[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 247"]
<tbody>[TR]
[TD]# of tickets[/TD]
[TD]ticket #[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1,2;3;4[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]5;6;7[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]8;9[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]10;11;12;13;14;15[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]17;18;19[/TD]
[/TR]
</tbody>[/TABLE]