Tab 1 = Stock Received Into Business
Tab 2 = Stock distributed to Employees in the business
Tab 3 = Inventory Stock
In Tab 3 I have a table, and want to be able to pull in C4 Qty of 'Womens T Shirt' IN 'Karratha Branch'.
This needs to add all the stock registered into Karratha in Tab 1, and deduct all the Stock distributed in Tab 2
Please help
Last edited by samwignall; 03-10-2021 at 04:03 AM.
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.
Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).
Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Mmmm. Not too bad a title, but at least you made the effort!!
"Sum of stock flow in and out" would have been better...
=SUMIFS(Table1[[Quantity]:[Quantity]],Table1[[Item Name]:[Item Name]],$B4,Table1[[Shipped To]:[Shipped To]],C$3)-SUMIFS(Table13[[Quantity]:[Quantity]],Table13[[Item Name]:[Item Name]],$B4,Table13[[Store]:[Store]],C$3)
copied across and down.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Hi Glenn,
Thank you for helping with the formula, I would never have come to that!
I noticed 'Perth' doesnt have any values, however it does have stock assigned in and out... I'm not sure how to fix it?
Thank you in advance
Sam
It's the usual problem... the extra space. On Stock In and Stock Out, Perth is incorrectly spelled as "Perth ". Filter both sheets by Perth, remove the space and it's all looking fine.
You're welcome.
It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.
Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks