Hello all, asking this one for a friend.

He has a sheet which has a list of products so that he can create an order for his shop.

it is literally just a column with a list of products and in the cells next to it space to put in the number of that item he wants ordered. What hes hoping for, is to be able to only pick out the items that are needed and put these items in to an order form which he has produced on a seperate sheet ie, list of 30 items, but a customer only wants 4 specific items, need those 4 items to appear on the order.

Sounds simple to me but i cant figure out how, if at all excel is able to do this.

Thanks in advance