sorting
in [General]
|
From: Still Learning on 4 May 2010 15:09 Is there a way to search an entire workbook for keywords and return the entire row? The same as "sort" does on one page, just across the whole workbook.
From: Bob Umlas, Excel MVP on 4 May 2010 15:17 Right-click on a sheet tab and select "Select All Sheets", then a regular Find command will search thru all the sheets. Not sure what you mean by "return the entire row", tho. "Still Learning" wrote: > Is there a way to search an entire workbook for keywords and return the > entire row? The same as "sort" does on one page, just across the whole > workbook.
From: Gord Dibben on 4 May 2010 15:27 Sort does not search. Did you mean same as Filter? You cannot filter across worksheets You can search across sheets in a workbook. What is "entire row" and to where you like your found data returned? Gord Dibben MS Excel MVP On Tue, 4 May 2010 12:09:01 -0700, Still Learning <StillLearning(a)discussions.microsoft.com> wrote: >Is there a way to search an entire workbook for keywords and return the >entire row? The same as "sort" does on one page, just across the whole >workbook.
|
Pages: 1 Prev: rows to repeat at 'Bottom' Next: How do you do the following using VBA macro automatically? |