Yes, it will be sorted already. On Mon, May 7, 2012 at 11:29 PM, Asa Rossoff <a...@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 <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 **** > > 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 > -- 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
