I am old but new to VBA for Excel(did programming eons ago). I have gleaned what I can from your forum over the last four months but cannot find a way to:
1. Write an “event” triggered program that would capture the date entered in one of ten columns that would dictate what information to copy and paste into a new worksheet defined by column C (Hunit).
2. If the work sheet does not exist, I would like the program to define it based on a template.
3. If person’s name does not exist in Worksheet, I want columns A, C, E:S, Triggered date from T:U, W:X, Z:AA, AD:AE, and AH:AI (as a single date) along with corresponding information from columns V, Y, AB, AC, AF, AG, AJ, AK, AL, and comments (if any) from AM to be copied and pasted into the new worksheet. The triggered event can happen in multiple rows but usually involves one date that can appear in one of five "sets" of data.
4. Thereafter, only the name and information triggered by the event would be inserted on a new line in the appropriate worksheet with the worksheet re-alphabetized with an empty row separating each employee (if possible.)

I have attached a sample sheet with the raw data (use RN’s) and an example of what the output sheet should look like if I can get the programming to match. Any suggestions would be helpful, even if you point me in the right direction for coding purposes. Sorry, I do not have code to post, just the program that I developed.

Call1.xlsm

Thank you in advance.