Thanks for your great help.

i have the sheet1
5 columns deptcode, userid, username, group, dept
how do caputre userid deptcode and dept vise in sheet2.
for example

deptcode userid username group dept
xxxyz mno xxxxx k2b KMM
xxxkz kpg yyyyy sb2 YMM
xkbzy ykg uuuuu ki1 KMM
xxxkz kty zzzzz kb3 YMM
xxxyz KPZ xxxxx k2b KMM




CRITERIA DEPTCODE, DEPT VISE
KMM
MNO
KPZ

YMM
kpg
kty