Hi Paul,

You might consider using the Advanced filter feature.

If you are unfamiliar with this feature, see Debra Dalgleish's tutorial at:

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

Note particularly, Debra's 'Extract Data to Another Worksheet' technique
notes.

If this is not a one-off operation, you could turn on the macro recorder to
provide you with editable code.

---
Regards,
Norman



"Paul" wrote in message
...
I am working on a workbook which imports a whole heap of data into one of
the
sheets of the workbook. I then need to select and paste the different
parts
of the data into other workseets in the work book. Is there a program I
can
use which will cut the rows from the raw datasheet which have the same
specific value in the first cell and paste the entire row to their
corresponding worksheets.?? And then so on with another row with a
specific
value in the first cell and paste to another worksheet etc.