Hi
I have been playing around in Excel trying to create a bowling scoresheet.
I have been trying to add dropdown list from which the users can select the correct options.
I have been able to get the main drop down list to work but unable to create a dependent dropdown list
from the main list.
I have googled and tried different options but unable to get anything to work.
I am trying to keep the main data entry page to only allow specific details to be entered.
I then want all work and 3/4 or my formulas in other sheets so I can lock them down so the users
can't accidently delete a formula.
Anyways
Currently I am working on getting the Team input info working.
Sheet: GAME1 : Allows user to select a team name and then select bowlers on that team.
Sheet: DDL1: Table with team name header and associated bowlers listed below.
Sheet: Sheet1: Column A has a table with a header called Team List and under it is all the team names.
Column C - L tables with Team name header and list of bowlers beneath each.
I have been trying to use the INDIRECT function.
Sorry new to this.
Hope I added enough information and in the correct place.
Thanks
Bookmarks