Can anyone teach me how to autofill the "Selling At" column
E and "SC Used Per Transaction" when I key in the "Denomination Sold" Column?
So for example, when I key in "3688" under the "Denomination Sold", "2470" will appear under "SC Used Per Transaction" and the number "$65" will automatically appear under the "Selling At" Cell
Another example if the above is unclear:
When I key in "86" at Cell
A14, "62.5" will appear on Cell
B14 and "$1.90" will appear at Cell
I need it for every number from Cells
H10:H31 to match the Cells
J10:J31 and Cells
I do not need the "SC Cost" to autofill as it will change frequently and I am going to key that in myself.
Could anyone kindly please guide me through this?
If you do not understand my question, please fill free to ask.