Copy two column and paste into another ws, with data filtered out

You should define:
.- the first and last row in " DeptXref " column A
.- the next row in ws "Table Build"
then Loop from first to last row
.- In each step compare: If A(i) ="Direction" cell B4 and B(i) is numeric and has 4 digits
.- and paste in the next row

So a code could be something like:

Please Login or Register  to view this content.