G
Guest
I am making a sheet where for example 'the cell A1 has a data validation
list' and depending on the selection in A1 cell the data validation list in
cell B1 will change.
for example:-cell A1 contains the list of team leaders depending on the
selection of the team leader from the list in A1 i should get a list of his
team members in cell B1.
Is that possible using data validation or do i need to use macros to get
that functionality. can anyone help me with that.
list' and depending on the selection in A1 cell the data validation list in
cell B1 will change.
for example:-cell A1 contains the list of team leaders depending on the
selection of the team leader from the list in A1 i should get a list of his
team members in cell B1.
Is that possible using data validation or do i need to use macros to get
that functionality. can anyone help me with that.