Forum Discussion
Auto-populate cells based on value in dropdown list
Good afternoon. I have two sheets in my workbook that I am using to do a vehicle cost analysis for a fleet of school vehicles. Sheet 1 is the actual cost analysis sheet while sheet 2 is a list of vehicles. On sheet 2, the vehicles are placed into a category based on its age. I want to choose a category from the dropdown list on page 1 and auto-populate the list of vehicles based on the category on page 2. Can this be done? Thanks for the help.
1 Reply
- Yes this can be done.
Just have a look to this post from Debra Dalgleish on Contexture
Create Dependent Drop Down Lists (http://www.contextures.com/xlDataVal02.html)
