Find and Copy QPapillon 25.09.2006 15:36:02 Good Morning, I have a list of over 2000 items with several columns per entry. I was able to use the 'find' function to find entries with a specific word in them and where they were within the list but now I'd like to isolate those item, copy them and place them in a separate sheet. Is there anyway to do this easily? Thanks! Carol

Re: Find and Copy "Trevor Shuttleworth" <Trevor[ at ]Shucks.demon.co.uk> 25.09.2006 17:50:50 Carol you could use AutoFilter to select the entries and then select the visible cells/rows and copy them to another sheet. Regards Trevor "QPapillon" <QPapillon[ at ]discussions.microsoft.com> wrote in message news:E62F91CB-D95B-468C-BF94-033756BA3E02[ at ]microsoft.com... [Quoted Text] > Good Morning, > > I have a list of over 2000 items with several columns per entry. I was > able > to use the 'find' function to find entries with a specific word in them > and > where they were within the list but now I'd like to isolate those item, > copy > them and place them in a separate sheet. Is there anyway to do this > easily? > > Thanks! > Carol

Re: Find and Copy QPapillon 25.09.2006 19:59:02 they aren't all exactly alike - but they all have a least one word in common, does this still apply? Thx! -C. "Trevor Shuttleworth" wrote: [Quoted Text] > Carol > > you could use AutoFilter to select the entries and then select the visible > cells/rows and copy them to another sheet. > > Regards > > Trevor > > > "QPapillon" <QPapillon[ at ]discussions.microsoft.com> wrote in message > news:E62F91CB-D95B-468C-BF94-033756BA3E02[ at ]microsoft.com... > > Good Morning, > > > > I have a list of over 2000 items with several columns per entry. I was > > able > > to use the 'find' function to find entries with a specific word in them > > and > > where they were within the list but now I'd like to isolate those item, > > copy > > them and place them in a separate sheet. Is there anyway to do this > > easily? > > > > Thanks! > > Carol > > >

RE: Find and Copy REST 25.09.2006 21:09:02 I would use the formula =IF(ISERR(FIND($K$1,F4)),"",F4) where $K$1 is the location of the text string, tipicaly the top of the column (the text can be substuted in its place), and F4 is the location of the full text string with $K$1 text string within it. This can can be either valued copied to another worksheet (workbook) or the formula can be developed on another worksheet. Any thing that does not have that text string within it will be a blank This would also work if you wanted wanted to include another column with this string by changing the second F4 to say F5 or F3 etc. the REST is history "QPapillon" wrote: [Quoted Text] > Good Morning, > > I have a list of over 2000 items with several columns per entry. I was able > to use the 'find' function to find entries with a specific word in them and > where they were within the list but now I'd like to isolate those item, copy > them and place them in a separate sheet. Is there anyway to do this easily? > > Thanks! > Carol

Re: Find and Copy "Trevor Shuttleworth" <Trevor[ at ]Shucks.demon.co.uk> 25.09.2006 21:09:20 Yes Having applied the AutoFilter, choose the Custom Filter on the column and select "where the row 'contains'" and the word you are looking for. Regards Trevor "QPapillon" <QPapillon[ at ]discussions.microsoft.com> wrote in message news:306322E3-48A6-47B4-A349-7030382C3AB1[ at ]microsoft.com... [Quoted Text] > they aren't all exactly alike - but they all have a least one word in > common, > does this still apply? > > Thx! -C. > > "Trevor Shuttleworth" wrote: > >> Carol >> >> you could use AutoFilter to select the entries and then select the >> visible >> cells/rows and copy them to another sheet. >> >> Regards >> >> Trevor >> >> >> "QPapillon" <QPapillon[ at ]discussions.microsoft.com> wrote in message >> news:E62F91CB-D95B-468C-BF94-033756BA3E02[ at ]microsoft.com... >> > Good Morning, >> > >> > I have a list of over 2000 items with several columns per entry. I was >> > able >> > to use the 'find' function to find entries with a specific word in them >> > and >> > where they were within the list but now I'd like to isolate those item, >> > copy >> > them and place them in a separate sheet. Is there anyway to do this >> > easily? >> > >> > Thanks! >> > Carol >> >> >>