how to auto fill information from a master sheet based on day range in excel

[Meri_Gates]

Good Morning,

I have a excel sheet that I work on for the year Jan-Dec.  I have a master sheet of patients that get treatment M, T, W, TH., FRI. and Sat., how can I automatically have the patients name populate on the days of their treatment?  Thanks very much for the help.

[#2]

@Meri_Gates 

It would help if we knew the layout of your workbook. Could you attach a sample workbook with a few fake patients?

[#3]

how can I add the excel sheet I don't see where I can attach

[#4]

@Meri_Gates 

If you don't see an area with "Drag and drop here or browse files to attach" below the box where you compose a reply, you can upload a workbook to OneDrive, Google Drive, Dropbox or similar, then obtain a link to the uploaded file and post that in a reply.