Re: $$Excel-Macros$$ Create Uni Code

2011-12-28 Thread Aamir Shahzad
Thanks all of you. Aamir Shahzad On Thu, Dec 29, 2011 at 12:09 AM, Maries wrote: > *Use this formula, =CODE(LEFT(D2,1))&CODE(MID(D2,2,1))&CODE(MID(D2,3,1))* > > > On Wed, Dec 28, 2011 at 10:33 PM, Rohan wrote: > >> Aamir, range error. Corrected. Thank you ! >> >> Sub Macro1() >> >> >>Rang

Re: $$Excel-Macros$$ Create Uni Code

2011-12-28 Thread Maries
*Use this formula, =CODE(LEFT(D2,1))&CODE(MID(D2,2,1))&CODE(MID(D2,3,1))* On Wed, Dec 28, 2011 at 10:33 PM, Rohan wrote: > Aamir, range error. Corrected. Thank you ! > > Sub Macro1() > > >Range("A1:B" & Cells(Rows.Count, "B").End(xlUp).Row).Select >Application.CutCopyMode = False > R

Re: $$Excel-Macros$$ Create Uni Code

2011-12-28 Thread Rohan
Aamir, range error. Corrected. Thank you ! Sub Macro1() Range("A1:B" & Cells(Rows.Count, "B").End(xlUp).Row).Select Application.CutCopyMode = False Range("C1:D" & Cells(Rows.Count, "D").End(xlUp).Row).AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range( _ "F1"), Unique:=T

Re: $$Excel-Macros$$ Create Uni Code

2011-12-28 Thread dguillett1
Correct RED for line wrap Don Guillett SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Wednesday, December 28, 2011 12:27 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Create Uni Code thanks for your response Dguillett1 & Rohan but when I run the m

RE: $$Excel-Macros$$ Create Uni Code

2011-12-28 Thread Rajan_Verma
See the attached From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: Dec/Tue/2011 04:08 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Create Uni Code Dear Group, If I have some names & I want to create

Re: $$Excel-Macros$$ Create Uni Code

2011-12-28 Thread Aamir Shahzad
thanks viper. On Wed, Dec 28, 2011 at 12:34 PM, The Viper wrote: > see the attachment if you want to do it with combination of functions > > > > On Wed, Dec 28, 2011 at 11:57 AM, Aamir Shahzad > wrote: > >> thanks for your response Dguillett1 & Rohan but when I run the macro its >> shows attac

Re: $$Excel-Macros$$ Create Uni Code

2011-12-27 Thread The Viper
see the attachment if you want to do it with combination of functions On Wed, Dec 28, 2011 at 11:57 AM, Aamir Shahzad wrote: > thanks for your response Dguillett1 & Rohan but when I run the macro its > shows attached error. Please see the issue. And I don't want to remove the > duplicates if na

Re: $$Excel-Macros$$ Create Uni Code

2011-12-27 Thread Maries
*Remove Duplicates:* Sub Macro1() ' ' Macro1 Macro ' ' Range("C1:D26").Select ActiveSheet.Range("$C$1:$D$26").RemoveDuplicates Columns:=Array(1, 2), Header:=xlYes End Sub Regards, MARIES. On Tue, Dec 27, 2011 at 11:50 PM, Rohan wrote: > One more way of doing it... > > Sub Macro1() > >

Re: $$Excel-Macros$$ Create Uni Code

2011-12-27 Thread Rohan
One more way of doing it... Sub Macro1() Range("A1:B" & Cells(Rows.Count, "B").End(xlUp).Row).Select Application.CutCopyMode = False Range("A1:B" & Cells(Rows.Count, "B").End(xlUp).Row).AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range( _ "F1"), Unique:=True Columns(

Re: $$Excel-Macros$$ Create Uni Code

2011-12-27 Thread dguillett1
lumns("I").AutoFit Range("H2") = 1 Range("H3") = 2 Range("H2:H3").AutoFill Destination:= _ Range("H2:H" & Cells(Rows.Count, "H").End(xlUp).Row) End Sub Don Guillett SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Tuesday, De

$$Excel-Macros$$ Create Uni Code

2011-12-27 Thread Aamir Shahzad
Dear Group, If I have some names & I want to create the unique codes how do I? I am using code function but it creates some duplicates. Please see the attached file & suggest. Regards, -- Regards, Aamir Shahzad -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accu