Macro to display rows on separate sheets based on condition

Hello,
Im working with a workbook to keep track of customer returns. I have attached my draft sheet. The sheet "Return Log" is where i want to enter data on a continual basis. I want the returns with the status "open" to be displayed on the sheet "open returns" and vice versa. I want all info in the "return sheet" to stay there, so i would only want it copied from one sheet to the other. The workbook would also have to be self updating, as a return on the "return log" sheet could change from open to closed. I would then expect that return to appear on the "closed returns" sheet and disappear from the "Open Returns" sheet.

AdvancedFilter will suite for this

Please Login or Register  to view this content.

Your code works great!
However, how do i get it to execute automatically when i change a value on "Return Log." Right now i have to run the macro manually.

Then place the following code onto "Retun Log" sheet code module.

Please Login or Register  to view this content.

Excellent!
Thank You!

I've copied and modified your original code to sort information from "Closed returns" sheet into 12 other sheets (for 12 months) but its not quite working yet. Im sure i messed up something simple. Can you take a look?
So the flow will be, data entry into "return log", sort to "open" and "closed", and from "closed" sort to month.

1) Delete current codes.
2) To a standard module

Please Login or Register  to view this content.

3) To ThisWorkbook code module.

Please Login or Register  to view this content.

Hello Again,
I just tried inserting another header row above my spreadsheet that will remain static and changed the one line of your code from Range("a1:a2") to Range("a2:a3") and the code no longer copies anything. Any thoughts?

phbryan,

Sorry I was away.

Can you upload a workbook?