Copy row IF column contains any number in list

[Militia]

Hello all - i hope the topic title makes sense.

I have a spreadsheet of data 40 columns wide (A:AN) and several thousand rows long.

I'd like to check the last ten columns (AE:AN) of the data.

If any number in the below list exists in any of the last 10 columns of a row, I want to copy it to a new sheet.

List of numbers: 43 45 54 55 58 81 84

Would this require code or does anyone know of a a built-in functionality that may help me to complete this task?

Thanks, Militia

[stanleydgromjr]

Militia,

You will need a macro.

It would help if you could post your workbook - scroll down and see "Manage Attachments".


Have a great day,
Stan