Re: $$Excel-Macros$$ Concatenation / Consolidate Based on Condition

2011-11-01 Thread dguillett1
Cells(i, "e") & ", " & Cells(i + 1, "e") Rows(i + 1).Delete End If Cells(i, "e").Replace Cells(i, "d"), "" Next i End Sub Don Guillett SalesAid Software dguille...@gmail.com From: Sundarvelan N Sent: Tuesday, November 01, 2011 1

Re: $$Excel-Macros$$ Concatenation / Consolidate Based on Condition

2011-11-01 Thread Sam Mathai Chacko
Here's one that takes care of both the unique list and the concatenation Regards, Sam Mathai Chacko On Tue, Nov 1, 2011 at 9:11 AM, Sundarvelan N wrote: > Asish Thankyou so much! > > Very Very Thanks > Thanks > N.Sundarvelan > 9600160150 > > > > On Tue, Nov 1, 2011 at 12:37 PM, ash

Re: $$Excel-Macros$$ Concatenation / Consolidate Based on Condition

2011-11-01 Thread Sundarvelan N
Asish Thankyou so much! Very Very Thanks Thanks N.Sundarvelan 9600160150 On Tue, Nov 1, 2011 at 12:37 PM, ashish koul wrote: > check if it helps > > > On Tue, Nov 1, 2011 at 12:03 PM, Sundarvelan N wrote: > >> Hi Frineds, >> >> Please find the attached file for your reference. I

Re: $$Excel-Macros$$ Concatenation / Consolidate Based on Condition

2011-11-01 Thread ashish koul
check if it helps On Tue, Nov 1, 2011 at 12:03 PM, Sundarvelan N wrote: > Hi Frineds, > > Please find the attached file for your reference. I need to concatinate / > Consolidate based on condition. > > FORMULA or by MACRO > Thanks > N.Sundarvelan > 9600160150 > > -- > FORUM RULES (925+ members

$$Excel-Macros$$ Concatenation / Consolidate Based on Condition

2011-10-31 Thread Sundarvelan N
Hi Frineds, Please find the attached file for your reference. I need to concatinate / Consolidate based on condition. FORMULA or by MACRO Thanks N.Sundarvelan 9600160150 -- FORUM RULES (925+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like