Worksheet change event - filter table

JumboCactuar

Well-known Member
Joined
Nov 16, 2016
Messages
696
Hi,
ive seen this code before posted in here but cant seem to find it.

I have a table with headers in Row 5.

In Row 3 i want to use these cells for filtering the corresponding column.

Example if entering "green" in C3 then the table will be filtered automatically, then when C3 is cleared the filter is also cleared.

Does anyone use anything like this ?

Appreciate any help
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

JumboCactuar

Well-known Member
Joined
Nov 16, 2016
Messages
696
like:

 

Watch MrExcel Video

Forum statistics

Threads
1,108,789
Messages
5,524,885
Members
409,609
Latest member
Channingz

This Week's Hot Topics

Top