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.
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.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
Posting Permissions
Reply With Quote
