trying to automate dropdown menu in excel

[Reactive]

Have created a sheet that uses a dropdown list to source data from another sheet.  Looking to see if I can automate the process for a display so it will automatically scroll through the dropdown list selections

[#2]

@Reactive That is quite easy with a bit of VBA:

Sub RunThroughTechs()
    Dim Tech As Range
    For Each Tech In Range("Techs")
        Worksheets("Display").Range("K1").Value = Tech.Value
        'Now do something like print
    Next
End Sub