Hi,
I need help to determine how to use formula.
Attached is my excel example file, I am doing inventory, where I need to be able to know the total amount items on hand and on project.
I need to be able to know how many inventory on hand and on project which depends on the item that is check-out and check-in, when the items havent check-in it means it still on the project?
So can you help with that?
I really appreciate it.
Last edited by thyzt; 06-23-2016 at 02:20 PM.
Thanks for the title change
Last edited by FDibbins; 06-23-2016 at 11:36 PM.
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
Looking at your file, you have 2 sheets with data that does not match from 1 sheet to the other??
What defines On Hand and/or On Project?
You have bar codes on Equip sheet that appear nowhere on Sheet4?
You also would probably be better off having this whole table going down only, instead of down and across - have repeat rows for Job ID with each Equip name on it's own row
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks