I am trying to figure out how to multiply each individual cell in a range, which is in another worksheet (e73:n73 of the sheet "Report"), by the value in "C5" of the active sheet and the results will be shown again in the active sheet, in d20:n20, however, I havent succeeded in it yet.
Is there a way to do this in vba - as there are already data in the range d20:n20 and they are re-calculated when the cell value "c5" is changed?
thank you in advance,
Selc