Hi All
I have been playing with this for a while with online tutorials but none give the answer to exactly what I want so am hoping you can help.
I have a reporting workbook with 13 worksheets (and one other worksheet called Lists where I have for the source drop down lists). On each of the 13 reporting worksheets I have a Clinic field and a Machine No field, the Clinic field contains the names of 15 individual Clinics in a column list that I have on the Lists worksheet.
Each Clinic has unique machine numbers allocated to it, some Clinics only have one (1) others have two(2) and a few have three(3) machine numbers. I have set up separate column lists with the name of the Clinic as the header for each list and the Machine No's for that Clinic listed in the relevant number of cells below the header. That is, there is one list with the 15 Clinic names in it and 15 separate Machine No lists - one for each Clinic name.
I would appreciate knowing how to set up dependencies on the basis that if the user selects Albany, for example, from a Clinic field drop down list on any of the 13 reporting worksheets, then when they click the drop down list on the Machine No field (directly below it) it will ONLY display the Machine No's listed for Albany.
Thank you in advance for help anyone can provide
I have been playing with this for a while with online tutorials but none give the answer to exactly what I want so am hoping you can help.
I have a reporting workbook with 13 worksheets (and one other worksheet called Lists where I have for the source drop down lists). On each of the 13 reporting worksheets I have a Clinic field and a Machine No field, the Clinic field contains the names of 15 individual Clinics in a column list that I have on the Lists worksheet.
Each Clinic has unique machine numbers allocated to it, some Clinics only have one (1) others have two(2) and a few have three(3) machine numbers. I have set up separate column lists with the name of the Clinic as the header for each list and the Machine No's for that Clinic listed in the relevant number of cells below the header. That is, there is one list with the 15 Clinic names in it and 15 separate Machine No lists - one for each Clinic name.
I would appreciate knowing how to set up dependencies on the basis that if the user selects Albany, for example, from a Clinic field drop down list on any of the 13 reporting worksheets, then when they click the drop down list on the Machine No field (directly below it) it will ONLY display the Machine No's listed for Albany.
Thank you in advance for help anyone can provide
