ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Filtering a list of words (https://www.excelbanter.com/excel-discussion-misc-queries/210864-filtering-list-words.html)

Kevin H

Filtering a list of words
 
Hi everyone,

I have a list of of about 1350 words that I need to group into small groups
using Excel 2003's filter feature. I figured out how to use the custom
portion of the autofilter, but I am having trouble cutting and pasting the
results to a new sheet or column and then going back to the original reduced
list and filtering out a new group of words. When I go back the list the
data goes to different columns. I am a novice with Excel, so can someone
explain the steps to complete this task.

Thank you,


Ron de Bruin

Filtering a list of words
 
Hi Kevin

You can try the code on this page
http://www.rondebruin.nl/copy5.htm

Try the sheets option
http://www.rondebruin.nl/copy5.htm#sheet


--

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


"Kevin H" wrote in message ...
Hi everyone,

I have a list of of about 1350 words that I need to group into small groups
using Excel 2003's filter feature. I figured out how to use the custom
portion of the autofilter, but I am having trouble cutting and pasting the
results to a new sheet or column and then going back to the original reduced
list and filtering out a new group of words. When I go back the list the
data goes to different columns. I am a novice with Excel, so can someone
explain the steps to complete this task.

Thank you,



All times are GMT +1. The time now is 09:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com