I'm trying to create a spreadsheet to keep track of my inventory.I am using Microsoft Excel for mac on 365Column I, I would like to add new stock in to add to Column K which I can do by a formula using column J
<tbody>
</tbody>Ideally, I want a macro button or something that then deletes I for when my next stock comes in but keeps the updated stock in column I hope this is understandable, if not I can add other info. This would be extremely helpful.
=I+J |