#1
|
|||
|
|||
How To Move Focus From VLOOKUP Result to Report Sheet
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) ?
__________________
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro to move focus after entry in a cell | 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 |
Fetching more than one result with VLookup on multiple sheets | lilvillaf | Excel | 2 | 06-12-2014 05:39 PM |
How to move data from one sheet to another | maximbebi | Excel | 3 | 02-16-2014 11:46 PM |
VLOOKUP in different sheet. | santors71 | Excel | 1 | 12-07-2011 09:20 AM |