Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / April 2007

Tip: Looking for answers? Try searching our database.

Sorting data from Master Sheet

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
L C - 30 Apr 2007 21:06 GMT
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

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.