Hi Pawel,

Thanks for your hlep.

But this is not exactly what I wanted. The extracted data should
automatically updated when I enter new data in sheet1.

I think it can be done using pivot table but i would like to implement this
using vba.

Regards,
San

On Sat, Mar 5, 2011 at 12:11 PM, pawel lupinski <lupins...@yahoo.com> wrote:

> Hi Mate,
>
> See attachement I've done it in two ways. First by PIVOT TABLE, second by
> function. Try if it helps.
>
> Regards,
> Pawel
>
>
> ------------------------------
> *From:* San Pat <myitems2...@gmail.com>
> *To:* excel-macros <excel-macros@googlegroups.com>
> *Sent:* Sat, March 5, 2011 2:28:42 AM
> *Subject:* $$Excel-Macros$$ Help needed - Extract data by customer name
>
> Hi Friends,
>
> I have row data in the sheet1, which contains multiple data entries for the
> same customer.
>
> I am trying to extract each customer data in separate sheet (Extract_Data)
> and at the same time calculating the average price & sum of the total
> quantity shipped to the particular customer.
>
> When I enter any new data in the sheet1, Extract_Data sheet should update
> automatically. If there is a new customer entry than also the extract data
> sheet should get update automatically with the new customer data.
>
> I have attached the reference sheet.
>
> Regards,
>
>
>
>  --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
>  --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Reply via email to