Raw Data to propagate another workbook.

I need some guidance or assistance on a project. Currently I export data from my Student Database, then i have to manually enter it into a home room template. The raw data has all the fields i need but i need it to populate the correct home rooms. There are 5 home rooms (HR1A, HR1B, HR2, HR3, and HR4). We never have more then 20 students in each home room. I have attached a sample.

Work Book 1 is a current sample of what I generate. Note that the yellow highlighting is from the A.R.T. field, and the red SAC overrides the Dorm number denoting that student as a After Care.

Work Book 2 is an empty template.

Work Book 3 is an export I just did with the only exception being that I have replaced the students names.

Any assistance or guidance with this is appreciated.

Thank you

Don.

Thank you I am building up my higher end excel knowledge to be able to utilize the code you provided.

Thank you

Was able to get it working. THANK YOU!!!! YOU ARE AWESOME.

Quick question. The SAC, (which works PERFECTLY) also has another section called YAC. How do i set it to do either YAC or SAC to override the dorm?

Thank you