Moving Records

[Angus McBagpipe]

I have a large spreadsheet which is a massive list of projects.
The projects are listed by row within a tab named "Projects".
Each project generally consists of about 15 fields
The fields, by column, are things like address, status, name, Dollars etc ...

I want to create a Button that selects all records with the status "Won"
And the then moves the Records into separate tab of the same name "Won".

Is this possible?
There are actually a number of different Status' I will create buttons for each.
There are about 10-20 records per status getting moved.
Sadly my company is still using Excel 2007

Any help you can offer would be greatly appreciated.

 

[Fennek]

Hi,

without knowing the table:

- Autofilter on "Won"
- select visible cells: copy/paste

regards