How do I :

[benrussell]

I want to put my company's weekly sales on one sheet. Then in that book on each additional sheet break up the the total sales by employee. I don't want to sum the sales up per employee, I want to list them out for their weekly pay vouchers.

What functions do I want? How do I do this? Is there a template I could find somewhere?

Thank-you!!!
Ben Russell

[Myrna Larson]

You could do that with Data/Filter/Advanced, with the criteria range on the
employee's sheet (probably outside the print area), and the destination range
on the employee's sheet.

But you would have to do this manually, each week.

Read Help on Advanced Filter if this sounds like a workable solution.

Otherwise, if you want it automated, you may need a VBA macro.

On Fri, 30 Sep 2005 20:51:58 -0500, benrussell
<benrussell.1w7aua_1128132323.1717@excelforum-nospam.com> wrote:

>
>I want to put my company's weekly sales on one sheet. Then in that book
>on each additional sheet break up the the total sales by employee. I
>don't want to sum the sales up per employee, I want to list them out
>for their weekly pay vouchers.
>
>What functions do I want? How do I do this? Is there a template I
>could find somewhere?
>
>Thank-you!!!
>Ben Russell