How do I make a validated cell to bring up more data from another worksheet?
I want to have a drop down cell (validation) that once I select a value from a list, different cells within the spreadsheet will be populated with unique data. For example, I select from cell A1 the drop down list a car manufacturer Ford, then in other celles within the spreadsheet (B2:C3), a list of models will appear (Focus, Mustang, Explorer, etc). Such list can allow me to enter data regarding each model. But if I select from the drop down list on cell A1, Chevrolet, then the spreadsheet will bring up a separate list of models (Tahoe, Malibu, Impala, etc) within the spreadsheet B1:C3.
My goal is to create a template that can create editable data within one sporeadsheet upon calling a specific value in a cell (in this case A1).
Use a cross reference list.
Items Recently Purchased From This Site:
4pc Chevy Skull - Bowtie Decal Set - windshield + 3 body decals 16 EYE Colors, Chevy Tribal Skull - Bowtie Tailgate Window Decal Silverado 16 COLORS AVAILABLE, Chevrolet Camaro Corvette Cruze HHR Impala Malibu Sonic Volt Tahoe FOB Key Chain, CHEVY WHEEL TIRE VALVE CAP MALIBU VOLT CORVETTE AVEO EQUINOX COBALT TAHOE IMPALA, Transponder Key Fits Chevrolet Malibu Impala SIlverado Tahoe Traverse HHR, Transponder Key Blank Fits Chevrolet Malibu Impala Silverado Tahoe HHR Traverse, Engine Computer 08 SUBURBAN YUKON TAHOE IMPALA MALIBU, White 39-42mm 24-SMD LED Chevrolet Impala HHR Tahoe Malibu Map Panel Lights #32, Engine Computer 08 SUBURBAN YUKON TAHOE IMPALA MALIBU, Engine Computer 08 SUBURBAN YUKON TAHOE IMPALA MALIBU, BMW SHARK FIN ANTENNA CHEVY IMPALA MALIBU TAHOE EQUINOX, 07-10 Lesabre Impala Avalache Malibu Tahoe Vue Tire Pressure Sensor TPMS #287, 09 10 11 12 NEW CHEVY IMPALA MALIBU TAHOE COBALT WHITE LED MAP DOME DOOR LIGHT, 7pc --TRUE FIRE-- Chevy 350 Bowtie Decal set Chevy Camaro Silverado , 7pc Chevy 350 Bowtie Decal set Chevrolet Camaro Silverado AVAILABLE IN 16 COLORS, GM TIRE PRESSURE SENSOR ESCALADE YUKON TAHOE MALIBU IMPALA LUCERNE NEW 25920615, 07-10 Lucerne Lesabre Impala Aveo Malibu Tahoe Vue Tire Pressure Sensor TPMS 171, 2008 Chevrolet Sales Brochure Impala Equinox Aveo Malibu HHR Silverado Tahoe, 1969-1995 Chevy,Malibu,Blazer,Impala,Novam,Tahoe & More K&N Air Filter E1500, WHITE SHARK FIN ANTENNA CHEVY IMPALA MALIBU TAHOE AVEO, GM - Corvette/Tahoe/Impala/Malibu/HHR - LIGHT GRAY Leather Color Touch Up Kits, CHROME SHARK FIN ANTENNA CHEVY IMPALA MALIBU TAHOE AVEO, BLACK SHARK FIN ANTENNA CHEVY IMPALA MALIBU TAHOE AVEO,
