Macro to repeat filling in certain blank cells

Hello,

I am trying to write a Macro that would do the following:

If in column E, there is the name "Smith" and in the same row in column B the cell is blank, I want it to pre-fill with "X123"

For many of these rows, column B is already filled correctly with "X123", correlating to the name "Smith" in column E, however, there a handful that are blank. I want a macro to repeat pre-filling these cells in column B, when they are found to be empty.

Hello,

Thanks for the response. I tested it, and when ran it just brings me to the end of the sheet.

Maybe:

Please Login or Register  to view this content.

I was reviewing it today, it actually has two parenthesis around the name. I made sure to copy and paste though everything perfectly, and put it in place of Smith, in the macro