search and results

[mpower87]

hi guys, wondering if anyone could help me.

im making a search form that involves pulling data from one sheet to another. (i have attached the file for your convenience)

what i am trying to make it do is search for a value using application.match (if possible to do so based on first 6 digits only and not worry about the rest - kind of a partial match search) and then return the value + values of corresponding cells from a list sheet to a results sheet.

my problem is i can't get it to return more than one result. please, if you have a moment help me out. thank you in advance

[protonLeah]

An alternative:

Please Login or Register  to view this content.

[mpower87]

wow thank you so much, i only wish i had such vba skills. much appreciated.

[mpower87]

just another quick question, how would i go about adding a msgbox if nothing is found ?

I have tried adding an Else and a If Left(TestCell.Value, 6) <> PartSearch Then but this just causes problems and my error msgbox appears 100's of times (once for every part code that doesnt match)

i would like to have msgbox appear if it reaches end of the list with no matches, im hopeless, would be great if someone could help

[mpower87]

all fixed, thank you for your help :-)

Please Login or Register  to view this content.