Movie Database Search.

Hello again,

Kindly, see the attached file and edit the code so that if i type a part of text belongs to Column A it will grab the data from the other sheets and display below in search sheet.

Can anyone help me in this issue.

Sheet is attached for your easy reference.

Thanks in advance.

thanks for responding to my request.

yes my data is in one sheet. i.e. Movie list1 and when i search it will display all the results match to my search with black highlighted fields in search sheet.

up till now no response from anyone.

no one wants to help me to setup this script.

Thanks boss i will check and let you know the status. Thank you very much for responding to my request.

Thanks royUK,

Kindly check the updated file but having some errors. the movie name (Description) is correct but the rest of the information is not correct.

Check the attachment.

Hai royUK,

it is working fine. I will get back to you if i have any problems otherwise i this topic will be marked as solved and reputation will be added to you of course. Thanks for your efforts and valuable help.

God Bless You.

Hai royUK,

I have an issue with this script.

First issue is when i type my word in search sheet column A2 its searching from sheet Movie List1 column A where as i want to search from column C.

Second issue is test case and part of string. It means there should be no case sensitive and part of string is typed in search it should display the result.

Example: if I type string "and the Half" in search column it providing me the result.If i type And The Half it is not displaying anything.

Can you help me to resolve these issues please.

Waiting for your response.