Excel Grouping

[Michael Adeeb]

Hello,

I am new to excel, here is what I am trying to do. I
have a worksheet that is used for entering certain data
each day. I want to have an option, that will let me
group by date. For example almost every other day there
is an entry by date. So after a couple of months, I want
to be able to setup an option, that will go find the data
entered for December and output it to a sheet or a table
or something. But I haven't been able to find an option
that will let me group by date. I don't want to go
manually and select the data. I want to have an
automatic process, that will keep track of the data for
each month. I hope this could make sense to someone and
that it is doable. Thanks.

 

[Dave R.]

Michael, just select your range (headers included), go to DATA>FILTER>AUTO
FILTER

then use the pulldown above your date column, select CUSTOM

and enter on the top;

greater than or equal to: 3/1/2004

... and the bottom
less than : 4/1/2004

to show the ones only in Mar 2004.

 

[Dave R.]

A paper on grouping worksheets? What kind of school are you going to?

Worksheets are grouped within workbooks.

I still don't understand how to group worksheets. I need to know how to

do this because I have to turn in a paper for class, and part of this
assignment is group worksheets. Please help me.

 

[Gord Dibben]

Michael

Check out help on Data>Filter>Auto Filter to pull out "groups" of items by
month.

Also check out help on Pivot Tables.

http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html

Gord Dibben Excel MVP

 

[Gord Dibben]

Cortney

Right-click on a sheet tab and "select all sheets".

OR select one sheet then CRTL + Click on others to group them.

OR select first sheet and SHIFT + Click to select all sheets between first
sheet and and the SHIFT + Clicked sheet.

DO NOT FORGET to ungroup them when done. What you do to one sheet is done to
all in the group.

Gord Dibben Excel MVP