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.