Want to update not executed data in excel as per source excel sheet

Hi ,
I have 2 excel sheets ,1 is source excel from where im passing the control for execution(Y for executing test case and N for not executing) and in 2nd excel I’m checking result of the batch(Either Passed or Failed).I’m successfully updating passed and failed in status excel sheet.now i want to add Not Executed status as well in status excel.can you please guide me on this.
Pooja Shinde