Sorting data from Master Sheet

[L C]

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]

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