split cell contents into rows, and copy adjacent cells down

[FDibbins]

I have a file (from my MiL) that has tickets people have bought, along with some of their details. Problem is, when someone has bought more than 1 ticket, all the numbers were entered into 1 cell...

	A	B	C	D	E	F	G	H	I
1	Gift Reference	Name	Last Name	First Name	Preferred County	Preferred Address Line 1	Preferred City_ State	Preferred ZIP	Gift Amount
2	4	Janie P. C
3	005, 006, 007, 008	Kellie M.
4	12	Tina LaRoc
5	015, 445	Gretchen Y
6	16	Diane M. P
7	17	Raymond M.
8	18	David J. D
9	19	Daniel B.
10	21	Linda Schr
11	23	David Jing
12	024, 955	Debra Dell
13	28	William E.
14	29	Robert Gri
15	31	Scott Crof
16	32	Kate Kilco
17	34	Mark Wohle
18	035, 130, 314	Edward Min
19	36	Robert J.
20	37	Donald Dev

What she needs is to have - where applicable - each number broken out into it's own row, along with all the rest of the pertinent data, something like this...

	A	B	C	D	E	F	G	H	I
1	Gift Reference	Name	Last Name	First Name	Preferred County	Preferred Address Line 1	Preferred City_ State	Preferred ZIP	Gift Amount
2	4	Janie P. C
3	5	Kellie M.
4	6	Kellie M.
5	7	Kellie M.
6	8	Kellie M.
7	12	Tina LaRoc
8	15	Gretchen Y
9	445	Gretchen Y
10	16	Diane M. P
11	17	Raymond M.

I guess I could probably work out some formula with helpers and stuff, but this is more suited to VBA.

Any takers?

Dummy file available, if needed, but I figured this would show what I need. There are almost 1 000 rows of this (there were 1000 tickets), and I *think* the tecket numbers need to be 3 digits...001, 002 etc

[millz]

Try running this:

Please Login or Register  to view this content.

[FDibbins]

That looks like it does exactly what she needs, thank you (scored some brownie points with MiL and wife)

[cytop]

Beaten to the draw... a sllghtly shorter procedure, but uses/modifies the source sheet which, in hindsight, is probably not the best option.

Please Login or Register  to view this content.

(but I didn't notice 'The tickets need to be '000' so it needs a format on Col A)

[AB33]

Manged with firefox. There is a button on sheet1.

[alansidman]

Ford, here is another. I'm a little slower than the others

Please Login or Register  to view this content.

[FDibbins]

Thanks guys