VBA Find Text and Add Blank Column

[unknownymous]

Hello Gurus,

Hope all is well.

Could you possibly help be on how to code this?

1. In Sheet1, I need to highlight in yellow the text containing "Target" in column AZ.
2. Separate the data with "Target" text by adding a blank column
3. Add message box noting how many "Target" text are there in the entire Sheet 1

Example output:

Header 1	Header 2	Header 3
001	Ann	NONE
002	Wil	-
EXCLUDED

003	Sean	Target
006	Carroll	Target

Any help will be much appreciated.

Thank you!