explore the land owner

[sanju2323]

I am trying to find the land owner's information in kalus village. But the result is not right.
Land Owner - "Hon.Collector & Dy. Director Rehabilitation (Land) Pune" in this serial number 1,21,43,46,71,76.
Please correct the code or give me new code.


Thanks a lot


Sorry for my bad english

[mdmackillop]

Some issues with the layout.
You cannot filter simply with this and see the data in the other columns.

G11 & G12 both contain data. I assume G12 relates to the owner. Does G11 relate to the Owner or to the Land? If to the land, how should the result show?
Is 15 the only column which contains information relating to the owner? It looks like 14 would also. Any others? If theses are identified, the list order could be changed showing the Search identity first in each section and then a filter could be used. Would this be an acceptable method? If not, the results could be copied and pasted below this table or to another sheet. Preference?
To what do B21,B57 relate? Specific owners?

Please post the result you would hope to see after code is run for this specific owner.

[p45cal]

Cross-posted, and apparently solved at https://chandoo.org/forum/threads/find-the-detail-from-external-file.34117/#post-203227
and posted here too:
https://www.excelforum.com/excel-programming-vba-macros/1182772-search-detail-from-external-file.html

groan.

[mdmackillop]

@ p45cal
Thanks, Glad I didn't waste too much time on this; and the poster can't be bothered to respond or say he has a solution
Regards
MD