Specific data pulled to new tab
 

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.

Specific data pulled to new tab
 

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.

Specific data pulled to new tab
 

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.