I have a few locations, eg. AMK, AMK MRT.
When i type AMK, both amk and amk mrt will appear, how do i filter to exact when i type amk, only amk will appear?
this is my code
Sub Advanced_Filtering()
Range("A8:H1611").AdvancedFilter _
Action:=xlFilterInPlace, _...