All i want to do is make it so Userform2 shows when the workbook is open.

It will prompt the user for a number (TextBox1). Excel then uses that number
to autofilter Worksheet("Expense") which Goes from A2 to I559

Then is dropped into cells A2 in Worksheet("Miles") and Worksheet"(Expense
Non-AMEX)

Any Idea how to do this?

Thanks!