Input box sorting?
 

What i want to do is when someone opens the excell file it asks them for
their card number. When they click okay it filters column A in the "expense"
tab just the same way if you auto filtered and used the drop down list.

The only thing is i dont want it to allow them to filter again after they
have clicked okay.

I have no idea how to do this any advice would be great.

Thanks,
Alex