Hi

I have a sheet with names scrambled in sheet1.column A down. column B down
dates, C down items bought, d down price per item.

I want to hit a button and have it summarised on sheet 2. for example...

Emp1 29/12/09 pie 12.50
emp2 2912/09 juice 4.50
emp1 30/12/09 cake 9.50
emp3 27/12/09 fruit 10.50
emp1 25/12/09 pie 12.50
emp1 30/12/09 cake 9.50
emp1 29/12/09 juice 4.50



the summary should look like this

emp1 25/12/09 pie 1 12.50
29/12/09 pie 1 12.50
juice 1 4.50
30/12/09 cake 2 19.00

emp2 29/12/09 juice 1 4.50

emp3 27/12/09 fruit 1 10.50


--
Helpful advice on posting to newsgroups here...
http://www.cpearson.com/excel/newposte.htm

Hello,

If you do not want to use a pivot table I suggest to use one of my
UDFs Pfreq (together with Sfreq) or Pstat:
http://sulprobil.com/html/listfreq.html

Regards,
Bernd

Do you want to perform this with a pivot table, or is there something else
you need to do ?

--
If the post is helpful, please consider donating something to an animal
charity on my behalf.


"pswanie" wrote:

> Hi
>
> I have a sheet with names scrambled in sheet1.column A down. column B down
> dates, C down items bought, d down price per item.
>
> I want to hit a button and have it summarised on sheet 2. for example...
>
> Emp1 29/12/09 pie 12.50
> emp2 2912/09 juice 4.50
> emp1 30/12/09 cake 9.50
> emp3 27/12/09 fruit 10.50
> emp1 25/12/09 pie 12.50
> emp1 30/12/09 cake 9.50
> emp1 29/12/09 juice 4.50
>
>
>
> the summary should look like this
>
> emp1 25/12/09 pie 1 12.50
> 29/12/09 pie 1 12.50
> juice 1 4.50
> 30/12/09 cake 2 19.00
>
> emp2 29/12/09 juice 1 4.50
>
> emp3 27/12/09 fruit 1 10.50
>
>
> --
> Helpful advice on posting to newsgroups here...
> http://www.cpearson.com/excel/newposte.htm