In the attached workbook I have started creating a userform to search the data in Sheet EWC code and return all possible entries in a display. The format of the display would be the same as columns C F G H in Sheet1
The product description would be entered as text (this will be the search word that will be used to locate the descriptions where it is mentioned)
The collection facility is chosen from a list (this will influence the returned entries as from the section of the database it will display)
The destination facility is chosen from a list (this will influence the returned entries as from the section of the database it will display)
I have not though of the process yet to determine the influence these will have
I am new to userforms and usually would have approached this using index match but want to start using userforms more.
Any pointers in displaying waste code entries in the database from the entry in a text box would be most appreciated
See attached workbook in second post
Ta
Bookmarks