January 11, 2019
Hello Excel experts, please there is one pressing issue which i have with my excel. Attached is the file. Thanks
If on the 1st of Jan. 2019 I received 1 non of Laptop in qty column of RECEIPT sheet, and on 1st of Jan. 2019 I issued out 1 laptop in the qty column of the ISSUED sheet, I should have a balance of 0 for 1st of January 2019 in the Balance column of the RECEIPT sheet. If i did not issue out anything in the ISSUED sheet for 1st of January 2019, i should have Balance of 1 in the Balance column of the RECEIPT sheet. So my balances on the RECEIPT sheet should sync properly with the date of receipt and issued.
December 7, 2016
I would really suggest you to reconsider your design, why have two identical worksheets when you can have one?
For more guidance in how to set up your data in more effecient way you should read this blog post about tabular data format.