Hello Excel experts, please there is one pressing issue which i have with my excel. attached is the excel file.
If on the 1st of Jan. 2019 I received 1 in qty column of RECEIPT sheet, and on 1st of Jan. 2019 I issued out 1 on the qty column of the ISSUED sheet, I should have a balance of 0 for 1st of January 2019 on the Balance column of the RECEIPT sheet. If i did not issue out anything on 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
Hi Vic,
There is no file attached, try attaching again (press the orange button to start upload, after you add files).
Can you choose a relevant text for topic title? You have started 2 topics and they both have "Please Help!!". The title should contain a short description of the problem, this will help other users searching for solutions. Thanks for understanding.
Hi Chandra
You should create a new topic to ask your own question.
From your attachment I can't see a difference between the two sheets.
What is it that you are trying to achieve?
Sunny
