Or use AutoFilter
Here is a code example
http://www.rondebruin.nl/copy5.htm

Or this add-in
http://www.rondebruin.nl/easyfilter.htm



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"roadkill" wrote in message ...
You could sort the data based on the code column (to group them together) and
then copy/paste to another tab.
Will

"Kat" wrote:

I have a database of information in an excell document. It has had codes
placed on it. What I would like to do is to pull all the rows of data that
contains a specific code on it into a new tab. Any suggestions on this would
be greatly appreciated.