I have a spreadsheet with an auto filter. I would like to put some code in that the user can copy a Dealer name from another sheet and paste in say cell A1, press a button and it will filter for that dealer and all the information that goes with it. Any ideas? Thanks!