Compare one number with list of numbers

[inajica]

I have a workbook that contains 120 sheets. In column A, I have one number and in column b i have over fifty numbers. I need to go through each sheet and sum difference column A from column B. If the sum is greater than or equal to five, or less than or equal to five then the criteria is met. For the sheets that hs met that criteria, put the sheets name in another worksheets called "true."

Thank you

[mdmackillop]

I need to go through each sheet and sum difference column A from column B.
This needs clarification or preferably a sample worksheet.

If the sum is greater than or equal to five, or less than or equal to five then the criteria is met
In what circumstances is the criteria not met? This seems to cover all eventualities.

[inajica]

Thank you for responding to my problem. The above problem I was able to solve. But I need a code that will copy the last ten cells in column B, and paste it in cell g6--transpose. Thank you.

[mdmackillop]

I was confused before, now I'm totally lost.