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!
