![]() |
#1
|
|||
|
|||
![]() 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 |
#2
|
||||
|
||||
![]() Quote:
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) ?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
![]() Quote:
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. |
![]() |
Tags |
focus, vlookup |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Phil H | Excel Programming | 3 | 06-18-2015 01:20 PM |
Move data from one sheet to the next available row or cell of another sheet | bwwalker08 | Excel | 0 | 04-10-2015 11:51 AM |
![]() |
lilvillaf | Excel | 2 | 06-12-2014 05:39 PM |
![]() |
maximbebi | Excel | 3 | 02-16-2014 11:46 PM |
![]() |
santors71 | Excel | 1 | 12-07-2011 09:20 AM |