Want to filter data columnwise
i.e from Column A1

With Rdgs.
Sudipta

You can't filter rows. You can transpose your worksheet using
pastespecial to switch rows and columns. There is no problems doing
this with 2007 but witth 2003 you are limited to 256 columns. so if
your original worksheet has less than 256 row with 2003 you can tranpose
the sheett, otherwise, you can't.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=182901

Microsoft Office Help

Hi,

There's no inbuilt way of doing that but you could try this method

http://blog.livedoor.jp/andrewe/archives/50283818.html
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Sudipta Sen" wrote:

Want to filter data columnwise
i.e from Column A1

With Rdgs.
Sudipta

Hi
Pivot Tables can be viewed as a horizontal filter. They are easy to
set up - see the help.
regards
Paul

On Feb 26, 11:14*am, Sudipta Sen
wrote:
Want to filter data columnwise
i.e from Column A1

With Rdgs.
Sudipta