dropdown lists

3 Topics

Data validation lists - flow chart?
Hello, I'm a school leader and I'm trying to create an Excel spreadsheet to track Teaching & Learning action steps that I give to teachers. I understand how to create a drop down list but what I'm trying to do is essentially create a list within a list, like a flow chart. For example: I'm creating a Maths specific tracker at the moment that has 3 dimensions of depth and specific focuses for each dimension. So if I select the dimension of depth as "Language and Communication" then I want a list of Language & Communication focuses to appear to be selected. But if I select the dimension of depth as "Conceptual Understanding" then I want a list of Conceptual Understanding focuses to appear instead. From there I want to be able to type in the action step as normal. I've attached a very basic excel of what I'm looking for. Ideally I'd like to have just one document with a different page for each teacher rather than loads of separate spreadsheets. Is there a way that I can do this?
Solved
PhoebeRow
Feb 17, 2019 Place Excel
11KViews
0likes
16Comments
Change List Selection VBA
Hi Folks! A list of items is stored on one worksheet in a workbook. By selecting an option from a dropdown menu, the item may be copied to another sheet in the workbook. I need to be able to automatically change the selection in the dropdown on the initial worksheet. Can anyone help with this? Thanks!!
Jecynta
Oct 03, 2019 Place Excel
1.7KViews
0likes
1Comment
Excel Drop Down List
Is there a way to create a drop down list with Images? I have a library of simple cad profiles that I want to set up as a drop down list. Each image has a designated unique file name. The list will live on a form that needs to be fillout, so instead of describing each image in a drop down list, I would like to show the image
Tracy_C414
Aug 30, 2019 Place Excel
886Views
0likes
1Comment