how to find data from other worksheet and display on other worksheet.....

With defined name and datavalidation.

After that Vlookup.

See the attached file.

Another way to do this.

@sktneer

Please also add the solution in your answer, so people don't have to look in your file.

You used the code below, behind the button FIND.

Please Login or Register  to view this content.

CriteriaRange:=Range("G3:H4"), CopyToRange:=Range("J3:Q3"), Unique:=False
End Sub

Originally Posted by oeldere

@sktneer

Please also add the solution in your answer, so people don't have to look in your file.

You used the code below, behind the button FIND.

Please Login or Register  to view this content.

CriteriaRange:=Range("G3:H4"), CopyToRange:=Range("J3:Q3"), Unique:=False
End Sub

Thanks for reminding me. Its no doubt a good practice. But I used advanced data filter so I had nothing to mention it here. I hope you understand.

Please do not quote the whole answer.

If it is usefull, just use the part you're refering to.

You could have mentioned you used VBA in combination with advanced data filter.

1) This is usefull for the seekfunction in the forum.

2) It gives forummembers an idea of the solution.

Having said that, I don't mind, it was intented to be a TIP.

Use F1 (helpfunction) and look for Vlookup