Moving cells based on a status

Hi,

I am not sure if this can be done but I am currently building a report and when something is marked as complete I want it to remove from the page and go to a different sheet. To make it more complicated I need it to register that it is for group A and move to group A's sheet. Group B, C etc.

So it creates a bit of a database of completed tasks for each group on a different sheet.

Any help to do this would be great, or a this can't be done comment would be great.

I am inter-adv with excel and have tried numerous formulas but none that I could get to do remotely what I want.

First time poster so if more info is required let me know

R

Ok thank you!

I will go and learn some VBA

Thank You! I will learn VBA