excel vba - Looping through one column in a table then sending the entire row to another table if it matches a certain criteria -

i have table runs columns aa although of columns have been hidden except a,b,c,t , aa.

it has autofilters , titles applied row 3 of each column. (title rows)

in column b, have bunch of strings, half of strings in uppercase , other half in propercase.

what want seperate rows in b column contains either propercase or uppercase value, doesn't matter way. what's important rows split in 2 seperate tables, preferably side side.

i don't need copy hidden values new table want steer clear of overwriting any, new table have start @ ab1.

i have make happen after auto filter applied if possible. (disregarding data has been auto filtered out.)

thanks,