I got your point, we are increment the sequence id column and write comments in Status column.
In my process I converted the excel to data table and load all the sequence id’s, then started to process the seq Id one by one. At the end of each seq id i need to write the status whether PASS or FAIL in the original input excel. So when the seq Id open I am capturing the seq id and store it to a variable. I need to make the comment status column for this particular stored variable.
Is there any way we can directly filter the column in Excel and write some comments in excel for those respective filtered rows?