Do some Excel Work for Company to manage inventory -- 2
- Tình trạng: Closed
- Giải thưởng: $20
- Các bài thi đã nhận: 11
Tóm tắt cuộc thi
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.