need help with macro in excel

[InnaG]

Hello,
I need help with following question:

On my spreadsheet I have the first three following columns: Record number, excluded and Name. In the NAME column there are two blocks of data that are split up by one blank row and the next one after blank has either word "Facility" or "professional". I need to find those cells and if they are found put "Z" in the corresponding cell in the column "B" which is called "excluded".

Records that will be marked as "Z" in column B need to be excluded from the data analysis.

Any help will be greatly appreciated,

 

[Jeffrey Mahoney]

How about a formula in the Exclude colum?
=IF(IFERROR(SEARCH("professional",C2),0)+IFERROR(SEARCH("facility",C2),0)>0,"Z","")

 

[InnaG]

How about a formula in the Exclude colum?
=IF(IFERROR(SEARCH("professional",C2),0)+IFERROR(SEARCH("facility",C2),0)>0,"Z","")

Hello,
That is a great idea. I am pretty new to the VBA still learning as I go. How can I put it in VBA?
Thank you

 

[Joe4]

Jeff's reply is not a VBA solution, it is a formula one. So you would just put that on row 2 and copy down for all rows.

If you need to add this to VBA code, you can turn on the Macro Recorder as you add this formula to your sheet to get the VBA code you need to add this formula.