G'day,

I have been told that you can filter multiple columns. For example, if in
column A I have facilities listed, and in column B days are listed, you can
filter seprately. Meaning that I should not have to list each facility for
each day when I filter. I would like to have up to 15 different filters in
the same worksheet if possible.

My questions is, "How do you do this...?"

Thanks

Just highlight the top row of the data and go to DataFilterAutofilter and
then filter each column you need using the drop down arrows at the top

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Hickeym" wrote in message
...
G'day,

I have been told that you can filter multiple columns. For example, if in
column A I have facilities listed, and in column B days are listed, you
can
filter seprately. Meaning that I should not have to list each facility
for
each day when I filter. I would like to have up to 15 different filters
in
the same worksheet if possible.

My questions is, "How do you do this...?"

Thanks

Nick,

Maybe it is the version I am using, Excel 202 SP3, but I can only filter all
columns or none. It does not allow me to filter each column individually.
Any suggestions?

"Nick Hodge" wrote:

Just highlight the top row of the data and go to DataFilterAutofilter and
then filter each column you need using the drop down arrows at the top

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Hickeym" wrote in message
...
G'day,

I have been told that you can filter multiple columns. For example, if in
column A I have facilities listed, and in column B days are listed, you
can
filter seprately. Meaning that I should not have to list each facility
for
each day when I filter. I would like to have up to 15 different filters
in
the same worksheet if possible.

My questions is, "How do you do this...?"

Thanks

You get one range to filter per worksheet.

But that range can have multiple columns.

Turn of the autofilter (to start fresh)

Select your range to filter--(say A1:X9999)

Then apply data|Filter|autofilter.

You'll see dropdown arrows in the top row of that selected area of each cell.

Hickeym wrote:

Nick,

Maybe it is the version I am using, Excel 202 SP3, but I can only filter all
columns or none. It does not allow me to filter each column individually.
Any suggestions?

"Nick Hodge" wrote:

Just highlight the top row of the data and go to DataFilterAutofilter and
then filter each column you need using the drop down arrows at the top

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Hickeym" wrote in message
...
G'day,

I have been told that you can filter multiple columns. For example, if in
column A I have facilities listed, and in column B days are listed, you
can
filter seprately. Meaning that I should not have to list each facility
for
each day when I filter. I would like to have up to 15 different filters
in
the same worksheet if possible.

My questions is, "How do you do this...?"

Thanks




--

Dave Peterson

Dave,

Thanks for the input. I guess this can't be done the way I was hoping. I
was hoping to be able to filter multiple times in the same worksheet in
different columns.

"Dave Peterson" wrote:

You get one range to filter per worksheet.

But that range can have multiple columns.

Turn of the autofilter (to start fresh)

Select your range to filter--(say A1:X9999)

Then apply data|Filter|autofilter.

You'll see dropdown arrows in the top row of that selected area of each cell.

Hickeym wrote:

Nick,

Maybe it is the version I am using, Excel 202 SP3, but I can only filter all
columns or none. It does not allow me to filter each column individually.
Any suggestions?

"Nick Hodge" wrote:

Just highlight the top row of the data and go to DataFilterAutofilter and
then filter each column you need using the drop down arrows at the top

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Hickeym" wrote in message
...
G'day,

I have been told that you can filter multiple columns. For example, if in
column A I have facilities listed, and in column B days are listed, you
can
filter seprately. Meaning that I should not have to list each facility
for
each day when I filter. I would like to have up to 15 different filters
in
the same worksheet if possible.

My questions is, "How do you do this...?"

Thanks




--

Dave Peterson

If/when you upgrade to xl2003, you might be able to use Data|List to give the
effect that you want.

Hickeym wrote:

Dave,

Thanks for the input. I guess this can't be done the way I was hoping. I
was hoping to be able to filter multiple times in the same worksheet in
different columns.

"Dave Peterson" wrote:

You get one range to filter per worksheet.

But that range can have multiple columns.

Turn of the autofilter (to start fresh)

Select your range to filter--(say A1:X9999)

Then apply data|Filter|autofilter.

You'll see dropdown arrows in the top row of that selected area of each cell.

Hickeym wrote:

Nick,

Maybe it is the version I am using, Excel 202 SP3, but I can only filter all
columns or none. It does not allow me to filter each column individually.
Any suggestions?

"Nick Hodge" wrote:

Just highlight the top row of the data and go to DataFilterAutofilter and
then filter each column you need using the drop down arrows at the top

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Hickeym" wrote in message
...
G'day,

I have been told that you can filter multiple columns. For example, if in
column A I have facilities listed, and in column B days are listed, you
can
filter seprately. Meaning that I should not have to list each facility
for
each day when I filter. I would like to have up to 15 different filters
in
the same worksheet if possible.

My questions is, "How do you do this...?"

Thanks




--

Dave Peterson


--

Dave Peterson

Thank you again - I will look into Excell 2003.

"Dave Peterson" wrote:

If/when you upgrade to xl2003, you might be able to use Data|List to give the
effect that you want.

Hickeym wrote:

Dave,

Thanks for the input. I guess this can't be done the way I was hoping. I
was hoping to be able to filter multiple times in the same worksheet in
different columns.

"Dave Peterson" wrote:

You get one range to filter per worksheet.

But that range can have multiple columns.

Turn of the autofilter (to start fresh)

Select your range to filter--(say A1:X9999)

Then apply data|Filter|autofilter.

You'll see dropdown arrows in the top row of that selected area of each cell.

Hickeym wrote:

Nick,

Maybe it is the version I am using, Excel 202 SP3, but I can only filter all
columns or none. It does not allow me to filter each column individually.
Any suggestions?

"Nick Hodge" wrote:

Just highlight the top row of the data and go to DataFilterAutofilter and
then filter each column you need using the drop down arrows at the top

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Hickeym" wrote in message
...
G'day,

I have been told that you can filter multiple columns. For example, if in
column A I have facilities listed, and in column B days are listed, you
can
filter seprately. Meaning that I should not have to list each facility
for
each day when I filter. I would like to have up to 15 different filters
in
the same worksheet if possible.

My questions is, "How do you do this...?"

Thanks




--

Dave Peterson


--

Dave Peterson

Dave

Well spotted

Nick

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Dave Peterson" wrote in message
...
You get one range to filter per worksheet.

But that range can have multiple columns.

Turn of the autofilter (to start fresh)

Select your range to filter--(say A1:X9999)

Then apply data|Filter|autofilter.

You'll see dropdown arrows in the top row of that selected area of each
cell.

Hickeym wrote:

Nick,

Maybe it is the version I am using, Excel 202 SP3, but I can only filter
all
columns or none. It does not allow me to filter each column
individually.
Any suggestions?

"Nick Hodge" wrote:

Just highlight the top row of the data and go to DataFilterAutofilter
and
then filter each column you need using the drop down arrows at the top

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Hickeym" wrote in message
...
G'day,

I have been told that you can filter multiple columns. For example,
if in
column A I have facilities listed, and in column B days are listed,
you
can
filter seprately. Meaning that I should not have to list each
facility
for
each day when I filter. I would like to have up to 15 different
filters
in
the same worksheet if possible.

My questions is, "How do you do this...?"

Thanks




--

Dave Peterson

The macro works for me in hiding unwanted filter arrows, but when I use a
filter I'm getting a few columns from the bottom of my spreadsheet in the
results, even though they don't contain the filter criteria.
Is this a range issue in my auto filters?

"Hickeym" wrote:

Thank you again - I will look into Excell 2003.

"Dave Peterson" wrote:

If/when you upgrade to xl2003, you might be able to use Data|List to give the
effect that you want.

Hickeym wrote:

Dave,

Thanks for the input. I guess this can't be done the way I was hoping. I
was hoping to be able to filter multiple times in the same worksheet in
different columns.

"Dave Peterson" wrote:

You get one range to filter per worksheet.

But that range can have multiple columns.

Turn of the autofilter (to start fresh)

Select your range to filter--(say A1:X9999)

Then apply data|Filter|autofilter.

You'll see dropdown arrows in the top row of that selected area of each cell.

Hickeym wrote:

Nick,

Maybe it is the version I am using, Excel 202 SP3, but I can only filter all
columns or none. It does not allow me to filter each column individually.
Any suggestions?

"Nick Hodge" wrote:

Just highlight the top row of the data and go to DataFilterAutofilter and
then filter each column you need using the drop down arrows at the top

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Hickeym" wrote in message
...
G'day,

I have been told that you can filter multiple columns. For example, if in
column A I have facilities listed, and in column B days are listed, you
can
filter seprately. Meaning that I should not have to list each facility
for
each day when I filter. I would like to have up to 15 different filters
in
the same worksheet if possible.

My questions is, "How do you do this...?"

Thanks




--

Dave Peterson


--

Dave Peterson

I don't see any macro code in the quoted text.

But if you're getting rows that aren't being filtered, I'd guess that your
filtered range doesn't include those rows.

Remove the filter (data|filter|autofilter)
Then select all the range first--don't let excel guess at the range.

Then do data|filter|autofilter and try it once more.

youngster wrote:

The macro works for me in hiding unwanted filter arrows, but when I use a
filter I'm getting a few columns from the bottom of my spreadsheet in the
results, even though they don't contain the filter criteria.
Is this a range issue in my auto filters?

"Hickeym" wrote:

Thank you again - I will look into Excell 2003.

"Dave Peterson" wrote:

If/when you upgrade to xl2003, you might be able to use Data|List to give the
effect that you want.

Hickeym wrote:

Dave,

Thanks for the input. I guess this can't be done the way I was hoping. I
was hoping to be able to filter multiple times in the same worksheet in
different columns.

"Dave Peterson" wrote:

You get one range to filter per worksheet.

But that range can have multiple columns.

Turn of the autofilter (to start fresh)

Select your range to filter--(say A1:X9999)

Then apply data|Filter|autofilter.

You'll see dropdown arrows in the top row of that selected area of each cell.

Hickeym wrote:

Nick,

Maybe it is the version I am using, Excel 202 SP3, but I can only filter all
columns or none. It does not allow me to filter each column individually.
Any suggestions?

"Nick Hodge" wrote:

Just highlight the top row of the data and go to DataFilterAutofilter and
then filter each column you need using the drop down arrows at the top

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Hickeym" wrote in message
...
G'day,

I have been told that you can filter multiple columns. For example, if in
column A I have facilities listed, and in column B days are listed, you
can
filter seprately. Meaning that I should not have to list each facility
for
each day when I filter. I would like to have up to 15 different filters
in
the same worksheet if possible.

My questions is, "How do you do this...?"

Thanks




--

Dave Peterson


--

Dave Peterson


--

Dave Peterson