Excel 2003 Extract rows based on cell data

[mcauliff]

I have a spreadsheet that has 1530 rows. I need to separate it into other spreadsheet based on a cell content (centers). An example: is that a spreadsheet would have centers; 5, 55, 101, 200. There are other spreadsheets with the remaining centers.

 

[SkipVought]

You could either use the PivotTable wizard or MS Query. faq68-5829

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}