Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #108175

Re: A LOOKUP, FIND or SEARCH method perhaps Auto Filter or InputBox

Show all headers | View raw

Hi Howard,

Am Sun, 22 Nov 2015 12:57:45 -0800 (PST) schrieb L. Howard:

> Say the sheet has these headers, with maybe 100 - 150 + or so rows of data. 
> 
> PO_No. Invoice Page Line Ref Description Qty  (Column A - G)
> 
> Users will not be trusted to use Auto Filter from the sheet to do the following.
> 
> A user has Invoice, Line & Qty info.  Find all rows that match those three criteria, return Entire Row Data to sheet 2.  Where Entire Row Data is from column A to G.
> 
> Next user has Invoice, Ref, Description & Qty.  Now find/return all rows that match those four items to sheet 2. (Below last entry)
> 
> A user has only the Invoice.  Return all rows with a Invoice value.
> 
> Can code work with a variable number of "Filter By" choices, especially with choices that will be different almost every time as well as the number of header choices?
> 
> Or an InputBox would be okay for the users.  I think the order of the headers and the order of the data to the InputBox is not really important, right?

that is a case for a advanced filter. Create the criteria range on
sheet2. And with Worksheet_Change Event you can fire this filter when
users enter the criteria into the criteria range.


Regards
Claus B.
-- 
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

A  LOOKUP, FIND or SEARCH method perhaps Auto Filter or InputBox "L. Howard" <lhkittle@comcast.net> - 2015-11-22 12:57 -0800
  Re: A  LOOKUP, FIND or SEARCH method perhaps Auto Filter or InputBox Claus Busch <claus_busch@t-online.de> - 2015-11-23 07:34 +0100
  Re: A  LOOKUP, FIND or SEARCH method perhaps Auto Filter or InputBox GS <gs@v.invalid> - 2015-11-23 12:29 -0500
    Re: A  LOOKUP, FIND or SEARCH method perhaps Auto Filter or InputBox "L. Howard" <lhkittle@comcast.net> - 2015-11-23 16:23 -0800
      Re: A  LOOKUP, FIND or SEARCH method perhaps Auto Filter or InputBox GS <gs@v.invalid> - 2015-11-23 19:30 -0500
        Re: A  LOOKUP, FIND or SEARCH method perhaps Auto Filter or InputBox "L. Howard" <lhkittle@comcast.net> - 2015-11-23 17:19 -0800
          Re: A  LOOKUP, FIND or SEARCH method perhaps Auto Filter or InputBox GS <gs@v.invalid> - 2015-11-23 20:30 -0500
            Re: A  LOOKUP, FIND or SEARCH method perhaps Auto Filter or InputBox Claus Busch <claus_busch@t-online.de> - 2015-11-24 19:58 +0100
              Re: A  LOOKUP, FIND or SEARCH method perhaps Auto Filter or InputBox GS <gs@v.invalid> - 2015-11-25 10:45 -0500
                Re: A  LOOKUP, FIND or SEARCH method perhaps Auto Filter or InputBox Claus Busch <claus_busch@t-online.de> - 2015-11-25 16:49 +0100
                Re: A  LOOKUP, FIND or SEARCH method perhaps Auto Filter or InputBox GS <gs@v.invalid> - 2015-11-25 10:58 -0500
                Re: A  LOOKUP, FIND or SEARCH method perhaps Auto Filter or InputBox Claus Busch <claus_busch@t-online.de> - 2015-11-25 17:02 +0100

csiph-web