Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

2012-05-08 Thread Kris
Hi Sub kTest() Dim r As Range, s As String s = [c1].Text Set r = Range("c2:c" & Range("d" & Rows.Count).End(3).Row) With r .Cells(1).Offset(-1) = 0 .FormulaR1C1 = "=IF(R[-1]C[2]<>RC[2],R[-1]C+1,IF(COUNTIF(R2C5:RC[2],RC[2])>5,R[-1]C+1,IF(AND(RC[2]=

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

2012-05-07 Thread Excel_Lover
Sent:* Monday, May 07, 2012 1:18 PM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ To create a serial number based on some > conditions using macro. > > ** ** > > It should be assigned to a button. > > On Mon, May 7, 2012 at 10:4

RE: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

2012-05-07 Thread Asa Rossoff
acros$$ To create a serial number based on some conditions using macro. Dear Mr.Noorain, Please find the attached sheet with more clarification. On Mon, May 7, 2012 at 2:43 PM, NOORAIN ANSARI wrote: Yes Mr. Excel_Lover, Please provide more clarification. -- Thanks &

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

2012-05-07 Thread Excel_Lover
; *Sent:* Monday, May 07, 2012 6:48 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ To create a serial number based on some > conditions using macro. > > ** ** > > Dear Mr.Noorain, > > > > Please find the attached sheet with more clarific

RE: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

2012-05-07 Thread Asa Rossoff
acros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Excel_Lover Sent: Monday, May 07, 2012 6:48 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro. Dear Mr.Noorain, Please find the attached

RE: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

2012-05-07 Thread Rajan_Verma
-macros@googlegroups.com] On Behalf Of Excel_Lover Sent: 08 May 2012 12:57 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro. Dear Rajan, Thanks for your effort, I was seeking for a macro solution for this. How is

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

2012-05-07 Thread Excel_Lover
Excel_Lover > *Sent:* 07 May 2012 2:50 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ To create a serial number based on some > conditions using macro. > > ** ** > > Dear All, > > > > Appreciate an help to write a macro to crea

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

2012-05-07 Thread NOORAIN ANSARI
Yes Mr. Excel_Lover, Please provide more clarification. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, May 7, 2012 at 2:50 AM, Excel_Lover wrote: > Dear All, > > Appreciate an help to write a macro to create a request number as per the > bel

Re: $$Excel-Macros$$ To create a serial number based on some conditions using macro.

2012-05-07 Thread Excel_Lover
Was my question not clear? On Mon, May 7, 2012 at 12:20 AM, Excel_Lover wrote: > Dear All, > > Appreciate an help to write a macro to create a request number as per the > below condition. > > for each name on the same date should be a same request number, but should > not be repeated more than

$$Excel-Macros$$ To create a serial number based on some conditions using macro.

2012-05-06 Thread Excel_Lover
Dear All, Appreciate an help to write a macro to create a request number as per the below condition. for each name on the same date should be a same request number, but should not be repeated more than five times. Important: If the date column is blank and Name column having data macro should g