Do some Excel Work for Company to manage inventory -- 2
- Status: Closed
- Hadiah: $20
- Penyertaan diterima: 11
I am online retailer and I need macro in excel to manage inventory on hand. I need macro where I can enter the products I buy and then later decrease inventory when I sell these products. I want to keep a record some how to see that when the inventory is updated(added/subtracted). Currently, I can track when a product is updated. I would like to see a pivot showing me " most items sold" today or week etc. I have attached sample file which contains product id and then sizes.