How to get values between two difference dates of different sheets

General Excel Questions & Answers

Last Post by Anders Sehlstedt 6 years ago

2 Posts

2 Users

0 Reactions

37 Views

RSS

Vic Man

(@yemrovic)

Posts: 34

Eminent Member

Topic starter

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.

Thanks very much