Could someone please guide me: I have one sheet which has staff on the schedule marked as X or Y. Another sheet with work schedule. I would like to see staff names with X and Y against their names in sheet 1, to be populated on sheet 2, as in the example. Hope I am making sense. Thanks all.
Sheet 1: Staff Name 9/12/2016 9/13/2016 Staff 1 X 830 Staff 2 AL X Staff 3 830 830 Staff 4 Y 930 Staff 5 830 Y Staff 6 930 930 Staff 7 830 830 Staff 8 930 930 Staff 9 730 730 Sheet 2 Sep 2016 Monday Tuesday 9/12/2016 9/13/2016 07:45 to 12:00 Staff 1 Staff 2 1200 to1 1300 Staff 4 Staff 5 1300 to 1600 Staff 1 Staff 2 1600 to 1800 Staff 4 Staff 5 -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
