My spreadsheet has 4 columns as follows:
Is it possible to perhaps type in "1" into 3C and press enter, and make B3 automatically change into a "22", or type "3" into D4 and press enter, and make B4 automatically change into "51"? Any input would be much appreciated, thanks a lot!
Code:
1 | A | B | C | D
--------------------------------------------------------------------
2 | Item | Quantity | Add | Subtract
------------------------------------------------------------------
3 | X1 | 21 | |
-----------------------------------------------------------------
4 | Y2 | 54 | |
-----------------------------------------------------------------
5 | Z3 | 6 | |
Is it possible to perhaps type in "1" into 3C and press enter, and make B3 automatically change into a "22", or type "3" into D4 and press enter, and make B4 automatically change into "51"? Any input would be much appreciated, thanks a lot!