Hi everyone. I have attached the file I am working on. If you could direct you attention to the June Inventory. There is a line that is for "Inventory Received". Also there is a line for "Setpoint Stock Number". When inventory comes in I put it in the "Inventory Received" Tab. I want to port the "Inventory Received" into the June Inventory "Inventory Received" line using the date range for June and "Setpoint Stock Number". I worked on some formulas that I thought would work but they don't.
Dave
I don't see anything called "Setpoint Stock Number". Maybe "Item ID"?
I was going to work on it, but it is password protected.
Recommend you use 'Evaluate Formula' to see where your problems lie. It will point out where you formula is having problems (like using an array for your >= compare and a cell with no value).
Last edited by Pauleyb; 07-01-2013 at 01:42 PM.
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks