How To Move Focus From VLOOKUP Result to Report Sheet

[swindon.expat]

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

[Pecoflyer]

Originally Posted by swindon.expat

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.

Hi and welcome
I don't understand the sequence of events. I suppose you enter some data in the report sheet which draws data form the other sheets. Why should the focus then be on these other sheet(s) ?

[swindon.expat]

Originally Posted by Pecoflyer

Hi and welcome
I don't understand the sequence of events. I suppose you enter some data in the report sheet which draws data form the other sheets. Why should the focus then be on these other sheet(s) ?

Hi

Sorry if I have not made it clear, maybe I have mis used the word Focus.

I think I may have got myself a bit lost. I will try and cut the file to a decent size and upload so you can see what I am after, but unable to do so until later in the week.

Many thanks for the reply.