Need Help on Excel Formulas

[tensionado10]

I need help on how or what the formula to use.

on Sheet 1 i have somewhat like this below:

A | B | C | D |
1 TS1 | Ron | | |
2 TS3 | Rex | | |
3 TS1 | Ran | | |
4 TS2 | Red | | |
5 TS2 | Ros | | |
6 TS3 | Rem | | |

What i want to happen is on sheet 2, is have the names of all TS1 position, TS2s on sheet 2 and TS3s on sheet 3.

is it possible? what is the formula that i have to use? can anyone give me a sample formula?

 

[sheetspread]

A pivot table can separate a database into named tabs by a specific field. Or you can use a loop in VBA of the advanced filter:

http://www.get-digital-help.com/2010/03/03/split-data-across-multiple-sheets-in-excel-vba/