How to get certain cells to autofill with data from another tab?
I have a drop down box in cell J5 that contains a list of VEH-#'s. What I would like is to be able to do is pick one of the VEH-#'s from the list and cells L5, J6, J7, and J8 will be automatically filled in with the correct data that is on another tab.
Example; If I pick VEH-001 from the drop down box in cell J5 then the following will happen:
Cell L5 will show the SAP # for that VEH-#
Cell J6 will show the Make for that VEH-#
Cell J7 will show the Model for that VEH-#
Cell J8 will show the S/N for that VEH-#
Is this possible and if it is how do I set it up?
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By mpresto75 in forum Excel - New Users/Basics
Last Post: 06-21-2013, 10:09 AM
By Shaner73 in forum Excel Formulas & Functions
Last Post: 11-29-2012, 08:51 AM
By drugramps in forum Excel General
Last Post: 05-14-2010, 06:31 PM
By dstock in forum Excel General
Last Post: 06-17-2005, 04:05 PM
By Mr. G. in forum Excel Formulas & Functions
Last Post: 04-22-2005, 05:06 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1