Hey guys

My table goes like this:
A B C D E F ........
_________________________
1 | 1 Title 1
2 | 1 Subtitle a
3 | 1 Subtitle b
4 | 1 Subtitle c
5 | 1 Title 2
6 | 1 Subtitle d
7 | 1 Subtitle e
8 | 1 Title 2
9 | 1 Subtitle f

.... and so on.

What I want the macro to do is this; for each value "1" in column A,
copy the "Title n" in column E into column D in the following cells
(until next "1" in column A) where value "1" appears in column B. Get
it?

The result should be something like this:
A B C D E F ........
__________________________
1 | 1 Title 1
2 | 1 Title 1 Subtitle a
3 | 1 Title 1 Subtitle b
4 | 1 Title 1 Subtitle c
5 | 1 Title 2
6 | 1 Title 2 Subtitle d
7 | 1 Title 2 Subtitle e
8 | 1 Title 3
9 | 1 Title 3 Subtitle f
.... and so on.

Is there any kindly and helpful "EXCEL-alien" out in VBA-space that
will give me some help on this?

Regards
Snoopy