This is an easy one:)
In your code you have
ListObjects(1) means a table but in your example you don't have a table.
Solution: insert a table in the guests sheet.
@ Fred Wayne,
This is a forum rule.
Start a new post every time you ask a question, even if the theme is similar.
Next time, don't break in anyone else's thread but start a new thread.
For your question.
The guests that do not meet the search criteria disappear from the listbox.
Also use a table.
I've adjusted Question 1.
For question 2.
Step 1. You search for the case#, the numbers that do not match the search criteria disappear from the list.
Step 2 When you have found the right case # you have to click on the right case in the list.
Step 3Then make the changes in the textboxes...