Re: Data Summary

Can we do the summary by defining a macro?

The difficulty with the suggested solution :
1.I am not able to advance filter the unique data to a separate
sheet.
2.Every day the data gets changed, so have to repeat the exercise
daily and is very time consuming.

Regards,

Jimmy Joseph



Subject: Re: Data Summary
From: "Ardus Petus" <(E-Mail Removed)>
Newsgroups: microsoft.public.excel

In summary sheet, you can get the totals with a formula like:
=SUMIF(Products!$C$2:$C$7,A2,Products!$A$2:$A$7)
See example: http://cjoint.com/?fmkJhzVi8q

To automate the production of parts lists in Summary, you can use
Data>Filter>Advanced filter to take out dupes.

HTH
--
AP