Say I have two named ranges,
- team_a_coaches
- team_a_players
Is it possible to have another named range,
- team_a
and define it as the union of the first two named ranges?
The goal would be that if I edited a cell or added a cell for team_a_players, team_a would automatically update.
Here is a demo spreadsheet. Please make a copy and you'll see that I'm trying to use these named ranges for data validation.