Message info
 
To:excel-macros@googlegroups.com From:Excel_Lover Subject:Re: $-Macros$$ To create a serial number based on some conditions using macro. Date:Mon, 7 May 2012 23:35:54 +0300
 

Yes, it will be sorted already.

On Mon, May 7, 2012 at 11:29 PM, Asa Rossoff <asa@lovetour.info> wrote:

Will the list already be sorted when the button is pressed?

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of 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:43 PM, Asa Rossoff <asa@lovetour.info> wrote:

Hi Excel_Lover,

When would you like the Req.No's to be generated? Should they be permanent numbers once calculated, or can the be recalculated at any time (for example with a formula)? Will the list always be sorted in the order you want used for Req.No. logic?

Asa

From: excel-macros@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 sheet with more clarification.

On Mon, May 7, 2012 at 2:43 PM, NOORAIN ANSARI <noorain.ansari@gmail.com> wrote:

Yes Mr. Excel_Lover,

Please provide more clarification.

--
Thanks & regards,
Noorain Ansari
www.noorainansari.com

On Mon, May 7, 2012 at 2:50 AM, Excel_Lover <idforexcel@gmail.com> wrote:

Dear All,

Appreciate an help to write a macro tocreate 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 generate code as shown in the sample.

Please find the below mentioned sample and attachedsheet for your reference, inwhich hilghlighted in yellow is the required result.

Req. No.

Name

Date

1001

FDFG

1-May-12

1001

DFDF

1-May-12

1001

GARS

1-May-12

1001

FGF

1-May-12

1001

DFGF

1-May-12

1002

SDESE

1-May-12

1003

SDD

2-May-12

1003

SDDDD

2-May-12

1003

SDDFFFFFF

2-May-12

1004

SDDDD

1004

SDFDFD

1004

SDFDFD

1004

SFDSFDS

1004

SDFDSF

1005

DSFDRRSR

1005

SFSRRRRR

1005

SFEWEETT

1005

DRERWEE

1005

SEREWTTTBH

Thanks in advance for your valuable helps.

--
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.

NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.

------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com



--
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.

NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.

------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com

--
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.

NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.

------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com

--
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.

NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.

------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com

--
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.

NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.

------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com

--
FORUM RULES (986+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.

NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.

------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com

--
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.
 
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com