i am looking for some help on excel. finding it very difficult to find an answer
I have two sheets one with my order on
Order Sheet
Product code and Qty
　
and an allocation list
Allocation List
　
Once the Order form has been filled out. You will have what you rquirement is.
I want to create a button that let say on the order sheet there is
Product Qty
Cheese 10
Meat 20
and so on..........


It will search through column A in the allocation list that might have
Product code Use by Qty Location
Cheese 12/03/2011 2 2a1
Cheese 13/03/2011 4 1a1
Cheese 15/03/2011 10 5a1
Cheese 17/03/2011 5 4A1
Meat 16/03/2011 5 9a1
Meat 19/03/2011 12 6a1


Once it has found cheese it will copy that row to another sheet and if the qty copied does not exceed or equal the order value it will continue to search and copy untill it does = or exceed it will move to line two and start the same search on that code.
In some instances you will never get an exact match but the last pallet if it has a few more on it then the order value it can just be a bit of commonsence or highlight it.
Is this possible, i understand there will be a loop just need an example of it. This is a rough version of what i need as i am copying the row across to a pick list anyway.
My list will always be sorted by date to make sure stock rotation FIFO
Your help in this would be much appreciated


Your final List will be based on this Example
Cheese 12/03/2011 2 2a1
Cheese 13/03/2011 4 1a1
Cheese 15/03/2011 10 5a1 6 left over
Meat 16/03/2011 5 9a1
Meat 19/03/2011 12 6a1 6 left over