Excel macro to search data between two sheets

[kamalthakur]

Hi Everybody.

I have an excel sheet which has two tabs one tab represents Database and other tab represents Search.

In Search spreadsheet i have placed country and supplier in two cells and below are the heading.

Could someone please help me out with a macro.

For example if we input the country name in search spreadsheet it sshould show me all the details below in search sheet for that Country

Second condition is if we input country name and supplier name in search spreadsheet it should populate the details for that supplier

Condition is if country name is not found in database there should be prompt mentioning Country not Found and
the second condition would be if country name is found and supplier is not found then it should prompt supplier not found.

[royUK]

You can use AdvancedFilter to do this although the results will be saved to the same sheet.

[kamalthakur]

Hi

Thank you for the response but i want to create a database for which it becomes very tough job for me to use autofilter option everytime.