Hi Forum,
attached is excel document with two sheets. the First sheet has the monthly schedule. the second has the daily schedule. I was looking for code where I can automatically fill the daily schedule from the monthly schedule. For example 100/200 Nurse will either be Nurse1 or nurse2. On the monthly schedule, if the value is 1 for nurse1 then her name should display on the daily schedule. If her value is zero, then nurse2 should be displayed on the schedule. The only input that I need to put is the date on K1.excel forums.xlsm