oskar
New member
- Joined
- May 10, 2013
- Messages
- 24
- Reaction score
- 0
- Points
- 0
- Location
- Montreal, Canada
- Excel Version(s)
- Office 2013
I want to populate column E (Answer) with the results of multiplying column C (Factor) by column D (Input), rows 5-16, as per attached file.
Column D now shows a 10 at row 8 so the 10 should be multiplied by each factor of column C and the answers should be shown in column E. Then when I input another number anywhere in column D that number should again be multiplied by each factor from column C. There is no need to save the results in column E
The formula shown on the same sheet which for some unexplained reason when I write it on the VB Editor does not stay there after I exit the file although I save it. This formula I found it on the web but it does not work, perhaps I’m missing something?
Thank you
Column D now shows a 10 at row 8 so the 10 should be multiplied by each factor of column C and the answers should be shown in column E. Then when I input another number anywhere in column D that number should again be multiplied by each factor from column C. There is no need to save the results in column E
The formula shown on the same sheet which for some unexplained reason when I write it on the VB Editor does not stay there after I exit the file although I save it. This formula I found it on the web but it does not work, perhaps I’m missing something?
Thank you