Hello,
I am sure this has been asked before, but I can't find an answer. My
searches have been dead ends so far.
I want to take data from a master sheet and have it sorted on different
sheet. I would also like to have titles as well.
I have a small example of what I want to do below.
Can someone please point me in the right direction
Thank you
Larry C
Example:
Master Sheet
A B C
May Start Inventory 5/1/07
May Start Records 5/1/07
June Start Reviews 6/15/07
July Review Pay Scales 6/23/07
Sorted Sheet
MAY
Start Inventory 5/1/07
Start Records 5/1/07
JUNE
Start Reviews 6/15/07
JULY
Review Pay Scales 6/23/07
Roger Govier - 30 Apr 2007 21:53 GMT
Hi Larry
You could apply an autofilter to your data and just show the records for
each relevant month.
Alternatively, you could use Advanced Filter to pull data for the
relevant month to another sheet.
For more help on both of these functions, take a look at Debra
Dalgleish's site
http://www.contextures.com/xlautofilter01.html
http://www.contextures.com/xladvfilter01.html#ExtractWs

Signature
Regards
Roger Govier
> Hello,
>
[quoted text clipped - 31 lines]
> JULY
> Review Pay Scales 6/23/07