Quick simple question

Ok, I believe I have a very simple question, I'm just too stupid to answer/solve it myself.

I'm working on a home assignment for my IT class, and we're supposed to make this excel "thingy" for a dvd rental place.

I have two spreadsheets, one with dvd's being returned and the other with overdue dvd's. On my "return" sheet I have a row for each dvd being returned and column which calculates whether a dvd is late or not. It gives me a "yes" and a "no".
What I want, is for excel to put all the late DVD's with a "yes" into the "overdue" spreadsheet. But I want the whole row copied.

I've tried advanced filter already, but it doesn't update, so now I'm looking for somethin' else.

Thx in advance, any help is appreciated

okay thx.

My only problem with doing this is that when I add new returned DVD's then they aren't automatically added to the "overdue" spreadsheet, plus I have a couple formulas on the "returns" spreadsheet (e.g. counting how many days late the movie is) and when I use the advanced filter I lose all these formulas

I can get around the second problem in a way, but can s.one give me a way to have the "overdue" spreadsheet automatically updated from the "returns" spreadsheet"?

What you're asking for can be done, but...

Ideally, a VBA solution would work best, I think. The next best alternative for me would be some way to make the Advanced Filter work (perhaps with a little VBA assistance). The 3rd alternative, using functions, is possible but could be extremely formula intensive and potentially volatile.

If you're comfortable with VBA, I'd go that route, but it'll be sort of a project. So...the ball is in your court.

I hope we're getting you on the right track here.

Regards,
Ron