automatic deletion of records

[jarl1947]

I have a spreadsheet monitoring the progress of accounts through various stages of a process. Once an account reaches a specific point in that process it would be useful to remove the record to another sheet in the workbook.

Is it possible to use a formula to automatically remove all records that meet a particular criterion and place them on another worksheet?

I'm guessing if this is possible at all it can only be done using VBA. I have no experience with VBA but would be willing to give it a try.

Any suggestions gratefully receieved. Thanks.

 

[Tazguy37]

Advanced Filter or Autofilter could do that.

Care to post a sheet sample (using Colo's HTML Maker utility) or describe how the data are laid out in more detail? I'm sure something could be worked out, either a VBA or formula solution.

Hope that helps!