I am trying to make a daily roster from our weekly schedule that will auto generate.
Mon. Tues. Weds.
Tom 10am 10am 10am
Bill 11am. 12pm. 12pm
Sam 9pm. 7pm. 7pm.
What formula would I use to pull this information to a different worksheet.
Monday
Tom 10am
Bill 11am
Sam 9pm
Thanks.