Dave,

You seem to be the Excel VBA guru.
I posted another VBA question, and was wondering if you could take a look?

Here's the link:

http://groups.google.com/group/micro...cd38be98?hl=en

Thanks,
Brian

"Brian" wrote in message
...
Howdy all,

I have employee records with corresponding image files list all in Column
A. Each employee record is proceeded by the word BEGIN:, then SSN, NAME,
DOB, and then a varying number of image file paths. There are thousands of
these, and I want to format them like I've shown below.

Is this possible?

Here is what I have:

A
1 BEGIN:
2 SSN: 111-22-3333
3 NAME: Joe Blow
4 DOB: 01/01/60
5 \v\wst1.jpg
6 \v\wst2.jpg
7 \v\wst3.jpg
8 BEGIN:
9 SSN: 222-33-4444
10 NAME: Henry Ford
11 DOB 02/02/70
12 \v\qwe1.jpg
13 \v\qwe2.jpg
etc, etc.

What I want:

A B C D
1 SSN: 111-22-3333 NAME: Joe Blow DOB: 01/01/60 \v\wst1.jpg
2 SSN: 111-22-3333 NAME: Joe Blow DOB: 01/01/60 \v\wst2.jpg
3 SSN: 111-22-3333 NAME: Joe Blow DOB: 01/01/60 \v\wst3.jpg
4 SSN: 222-33-4444 NAME: Henry Ford DOB 02/02/70 \v\qwe1.jpg
4 SSN: 222-33-4444 NAME: Henry Ford DOB 02/02/70 \v\qwe2.jpg



Thanks,
Brian