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