How to have Sheet1 list Sheet2 rows matching text?
in [Functions]
|
From: Roger Govier on 14 May 2010 04:35 Hi Take a look at advanced Filter There are some good examples here http://www.contextures.com/xladvfilter01.html#ExtractWs -- Regards Roger Govier DevourU wrote: > I was about to do it. > Sheet1 is blank. > show only rows from sheet2 in sheet1 that have "TEXT" in column sheet2!A:A > > Actually I will want to return a few columns from the actual row, but I hope > to do that myself once I can get past this. TIA! > > "Ashish Mathur" wrote: > >> Hi, >> >> Could you give an example >> >> -- >> Regards, >> >> Ashish Mathur >> Microsoft Excel MVP >> www.ashishmathur.com >> >> "DevourU" <DevourU(a)discussions.microsoft.com> wrote in message >> news:58909FE8-DB65-4B37-B251-F907AC8D405C(a)microsoft.com... >>> I would like to have sheet1 list all rows in sheet2 matching "TEXT" in >>> column >>> sheet2,A. Big TIA! >>> >>> -JS |