Hello wonderful Excel experts!
I need help please, I want to create a spreadsheet with a column with a drop down of team names (Team A, Team B, Team C and so on). I then need to have a different Team sheet that will capture the relevant team information.
So for example Sheet 1 one will be master file, then sheet 2 will be “Team A” and all data on the master file with Team A selected in the drop down column is captured and moved to the corresponding sheet – does this make sense and is this possible?

Many thanks!
Ryles