Good day all.

I believe that this is my first post.

I am compiling a workbook using Excel 2013 of various sheets for vehicle fleet which contains some the following sheets ...

Vehicle selection - This is where I input the registration Number to query the vehicle in question
Vehicle Registrations - This lists all the vehicles with the associated vehicle data
Vehicle Report - The full vehicle report on the vehicle in question (drivers, mileages, accidents, repairs etc)

Using VLOOKUP in the vehicle selection sheet will fill the required details in the Vehicle report sheet but the focus stays within the Vehicle selection sheet.

What I would like to do is to move the focus from the Vehicle selection sheet to the Vehicle Report Sheet once the match has been found.

The entire workbook is based on VLOOKUP and drop down lists although intending to switch to INDEX & MATCH in the very near future

Thanks in advance for any help given