Log In
Register
Home
January 11, 2019
Offline
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
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Offline
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.
Active Member
January 14, 2019
Offline
VIP
Trusted Members
June 25, 2016
Offline
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
1 Guest(s)
