Search/match move to another sheet

Hi all,
Well I have attached Sample file .
in a sheet=Full, i have the data which i need to move some row to the other sheets, In this way:
1. IF column B (CardNum) value match the value in column C (PinNum) then move the row to Matchs Sheet .
2. IF Column B=Null move the row to Nulls Sheet.
3. After moving, go and count the row in Nulls/Full/Matchs sheets and put the totals in sheet totals in the cells B2:C4 relatively.
Thnx in regars.
Sample.xlsx
drtopservAsked:
Who is Participating?
 
James ElliottManaging DirectorCommented:
See if this is what you need.

Rgds

Jell
F--Sample-1----Solution.xlsm
0
 
drtopservAuthor Commented:
Perfecto:}}
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.