Hi JC,

See Debra Dalgleish's tutorial on the Advanced Filter feature at:

http://www.contextures.com/xladvfilter01.html

See particularly the section entitled: 'Extract Data to Another Worksheet'


---
Regards,
Norman


"JC White" <JC wrote in message
...
I am in the NC National Guard, and I am working on some spreadsheets to
make
filing easier. I have one worksheet called "Alpha Roster" that I have
listed
all the Soldiers within my Unit. This worksheet list the Soldiers each on
a
separate row, and I have various data listed in the columns--last name,
first
name, MI, SSN, Location, ect.

I would like to be able to pull all the data in a row off this worksheet
into another if certain criteria is met within one column.

For example, I have three locations--Kinston, Wallace, and Beulaville. I
would like to have all the rows having Kinston in column "M" pulled to the
second spreadsheet I'll call DET1. The same applies for the other
locations
on different spreadsheets called DET2 and Echo.

Please help. How do I get these rows of information to be displayed on the
second and third worksheets? This will allow me to have updates made only
on
one sheet, but view data on various sheets based on what I need to
accomplish.

Thank you all for your time and assistance.