G
Guest
I have set up a form on the second sheet of a workbook. The first sheet
contains all relevent information for clients(in my case physicians). On the
second sheet i have set up a form, which will be used in the office, that has
a combo box list (i used the one available in the forms toolbar, as i do not
have the coding experience to use the ones in the control toolbox). This
list references the project name, and the cell reference is cell n1. I then
used the vlookup function to reference cell n1 and find the equivalent match
within sheet 1 using identifiers for each reference. ie project one (the
first option in the dropdown list) has an identifier of 1 within sheet one.
So if the value in N1 is 1 then all of the vlookup functions in the rest of
the form return the equivalent value for Idenfier 1 from Sheet 1. So in
essence whenever i change the Project name, all data in the form changes to
the corresponding identifier reference. However each project has different
clients with in it. SO when i choose a project is automatically returns the
first name with that identifier. My question is how do i make another combo
box which references the previous list and returns only the clients that have
that common project name. Any help is appreciated. I have visited the
contextures website which i have seen referenced here often and am throughly
confused. Thanks again and sorry for the wordiness.
contains all relevent information for clients(in my case physicians). On the
second sheet i have set up a form, which will be used in the office, that has
a combo box list (i used the one available in the forms toolbar, as i do not
have the coding experience to use the ones in the control toolbox). This
list references the project name, and the cell reference is cell n1. I then
used the vlookup function to reference cell n1 and find the equivalent match
within sheet 1 using identifiers for each reference. ie project one (the
first option in the dropdown list) has an identifier of 1 within sheet one.
So if the value in N1 is 1 then all of the vlookup functions in the rest of
the form return the equivalent value for Idenfier 1 from Sheet 1. So in
essence whenever i change the Project name, all data in the form changes to
the corresponding identifier reference. However each project has different
clients with in it. SO when i choose a project is automatically returns the
first name with that identifier. My question is how do i make another combo
box which references the previous list and returns only the clients that have
that common project name. Any help is appreciated. I have visited the
contextures website which i have seen referenced here often and am throughly
confused. Thanks again and sorry for the wordiness.