Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

2014-03-25 Thread Deepak Rawat
Thanx for your kind suggestion, i am trying to learn the VBA On Tue, Mar 25, 2014 at 2:17 PM, Divaker Pandey wrote: > need to use both procedure for your requirement, you were using only one. > > and please try to learn vba wtih programming skill. > > it will help you understand other's progra

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

2014-03-24 Thread Deepak Rawat
Hi, Could u see the error.. Regards On Sun, Mar 23, 2014 at 6:29 PM, Deepak Rawat wrote: > i tried the code but giving ubound error, sample is attached, > kindly check > > > On Sun, Mar 23, 2014 at 6:19 PM, Deepak Rawat wrote: > >> Hi, >> i tried but not working but showing #Value! Error >> >

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

2014-03-23 Thread Deepak Rawat
Hi, i tried but not working but showing #Value! Error Pls look into... Regards, Deepak On Thu, Mar 20, 2014 at 5:33 PM, Divaker Pandey wrote: > use below code > > > Sub sortCellsValue() > Dim tempStr As String, resultSet As String > Dim tempstrArr() As String > > Dim i As Integer > For Ea

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

2014-03-20 Thread Divaker Pandey
use below code Sub sortCellsValue() Dim tempStr As String, resultSet As String Dim tempstrArr() As String Dim i As Integer For Each cl In ThisWorkbook.Sheets("Sheet1").Range("A2:A271") tempstrArr = Split(cl.Value, ",") tempstrArr = removeDuplicate(tempstrArr) For i = 0 To UBound(tempst

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

2014-03-20 Thread Deepak Rawat
Hi Dipanke, One more query i have, please do me favor I have lots of cells which contains duplicate comma desperated values like given below Audi, BMW, Audi BMW, BMW, Toyota Honda, Toyota, BMW, Honda After cleaning it should be look like below: Audi, BMW BMW, Toyota BMW, Honda, Toyota could

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

2014-03-20 Thread Deepak Rawat
Thanx a lot Divaker!! its working the way i need Regards, Deepak Rawat On Thu, Mar 20, 2014 at 2:40 PM, Divaker Pandey wrote: > use this macro > > > Sub sortCellsValue() > Dim tempStr As String, resultSet As String > Dim tempStrArr() As String > Dim i As Integer > For Each cl In ThisWorkboo

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

2014-03-20 Thread Divaker Pandey
use this macro Sub sortCellsValue() Dim tempStr As String, resultSet As String Dim tempStrArr() As String Dim i As Integer For Each cl In ThisWorkbook.Sheets("Sheet1").Range("A2:A271") tempStrArr = Split(cl.Value, ",") For i = 0 To UBound(tempStrArr) For j = i + 1 To UBound(tempStrA

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

2014-03-20 Thread Deepak Rawat
yes but its very time consuming to do mannually sort... On Thu, Mar 20, 2014 at 2:26 PM, VJ IR wrote: > Have u tried using text to columns?? > > Its a simple way to do so. > > Regards, > Vijay Iyer > On 20 Mar 2014 14:23, "Deepak Rawat" wrote: > >> Dear All, >> >> I have attached a sheet with

Re: $$Excel-Macros$$ Need Macro or a simple easy sorting technique

2014-03-20 Thread VJ IR
Have u tried using text to columns?? Its a simple way to do so. Regards, Vijay Iyer On 20 Mar 2014 14:23, "Deepak Rawat" wrote: > Dear All, > > I have attached a sheet with rawa data & final data. > > I need a macro to sort coma separated data in each cell, like example is > given below: > > N

$$Excel-Macros$$ Need Macro or a simple easy sorting technique

2014-03-20 Thread Deepak Rawat
Dear All, I have attached a sheet with rawa data & final data. I need a macro to sort coma separated data in each cell, like example is given below: NDTV, BBC, Aaj Tak, Facebook we need to change it as below *Aaj Tak, BBC, Facebook, NDTV* i have lots of data to sort, but not getting any solut