Re: $$Excel-Macros$$ Help needed - Extract data by customer name

2011-03-05 Thread San Pat
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

Re: $$Excel-Macros$$ Help needed - Extract data by customer name

2011-03-05 Thread pawel lupinski
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

Re: $$Excel-Macros$$ Help needed - Extract data by customer name

2011-03-05 Thread San Pat
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

Re: $$Excel-Macros$$ Help needed - Extract data by customer name

2011-03-05 Thread Jorge Marques
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

$$Excel-Macros$$ Help needed - Extract data by customer name

2011-03-04 Thread San Pat
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