Jun 01 2022 05:33 PM - edited Jun 01 2022 05:34 PM
I am creating a spreadsheet where I want to take the value of one cell and multiply it by whatever value I enter into the next cell, but I dont want to have three cells at the end of this process. Let me explain.
I dont want to take A2 and multiply by B2 and populate the answer in C2. I want to enter a value in B2 that B2 will automatically multiply by A2 and populate with the product (not the value I entered). Basically, I want to eliminate the need for an extra column. Is this possible? Will this require VBA? If so, how?
Thanks in advance!
Jun 02 2022 01:05 AM
I would not recommend that. It makes it impossible to correct mistakes. Using a third cell with a formula is much more reliable.