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!