Thread: After made a filter selection, hide to select visible rows based onthe registration in the visible cell related to the visible row above
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default After made a filter selection, hide to select visible rows based on the registration in the visible cell related to the visible row above
Hi Johan,

Am Wed, 1 Jan 2020 03:56:12 -0800 (PST) schrieb JS SL:

It should be nice if the part "data-B" can refer to 'Sheet2, ColumnA' where standing a few keywords in A2, A3, A4, etc..
For the part < it should look in those sheet/column and only fullfill the code for HideRow if the text in column N isn't in Sheet2/ColumnA.
On this way it make it flexible to hide rows based on several written codes in the other sheet.

do you filter for all entries in sheet2 column A? Or only for one of
these entries?


Regards
Claus B.
--
Windows10
Office 2016
Reply With QuoteReply With Quote