How to maintain excel log report append range

Hi guys
I have facing one problem hope you can solve it, I am trying to maintain excel log file dynamic way i have excel file with given column like date,job no and status ,remark ,and I need to append when I get duplicate value from master sheet so my process is just to compare the job no with master sheet it no is exist in master sheet mean I do not have to process that job number I just need to update the log file with status is duplicate

so please help me how could I do this because using append range it be done and some time I did not get job number in this case I just need to update date column and status ,remark
Please help me I am stuck on this

Try to filter the Master Datatable using the NO, if the NO exist you can update the Status. If not update the other fields.

Hope this would help.