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 <a...@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.ans...@gmail.com> wrote: Yes Mr. Excel_Lover, Please provide more clarification. -- Thanks & regards, Noorain Ansari www.noorainansari.com <http://www.noorainansari.com/> <http://www.excelmacroworld.blogspot.com/> www.excelmacroworld.blogspot.com On Mon, May 7, 2012 at 2:50 AM, Excel_Lover <idforex...@gmail.com> 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 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 attached sheet for your reference, in which 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
