I am hoping someone can help me. I will be as detailed as possible, but please let me know if you need more information from me.

What my end goal is for this to happen:
Staff are to enter information on the worksheet "Absence Memo".
I then need some of this information to then copy over to the worksheet called "ProjectedActual".

The first thing that would need to take place thought would to have Absence Memo B7 (name of Physician) to be searched and then found in the ProjectedActual sheet. The name would only appear once on this sheet.

After the search is done, the following information is required to transfer and entered int the next blank line after the doctor's name.
- Absence Memo E12 to ProjectedActual column D
- Absence Memo G12 to ProjectedActual column B
- Absence Memo I12 to ProjectedActual column C

Please let me know if you require anything else from me!!

Thanks!

Alert Chart - 2012.xlsm