Create Macro, Userform or a searchbox to search data from table in excel in diff sheets

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

If Possible can u provide example sheet by attachment.

Thanks - MNR.

yeah sure how can I attach an excel file here? there is option only for images to upload!

go to Managed Attachement in down to current page then fallow the steps ok

Thanks I'll try it now

or else goto Go Advanced option down this reply box

That link i think of ur local desktop right tht will not work

Here's an example of a table in a sheet and i want to have a macro or userform to search from this table or a search box in different sheet! thanks

Particular Country name data u need in different sheets right in that same workbook right.

basically yes, for example if i search for the country all the info regarding the country name would be appear in a table same as if you search for an item or a year

Hi Hanif,

please have a look this attached file and let me know is it meet ur requirement or not .

Thanks - Naveed.

Why not just use auto-filter? seems much more simple

because with auto filter i can only filter data from active sheet and also i need a search box to have option to search with different with different categories

Can't you put all your data on one sheet? It makes things much easier

unfortunately they have to seperated

Well why not copy them to one tab for searching? Will make it much easier, it's fairly easy to loop through all your sheets and append the data in each sheet to the bottom of another

Hi Hanif,

Thanks if u satisfied with the solution then don't forget to mark this Thread as SOLVED.

Goto 1st Post - Goto Thread Tool - then Select Mark this thread as sloved.

to know how i prepared then open the script page make the window short and press F8 slowly then u will come to know how that code was working.

and one more thing Hanif see how much knowledge i have in excel, macro from that level i was prepared for u and SIR have more and more experience than me if possible follow his steps might b u will get better solution than me. try it.

Thanks - Naveed.

Thank mate,

Yeah sure I will. I really appreciate your help!

Thanks again - Hanif

Hi Guys !

I have a similar macro to set up like Hanif.

My sheet is kind of a data base with all research & references documents (with hyperlinks to them). Table has 7 columns (B:H).
I need the macros:

1. Adding a new row to the table (just under the heading i.e. 'reports') but the new row can be added under different section (report, article, video, presentation, other). I managed done only report part and I stuck.

2. Search box to search through the all table - After type i.e. 'parental influence' I want every row where that text appeared will be copied to the 'results' sheet and copied rows will keep the same format. Also I want a msg box to inform users "go to 'Results' sheet to look at your outcomes".

Apologies if my explanation isn't clear. Hope my attachment explains everything!

Many thanks!
Magda