IF statement to copy across and fill down selected Excel column values

Is there an easy way to copy down the highlighted yellow cells in Column D of embedded picture into Column E? I want to copy down the yellow highlighted cells until another yellow highlighted cell appears, then copy down that yellow cell, etc.

Data sample, including some of the output required, for test purposes:

    D           E            F
Row Labels                 Min of PRICE
283200-1005    283200-1005    325
COMPANY63      283200-1005    325
COMPANY60      283200-1005    1000
COMPANY59      283200-1005    2250
COMPANY35      283200-1005    2495
COMPANY4       283200-1005    2750
COMPANY11      283200-1005    3200
321-400-703-0  321-400-703-0  1000
COMPANY60      321-400-703-0  1000
COMPANY64      321-400-703-0  1145
COMPANY42      321-400-703-0  2800
COMPANY11      321-400-703-0  3275
4063-16082-3                  1000
COMPANY8                      1000
COMPANY24                     1800
COMPANY4                      2750
COMPANY11                     3200
COMPANY51                     3481
COMPANY14                     4350
Grand Total                   325