EXCEL表单

Sheet A :
PO - ITEM - QTY -
001 - I100 - 10
001 - I100 - 5
002 - I100 - 4
002 - I100 - 6
003 - I100 - 15
003 - I100 - 20
003 - I100 - 5

Sheet B
PO :   002

PO - ITEM - QTY
002 - I100 - 4
002 - I100 - 6


请问点先可以做到SHEET B咁><"
输入002
出红色果D DATA~

THANKS~

[ 本帖最后由 rcc03461 於 2012-5-31 10:40 AM 编辑 ]

several options for your need, starting from the easiest,
1) Copy and paste
2) Simple Filter, then copy and paste
3) Advanced Filter, ref: http://www.contextures.com/xladvfilter01.html
4) by Formula, ref: http://stackoverflow.com/questio ... sed-on-another-list

Option 3 may be your best choice once you understand how it works.