Hi, I'm hoping there is some way to filter across a row, as opposed to a
single column. Can this be done with autofilter? If it can, I'm not doing it
right, so please help!

Hi

Take a look at the downloadable file from Debra Dalgleish
http://www.contextures.com/AdvFilterStateNum.zip

--
Regards
Roger Govier



"a0xbjzz" wrote in message
...
Hi, I'm hoping there is some way to filter across a row, as opposed to a
single column. Can this be done with autofilter? If it can, I'm not doing
it
right, so please help!

If you mean to only show values in a row that correspond to some criteria, and hide columns, then
no, not without a macro. The best solution in that case would be to transpose your data table.

HTH,
Bernie
MS Excel MVP


"a0xbjzz" wrote in message
...
Hi, I'm hoping there is some way to filter across a row, as opposed to a
single column. Can this be done with autofilter? If it can, I'm not doing it
right, so please help!

I'm sorry - what do you mean without a macro? Sort of an idiot when it comes
to excel!! How would I do this?

"Bernie Deitrick" wrote:

If you mean to only show values in a row that correspond to some criteria, and hide columns, then
no, not without a macro. The best solution in that case would be to transpose your data table.

HTH,
Bernie
MS Excel MVP


"a0xbjzz" wrote in message
...
Hi, I'm hoping there is some way to filter across a row, as opposed to a
single column. Can this be done with autofilter? If it can, I'm not doing it
right, so please help!

I mean that you need to use a macro to hide columns based on values in a
row - unlike hiding rows based on values in a column, which is built-in. A
macro is computer code that tells Excel what to do - you can do almost
anything - but I'm not clear on exactly what you want to do.

Post a short example of what you have, and what you want, and we can go from
there.

HTH,
Bernie
MS Excel MVP


"a0xbjzz" wrote in message
...
I'm sorry - what do you mean without a macro? Sort of an idiot when it
comes
to excel!! How would I do this?

"Bernie Deitrick" wrote:

If you mean to only show values in a row that correspond to some
criteria, and hide columns, then
no, not without a macro. The best solution in that case would be to
transpose your data table.

HTH,
Bernie
MS Excel MVP


"a0xbjzz" wrote in message
...
Hi, I'm hoping there is some way to filter across a row, as opposed to
a
single column. Can this be done with autofilter? If it can, I'm not
doing it
right, so please help!

Ah! I see you have posted twice. Please do not do this as it fragments
any responses you might get and wastes respondents' time. My answer
(elsewhere) is similar to those you have received here.

Pete

On Nov 9, 6:53 pm, a0xbjzz wrote:
Hi, I'm hoping there is some way to filter across a row, as opposed to a
single column. Can this be done with autofilter? If it can, I'm not doing it
right, so please help!