Formula Help/Suggestions

Hi

I'm a management accountant and have to use large quantities of data regulary.

A typical list of data I use would be about 10 columns and a few hundred sometimes thousand rows. My column headers are usually: Account, Cost Centre, Date, Description, Amount, supplier and so on.

I need to go down this list and pull out anything that needs to be prepaid. So basically i'm creating a second list from the main list of data.

What I usually do is create an extra column and name it "Prepay?" I would then go down the list and anything that needs prepaying I would place a "P" in the cell. After I have gone through everything I then sort by the "Prepay" column and copy these lines to another tab.

As you can quess this can be very time consuming!

Ideally it would be very useful if, when I place a "p" in the cell, the line of data is automatically copied into a new tab so I don't have to do it manually at the end.

Is this possible? I'm not sure whether it would be a formula or something else that I need to set-up but any help would be appreciated.

Thanks
Ryan

It might be easier to make a pivot table, especially if you are just going to total the figures!