Filter out numbers with Macor - to use in several reports

I have over 1000 rows with numbers and would like to filter out and mark some of them (90) with a YES in the column beside them and NO for the other numbers.

I have all the numbers in column N (Called ITEM) in this report, but in a different report the info about ITEM can be in a different column, but the column is still called ITEM.

I would like to be able to run a Macro that marks the 90 numbers with a YES in the next column and the rest of the numbers with a NO
In my testsheet I have marked two numbers that are our CORE numbers, so I would like to create a Macro, that I can run if I need to mark the numbers with a YES or a NO depending on, they are on my CORE list or not.

I would like to be able to use this in different reports, that is why I can't mark them with a manual filter.
I am maybe not the best to explain but I hope someone understands what I mean. Thankful for all the help I can get to solve this.

Thank you so much Bernie

Is there a way I can put all the 90 items numbers direct in the macro, so I can save it in my personal macro and use it when I run the report and then I can send out the excel without the macro. I have some macro that I can run on my computer but I do not need to send it as a macro when I send out the report.

Thank you again. I manage to make it work.