I originally posted for help but I think this may be an easier macro to create...
Starting at row 11 and continuing every 18 rows through row 7716:
Find and replace the following-
EMEDICARE****** TO ESUPMEDIC******
'!$AG$ TO '!$AN$
'!$Y$ TO '!$AO$
'!$AH$ TO '!$AP$
'!$Z$ TO '!$AQ$
Bookmarks