Starting with no formulae in the block E4:S15, you can put these formulae in the cells stated:
F4: =E$3*$B4
G4: =E$3*$C4
H4: =E$3*$D4
Then select the block F4:H4, click on <copy>, then click on G5 to move the cursor and CTRL-V to paste, then click on H6 and CTRL-V, then on I7 and CTRL-V, and so on down that diagonal to Q15, then press <Esc> at the end.
Hope this helps.
Pete
Bookmarks