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
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
To: excel-macros
Sent: Sat, March 5, 2011 2:28:42 AM
Subject: $$Excel-Macros$$ Help needed - Extract da
Yes, but I am trying implement this by macro not pivot table.
Regards,
San
On Sat, Mar 5, 2011 at 4:52 AM, Jorge Marques wrote:
> You want to pass the values to sheet2 like it is in there right A Total
> etc and then each time there´s a new costumer besides the one that are
> there already th
You want to pass the values to sheet2 like it is in there right A Total etc
and then each time there´s a new costumer besides the one that are there
already there, it automatically inserts the new costumer in sheet2 with
same criterias?
2011/3/5 San Pat
> Hi Friends,
>
> I have row data in th
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.
Whe