Look up a specific record in Data File and display in UserForm ListBox

See the attached amended file. It uses an advanced filter to filter the selected Store No. and creates a dynamic named range which becomes the List Box row source. On the Data Sheet the code uses Current Region to look for the data if you add new lines but you need to keep empty space around the data table to use this.

DBY