Searching Information From Database.

Hello,

I am seeking for VBA Macros where i can display an information from my other sheet. Something like using filter.

Her are the details what i am looking for.

i have a sheet named Database. When i start typing the work from any of the columns on the sheet it should display the results.

More details will be provided if someone willing to help me. Cannot attached the file it is giving error 132KB.

Can someone help me please and why i cannot attached file as an sample.

Here is the link for my file CLICK HERE

I need to search the typed value in all the columns and display the result below in sheet search from Data sheet.

I have found this script but it is searching from column B. Can anyone help me to setup the range of columns uptill 15 columns.

Please Login or Register  to view this content.

hi there, re uploading file: it happens sometimes, try to zip it and post zipped

PS. The link provided above is not correct and leads to nothing

Thanks for your response.

Still problem remain the same here is the file LINK

The reason for a problem with uploading file:
there is a limit on Excel files allowed for uploading - 1000 KB. Your file (previous post link) shows 1018.5 KB. Zip it and it should go ok as always

I've successfully downloaded the file.

What is the maximum expected number of data rows for Sheet "Data"?

I have no idea i suggest to make it open because it is keep of adding the rows and columns presently i am using 25 columns and 13,000 rows but this is not fix.

please check attachment, try to search for some text (search is case-insensitive)

Thanks for reply and help.

It is giving error. Say following:

Run-time error '9':
Subscript out of range

Also it can be possible to remove case-insensitive

to remove case-insensitive: comment Option compare text line in Module 1

re error: try to change this line in code "test":

Please Login or Register  to view this content.

to this one:

Please Login or Register  to view this content.

You guys are genius. People like me are non professional we just think for a solution you guys just do it. Thanks for your very valuable help.

One more think if i want to add or delete any field name which line i have to change. I have 7 different file which i have to work on every week. So, these fields are having different fields.

Let say i don't want to see Contact person and his mobile. What should i do.

There is another issue if the data is not found it should give message Saying that data not found in your records

I giving error.

Run-time error '9':
Subscript out of range

Also i have to close the workbook and open it again if i found the error. can you fix it please.

check the file which gives error this is original file CLICK HERE

For password check your pm

The result is totally changed some record displayed correct and some are wrong.

Wrong means places of fields. You have my file file try to check clinic you will find the issue which i am notifying to you.

the wrong places of fields appear due to the fact that CSV file created uses coma as field separator but some fields have coma inside so split by coma later produces more fields then should be

So i have to remove comas from my entire database this is impossible for me. Have to take out some solution for this.

And what is this CSV file.

modified code to address coma inside field option:

Module 1 code:

Please Login or Register  to view this content.

Thisworkbook level code:

Please Login or Register  to view this content.

It id working fine but one more thing it the searching result not found it is giving error. It should give message saying data not found something like this.

corrected to avoid error if nothing found:

Please Login or Register  to view this content.

Your 2nd script works fine but need small correction on empty search. If a user did not enter anything in the search box and press search button he should get a message saying you haven't enter anything in the search box.

Can it be possible and this will be last correction.

code "test", please change this:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

It works thanks for your most valuable help for me.Reputation added and topic marked as solved.