I have a spreadsheet with 5 columns of data. The problem I am having that
column E contain multiple values in a single row seperated by a comma.

01/09,03/10,22/10

How can I extract the data so I have one entry per value? Basically, copy
the values in the first 4 columns and have the 1st value from column E,
insert a new line copy the values in the first 4 columns and have the 2nd
value from column E, copy the values in the first 4 columns and have the 3rd
value from column E, and so on based on the number of values contained in
column E.

Thank you,

QB

To rephrase, just to be sure I understand, you have a number of rows like this:

A B C D E
Bob 45 Jan True Orange, Red
Jan 92 Oct True Yellow, Blue, Orange
Rick 12 May False Black

You want the macro to change it to this:

A B C D E
Bob 45 Jan True Orange
Bob 45 Jan True Red
Jan 92 Oct True Yellow
Jan 92 Oct True Blue
Jan 92 Oct True Orange
Rick 12 May False Black

....I see now you have strings representing dates in column E, not colors as
in my random example, but except for for that the above is the right idea,
correct?

If so, I take it you've started on writing the program and are having
trouble getting past some particular difficulty, right? What have you done
so far, and what problem are you having?

Alternatively, maybe you've never written a VBA program before and you're
not sure how to start. That's no crime, but in that case you don't need a
hint to get you past some particular problem, you need someone to do a little
hand-holding to get you started. If the latter, feel free to say so - I
don't mind helping - but you may prefer to contact me via email for a sort of
tutorial.

--- "Question Boy" wrote:
I have a spreadsheet with 5 columns of data. The problem I am having that
column E contain multiple values in a single row seperated by a comma.

01/09,03/10,22/10

How can I extract the data so I have one entry per value? Basically, copy
the values in the first 4 columns and have the 1st value from column E,
insert a new line copy the values in the first 4 columns and have the 2nd
value from column E, copy the values in the first 4 columns and have the 3rd
value from column E, and so on based on the number of values contained in
column E.