Filter by Column Selection

[adamsm]

Hi,

How could I write a macro code that would filter the sheet by the column header in cell E4.

My column headers are in row 10. Data starts from row 11.

The data columns of the sheet starts from column C to column K.

Name of the Column headers are ID(In column E) Name (In Column F) Address(In Column G) and Customer Location (In Column K).

Lets say for example the user types Name is cell E4 and types' adamsm in cell E5, the sheet filters the value from column F.

I hope I've made my question clear.

Any help on this would be appreciated.

 

[Armando Montes]

Turn on the macro recorder, apply the filters, turn off the recorder and you will get the basic code.
http://office.microsoft.com/en-us/h...re-and-why-to-use-them-HA010007210.aspx?CTT=1

 

[adamsm]

Thanks for the help.