Hello,
I have five rosters of names in a Roster tab. I have a cell on a separate Report tab that calls an individual roster. Can I use data validation to choose which roster to call to this Report cell?
I want to have two data validation areas on the Report tab. One that calls the correct roster to the other one.
Thanks for any help.
Here are pics of a couple of the rosters and the report:
DV prob - Roster.JPG
DV prob 1.JPG