Excel Grouping

  • Thread starter Thread starter Michael Adeeb
  • Start date Start date
M

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.
 
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.
 
A paper on grouping worksheets? What kind of school are you going to?

Worksheets are grouped within workbooks.


Cortney said:
I still don't understand how to group worksheets. I need to know how to
Click to expand...
do this because I have to turn in a paper for class, and part of this
assignment is group worksheets. Please help me.
 
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
 
Back
Top