Hi All,

i have a workbook with two sheets named "sheet1" and "sheet2".If i insert anything in sheet 1, that should automatically populate in sheet 2.

I have a column name as "status" in sheet 1.

If i insert anything in sheet 1, that should automatically populate in sheet 2 is my primary target.But if i update the status column in sheet 1 that should highlight that particular row/cell in sheet 2 expect the status "Resolved". If the status in sheet 1 is updated as resolved, then the specific row in sheet 2 should be deleted.

Please help me..., Thanks in Advance..