Hi All,

Could someone record a macro for the below formula :

=COUNTIF('Sheet1'!$A$1:$A$100,"*"&$D2&"*"&E$1&"*")

Thanks in advance ...