Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

2012-03-05 Thread Jorge Marques
Marques leote.w...@gmail.com *Sent:* Wednesday, February 29, 2012 5:11 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting Sorry my friends for writting again in the post, it just that i understood this code, the only thing i

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

2012-02-29 Thread Jorge Marques
:* Jorge Marques leote.w...@gmail.com *Sent:* Wednesday, February 22, 2012 10:00 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting Hi, Aamir Shahzad was option was good, but it suited me for doing another thing in another

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

2012-02-29 Thread Sam Mathai Chacko
*To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting Hi, Aamir Shahzad was option was good, but it suited me for doing another thing in another report, but i needed in a macro format in order to delete the data whenever i pull

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

2012-02-29 Thread ChilExcel
dguille...@gmail.com *From:* Jorge Marques leote.w...@gmail.com *Sent:* Wednesday, February 22, 2012 10:00 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting Hi, Aamir Shahzad was option was good, but it suited me

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

2012-02-29 Thread Jorge Marques
@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting Hi, Aamir Shahzad was option was good, but it suited me for doing another thing in another report, but i needed in a macro format in order to delete the data whenever i pull a report, dguillett1

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

2012-02-29 Thread dguillett1
Guillett SalesAid Software dguille...@gmail.com From: Jorge Marques Sent: Wednesday, February 22, 2012 10:00 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting Hi, Aamir Shahzad was option was good, but it suited me

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

2012-02-22 Thread dguillett1
Glad to help Don Guillett SalesAid Software dguille...@gmail.com From: Jorge Marques Sent: Wednesday, February 22, 2012 10:00 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting Hi, Aamir Shahzad was option was good

$$Excel-Macros$$ Help on gathering duplicate summing and counting

2012-02-20 Thread Jorge Marques
Hi friends, i have a problem, 1. i trying to use a report and i have to sum the column H, G, F, if the orders numbers are equal and 2. leave the information in column B,C,D, gathered. 3. The problem is that i was doing it with formulas, but didn´t have a dinamic range that´s the first, 4. then the

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

2012-02-20 Thread Aamir Shahzad
Dear Jorge, See the third table in attached sheet. Aamir Shahzad On Mon, Feb 20, 2012 at 9:30 PM, Jorge Marques leote.w...@gmail.com wrote: Hi friends, i have a problem, 1. i trying to use a report and i have to sum the column H, G, F, if the orders numbers are equal and 2. leave the

Re: $$Excel-Macros$$ Help on gathering duplicate summing and counting

2012-02-20 Thread dguillett1
(Cells(i + 1, g)) + Val(Cells(i, g)) Rows(i + 1).Delete End If Next i End Sub Don Guillett SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Monday, February 20, 2012 11:11 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help on gathering duplicate summing