I believe the formulas I provided in post #2 provide the results you're looking for. I've applied them to the attachment in post #3 and they seem to fit what you're describing. Can you please look at the attachment and explain exactly what it is doing incorrectly?
If your problem has been solved, please use "Thread Tools" to mark the thread as "Solved".
If you're grateful for this site's existence and would like to contribute to the community, please consider posting something hilarious in our joke thread:
https://www.excelforum.com/the-water...ke-thread.html
For some reason I messed up with the formula, it dit work well, thank you so much.
One last question, is there any idea as to put an alert, highlight on red or do something in Column D from sheet2 when a requested quantity from sheet2 cannot be covered by sheet2 column D?
Attach in red what I am taking about.
Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks