Hi all,

I have a column in sheet 1 as status.

while enter data in sheet1,if the status is open then the entire column should be populated in sheet 2.

if i change the status in sheet 1 from open to other, then the corresponding row should be deleted from sheet 2.

please let me how to do it.

Thanks in advance.