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..![]()
Bookmarks