Hi need a code that is going to work like this:
1will be use in a cell as data input
2 will affect another cell right next to it
3 will go blank after data is entered

Ex.... the cell will be used to enter sold items, the number of sold items will be substracted from an existing inventory count right next to it, but then I need the cell where the sold items number was entered to go blank again.....

I hope you understand my explanation, and if somebody can help me I will really apretiate it, thank you very much for reading my request...