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

Copper Contributor

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.

3 Replies


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

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


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.