Hello,

I'm trying to create a userform, macro or a search box in a seperate sheet in excel to find a list of data in one or more table in excel sheets.

the table contains country, element, items and years so for example by searching a name of a country i want all information regarding that country to be shown same as items or year etc. i would really appreciate it if someone could tell me a code or function to do it in any 3 types of macro, userform or search box!

Thanks