Untitled

i have a sheet named "New_CB_Response" where i created Microsoft Form to collect data and stored in sheet named "New_CB_Response".
i have another sheet named "Calendar" where i have roster of my employees with name

now that i have data in "New_CB_Response", i want a typescript