Filtering Multiple Columns

**JOGIER** · 01-28-2008, 05:03 PM

I am trying to filter three columns of data to a given range without having to using auto filter on each column. I would like to have a Macro or Control Button or something easier than picking each set of data each time I want to filter.

Attached is a sample file.

I am not well versed in Excel and this is my first post so please bear with me in this process.

**VBA Noob** · 01-28-2008, 05:08 PM

No attachment

VBA Noob

**dominicb** · 01-28-2008, 05:09 PM

Good evening JOGIER

...and welcome to the forum!!

Originally Posted by JOGIER

I would like to have a Macro or Control Button or something easier than picking each set of data each time I want to filter.

You could have a control button or macro if you wanted, however, the easiest thing to do is set up the filters how you like them, and go to View > Custom Views, Add and set up a new view. Next time you want to recreate the filters go to View > Custom, select the view and click Show.

It's easier for you to play with this feature and decide if it's for you than it is for me to explain it in detail so just have a play...

HTH

DominicB

**JOGIER** · 01-28-2008, 05:17 PM

You folks are scary! I trying to figure out how to attach this file and I've got 2 replies to my question.

First how do I get a zipped file from the Manage attachments window to this thread?

**davesexcel** · 01-28-2008, 05:22 PM

Originally Posted by JOGIER

You folks are scary! I trying to figure out how to attach this file and I've got 2 replies to my question.

First how do I get a zipped file from the Manage attachments window to this thread?

Goto mycomputer,
find the file ,right click on it and select send to,
compressed folder,
there it's zipped
goto attach file
browse
find your zipped file and attach it, select upload then close the attach window and you are back to your thread, say "here it is"
then submit reply

**JOGIER** · 01-28-2008, 05:41 PM

I was trying to attach the file before it was recognised by the software.

Anyhow, (If it worked this time) the file should explain more clearly what I am trying to do.

Thanks.

JIm O

ATTACH]18245[/ATTACH]

**davesexcel** · 01-28-2008, 05:43 PM

Originally Posted by JOGIER

I was trying to attach the file before it was recognised by the software.

Anyhow, (If it worked this time) the file should explain more clearly what I am trying to do.

Thanks.

JIm O

ATTACH]18245[/ATTACH]

Did you follow my instructions?
the attach is the paperclip icon

**davesexcel** · 01-28-2008, 05:13 PM

Originally Posted by JOGIER

I am trying to filter three columns of data to a given range without having to using auto filter on each column. I would like to have a Macro or Control Button or something easier than picking each set of data each time I want to filter.

Attached is a sample file.

I am not well versed in Excel and this is my first post so please bear with me in this process.

Sample Needs to be zipped,
Here's a sample
http://www.excelforum.com/attachment...8&d=1199028795
here's the thread
http://www.excelforum.com/showthread.php?t=628193

**davesexcel** · 02-09-2008, 05:30 PM

This is the directions from the workbook

Goal
Filter columns D,E & F (Row 14 on)
Based on value range in D11 thru F12
Post first six results in A2 thru F7
Restore list as is
Be able to edit or add to list as necessary

I am done with this post