software

I have a long complicated file that I use for work which I print out
everyday for the production people...they complain it has too much info
on it and want to see just what affects them. I figure a pivot table
would narrow down the info for them, but I don't know anything about
pivot tables. Can someone point me in the right direction for a intro
into pivot tables?

Thanks--
roger_home
------------------------------------------------------------------------
roger_home's Profile: www.excelforum.com/member.php...oamp;userid=16434
View this thread: www.excelforum.com/showthread...hreadid=526269I'm not sure how a pivottable would apply. Those are for creating summary
reports based on categories--totals, averages, kind of thing.

But maybe applying data|filter|autofilter
and only showing the rows that you want would work.

You could filter by date or by project or by department or by any column that
you want.

roger_home wrote:
gt;
gt; I have a long complicated file that I use for work which I print out
gt; everyday for the production people...they complain it has too much info
gt; on it and want to see just what affects them. I figure a pivot table
gt; would narrow down the info for them, but I don't know anything about
gt; pivot tables. Can someone point me in the right direction for a intro
gt; into pivot tables?
gt;
gt; Thanks
gt;
gt; --
gt; roger_home
gt; ------------------------------------------------------------------------
gt; roger_home's Profile: www.excelforum.com/member.php...oamp;userid=16434
gt; View this thread: www.excelforum.com/showthread...hreadid=526269

--

Dave Peterson

If you want to read more about pivottables...

Here are a few links:

Debra Dalgleish's pictures at Jon Peltier's site:
peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
office.microsoft.com/downloads/2000/XCrtPiv.aspx
office.microsoft.com/assistan...lconPT101.aspx

Dave Peterson wrote:
gt;
gt; I'm not sure how a pivottable would apply. Those are for creating summary
gt; reports based on categories--totals, averages, kind of thing.
gt;
gt; But maybe applying data|filter|autofilter
gt; and only showing the rows that you want would work.
gt;
gt; You could filter by date or by project or by department or by any column that
gt; you want.
gt;
gt; roger_home wrote:
gt; gt;
gt; gt; I have a long complicated file that I use for work which I print out
gt; gt; everyday for the production people...they complain it has too much info
gt; gt; on it and want to see just what affects them. I figure a pivot table
gt; gt; would narrow down the info for them, but I don't know anything about
gt; gt; pivot tables. Can someone point me in the right direction for a intro
gt; gt; into pivot tables?
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; --
gt; gt; roger_home
gt; gt; ------------------------------------------------------------------------
gt; gt; roger_home's Profile: www.excelforum.com/member.php...oamp;userid=16434
gt; gt; View this thread: www.excelforum.com/showthread...hreadid=526269
gt;
gt; --
gt;
gt; Dave Peterson

--

Dave Peterson


Dave,

You are probably right...data/filter/autofilter would probably work
better than a pivot table. Question: after selecting whole database,
how do you turn certain columns off?--
roger_home
------------------------------------------------------------------------
roger_home's Profile: www.excelforum.com/member.php...oamp;userid=16434
View this thread: www.excelforum.com/showthread...hreadid=526269I'm not sure what you mean by turn columns off.

If you want to get rid of the dropdown arrows, you'd need some code to hide
those. But this isn't really necessary. You can just ignore those dropdowns
(or use them when you need them).

If you mean how you can see the data again, you can use the each filtered
dropdown arrow and choose All. You can also use data|Filter|show all to see all
the data without going to each arrow.

If you mean not see the columns, you can always select the columns you don't
want to see and Edit|Format|column|Hide--but this isn't using autofilter.

roger_home wrote:
gt;
gt; Dave,
gt;
gt; You are probably right...data/filter/autofilter would probably work
gt; better than a pivot table. Question: after selecting whole database,
gt; how do you turn certain columns off?
gt;
gt; --
gt; roger_home
gt; ------------------------------------------------------------------------
gt; roger_home's Profile: www.excelforum.com/member.php...oamp;userid=16434
gt; View this thread: www.excelforum.com/showthread...hreadid=526269

--

Dave Peterson

www.datapigtechnologies.com has many short videos which I think are
great - Bob Umlas, Excel MVP

quot;roger_homequot; wrote:

gt;
gt; I have a long complicated file that I use for work which I print out
gt; everyday for the production people...they complain it has too much info
gt; on it and want to see just what affects them. I figure a pivot table
gt; would narrow down the info for them, but I don't know anything about
gt; pivot tables. Can someone point me in the right direction for a intro
gt; into pivot tables?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; roger_home
gt; ------------------------------------------------------------------------
gt; roger_home's Profile: www.excelforum.com/member.php...oamp;userid=16434
gt; View this thread: www.excelforum.com/showthread...hreadid=526269
gt;
gt;

There are a number of good sources. Start hewww.contextures.com/xlPivot02.html
--
Gary's Studentquot;roger_homequot; wrote:

gt;
gt; I have a long complicated file that I use for work which I print out
gt; everyday for the production people...they complain it has too much info
gt; on it and want to see just what affects them. I figure a pivot table
gt; would narrow down the info for them, but I don't know anything about
gt; pivot tables. Can someone point me in the right direction for a intro
gt; into pivot tables?
gt;
gt; Thanks
gt;
gt;
gt; --
gt; roger_home
gt; ------------------------------------------------------------------------
gt; roger_home's Profile: www.excelforum.com/member.php...oamp;userid=16434
gt; View this thread: www.excelforum.com/showthread...hreadid=526269
gt;
gt;