Macro: Hide Row If Two Cells Dont Start The Same

So I'm looking to market to a list of people local for my families new ice cream shop! I have a list of people and want to know which address to mail to. On the list I'd like to hide all rows where the cell in H does NOT equal the cell in E. The list I have sometimes has the same address but witten differently as seen in E4 and H4; AVENUE and AVE. I figured the easiest way to circumvent this is to compare the first few characters of both cells being compared and hide if they dont start the same. If theres another way such as compare entire cell in E and if H contains the same then hide it. Any suggestions would be greatly appreciated. I found a similar code I didnt modifty yet which might help:

Please Login or Register  to view this content.

I know it is comparing just cell E1 so I dont know how to modify to cycle through all cells for the comparison in E and H. FYI I'd like to use this macro again in the future and I'm assuming the list size will change from list to list.

PCI Both of those solutions look to work out perfectly! I have one last question then I'll mark as solved. Do you know how I could quickly unhide all? I tried clicking all rows, right-click unhide and it didnt work. I also tried clicking a section and went to Format>Hide & Unhide> Unhide Rows and nothing happened. I set a section of hidden cells height to 15 as well and nothing. THe only way it seems like I'd be able to unhide at this moment is to double click inbetween each cell this is hidden. Its not a big deal but it's always nice to doulbe check the formula is hiding the proper rows.

Nevermind, it was that the filter was messing it up. Man that was annoying but I got it!