Hi

=B5*$A$1

Absolute the A1 cell in the formula then copy down.


rylo