Sort Daily Staff sales into Sales BY PERSON for month?

[Amber A.]

I need to sort a daily Excel Sales Tracker with columns (Name, Customers,
Sales, Sales Value, Average Sale, Sale Conversion) into Sheets per name for
the month.

Example Each page report has Employee A, B, C, D (175 of them) per day going
down the page. (one sheet per day. I need to be able to pull some of them
out by name for total sales for month without copy and pasting 30 lines into
a new document for each person (Jan 1st, 2nd, 3rd, 4th etc per person).

There has to be a way to do this, yet I upgraded to Ultimate Office 2007 and
am having trouble finding even the simple things I used to do by habit.

Any ideas?

The new Worksheet can be literal copy and paste with the data, I can even re
make the formulas... I just need the people to get split.

Thanks!!

 

[CLR]

Personally, I would re-arrange things so that I only had one database for the
entire month......(30days x 175employees = 5250 rows, not too
large).........and use the Data > Filter > Autofilter to create the
reports.....and for lots of other nifty analysis as well.........

Vaya con Dios,
Chuck, CABGx3

 

[Herbert Seidenberg]

Here is an example of Pivot Table
summarizing a week's worth of sheets.
Notice that Page is dragged into ROW
where you can click on the desired days.
http://www.freefilehosting.net/download/3adld