| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I manipulate data pulled from within an excel calendar? | Excel Discussion (Misc queries) | |||
| copying charts into new sheets, data is pulled from old sheet | Charts and Charting in Excel | |||
| Using AutoFilter to Sort Data Pulled in by INDEX / MATCH | Excel Worksheet Functions | |||
| Need info pulled from worksheet | Excel Worksheet Functions | |||
| VLOOKUP-How do I get answers pulled from different appropriate col | Excel Worksheet Functions | |||
Linear Mode
