: I have 2 sheets, where if I key  in any numbers  into a list  of the first
: sheet, the same numbers in the second sheet  will be highlighted and can
: be counted too column  wise.

What do you mean by "column wise"?

Are the numbers in the first sheet matching more than one cell on the
second sheet? (If it is a one-to-one match, then you only need to count
the list on the first sheet. No need for the second sheet.)