Dynamic Status list if criteria

[jammerdk]

I'm trying to make a dynamic status list using formulas, hope you guys can help me on this.​

My statuslist is showed in Sheet1 and my records shown in Sheet2

-Sheet2-​

Column A Cloumn B Column C
No Status Closed Remarks
C.11.25.11 x Yup finished
C.11.22.12 Still waiting
C.11.11.22 x Finished too

I'd like to show the records Sheet1 if they got the status closed ticked out with a "x" and Return Data from Column A and C

-Sheet1- (Status list)​

No. Remarks
C.11.25.11 Yup finished
C.11.11.22 Finished too

 

[jammerdk]

I'll try to explain more clearly.

I want any row marked with a "x" in Sheet 2 to popup in Sheet 1 and disappear when the row no longer is marked.

I want to make it dynamic as the listing in Sheet 2 will grow as data is entered.

Hope this explain want I'm trying to do

 

[jammerdk]

Never mind solve it