Auto list/filter
 

I'm having a little trouble finding the best way to do this. And then, of
course, actually doing it will probably be a problem as well. But here goes.

I'm creating a log using columns A-J in one worksheet. What I want is to
have another worksheet that will be only columns C and J AND only rows in
which the cell in column C reads "Closed". Here's the thing. I'm creating a
blank log. What I want is that as the data is entered into the log, it will
automatically appear in the other worksheet if the condition is met. Also,
column J is a dollar amount, so I want there to be a total at the end of the
list formed. Obviously, not every row will say "Closed, but I don't want
there to be spaces in the list formed. From what I gathered from other posts
and trying to figure it out myself, the problem with a pivot table, is that I
don't have any data yet, and the problem with auto filter, well, is that I
don't want to have to manually sort anything, I want it to automatically
populate.

Is there anyone who can help me do this?

Thanks,
Scott