I am trying to crate Inventory Excel for record stocks.

1, I found a problem that excel cant show different location when the location has same amount Qty.

2, how can i type the order number in B2 and excel auto show the items request by the order.

3, Can anyone help me to improve my excel design? since i am not good at database.

Thank you for your help.

:)
Sherlock