I want to enable filtering on multiple columns but they are not adjacent to
each other. Is there a way to achieve this in VB?

Also I would like to filer a column (B) but the information within the
column is grouped to other columns ( D & E). Is there a way to maintain the
information of the group when filtering in one column?
Column B Column D Column E
Row2 Apples
Row3 abc def
Row4 123 456
Row5 ghi jkl
Row6 789 012
Row7 Pears
Row8 wer dgh
Row9 236 245
Row10 dfj sdi
Row11 640 084

Thanks