Using VBA code to auto filter ?

**AnthonyWB** · 04-26-2010, 02:20 PM

Hello everyone. I am currently trying to use VBA code to auto filter for some data. The code can be found below. I am however getting an error. According to the intermediate window I have an "expected expression" error. Any help would be greatly appreciated.

Please Login or Register  to view this content.

**royUK** · 04-26-2010, 02:27 PM

Looks like you have 3 criteria,you shouldonly have two

**AnthonyWB** · 04-26-2010, 02:46 PM

royUK,

I actualy need four criteria to be set. I have set Field to equal 2, since that is the column in which the criteria needs to be filtered.

Please Login or Register  to view this content.

**royUK** · 04-26-2010, 03:16 PM

two Criteria is the maximum,I believe

**AnthonyWB** · 04-26-2010, 03:28 PM

Yep you are right, Any suggestions on how I can Filter or extract data from the spreadsheet based on multiple columns and several creiteria?

**royUK** · 04-26-2010, 03:31 PM

Basically as you would manually. Filter the data by one column, then filter by another or maybe you could use a Pivottable

**AnthonyWB** · 04-26-2010, 03:38 PM

Thanks Roy,

Where do I start in terms of VBA Code and pivot tables, since I woul d want to avoid this manually?

**royUK** · 04-26-2010, 03:40 PM

You need to attach an example workbook,without seeing your data layout & expected results it's all guess work

**AnthonyWB** · 04-26-2010, 03:43 PM

Before we bang-out code, after creating the pivot table can we use VBA to request a data sheet of that particular pivot and save it to a specific file?