Thread: Summary page
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sevans sevans is offline
external usenet poster
 
Posts: 2
Default Summary page

I am a GM of a restaurant with basic Excel knowledge. Every month I create a
workbook which contains an worksheet for each week. I use this workbook to
track my foodserver's performance in various categories. Each worksheet has
the same order and format as the other weeks - the only difference being the
performance data of the servers. I want to add is a 5th worksheet that
summarizes my Monthly Top 10 and Bottom 10 servers within the various
categories that I am tracking. I would like to print and post this summary
page for the server's reference with each category on the page looking
similar to the following...

TOP 10 in SALES BOTTOM 10 in SALES
1. Amy Smith $7,500 1. Amber Bates $2,200
2. Joe Parker $7,120 2. Mary Wright $2,367
3. etc 3. etc