Thanks Luke for quick response. May be your formuls would be good if I have only address. But basically I am looking VBA code for copying row into different tab if one cell contains required string in group of strings. For example:
No Name Comments
1 Sachin hey buddy! Good work. Keep it.
2...
I need a macro to copy the rows from "Data" sheet to into different tabs based on string in group of strings in a particular cell. For example: in address column i have apt no street and city name is there...I want to copy the rows based on city name(mumbai)into different tab.
No Name Address...