Dear Sir,
Thanks for your support it working fine. Once again thank you. Thanks & Regards, Prajakt Pande +971551388482 ** On Wed, May 9, 2012 at 10:33 PM, dguillett1 <dguille...@gmail.com> wrote: > > This does each number in col R only ONCE. > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Prajakt Pande <prajakt.pa...@gmail.com> > *Sent:* Wednesday, May 09, 2012 11:44 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ repeat action as per filter > > Dear, > > You are 100% right, but sir, 3 bar code are pasted twise, i dont know why > can have a look on this. > > attached sheet for your kind consideration. > > Thanks & Regards, > Prajakt Pande > +971551388482 > ** > > > > On Tue, May 8, 2012 at 8:21 PM, dguillett1 <dguille...@gmail.com> wrote: > >> See attached based on your original sample. >> >> Don Guillett >> Microsoft MVP Excel >> SalesAid Software >> dguille...@gmail.com >> >> *From:* Prajakt Pande <prajakt.pa...@gmail.com> >> *Sent:* Tuesday, May 08, 2012 8:31 AM >> *To:* MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> >> *Subject:* Re: $$Excel-Macros$$ repeat action as per filter >> >> >> Dear, >> >> yes you are Absolutely right. if more than 62 then it will paste for >> that much time. >> >> >> it need to copy from Column A to Column O >> >> >> >> In detail, >> >> >> >> Macro supposed to filter data, start from lowest number (not equal to 0) >> copy apart from row one. and paste it in to next sheet. >> >> If from filter select 1 then paste only for one time, if two then two >> time, if three then three time, and so on till the selection get over. >> >> >> >> Attached sheet for ready reference. >> >> >> >> Thanks & Regards, >> Prajakt Pande >> +971551388482 >> ** >> >> >> >> On Mon, May 7, 2012 at 10:44 PM, dguillett1 <dguille...@gmail.com> wrote: >> >>> I don’t want to use Skype. Only email. >>> >>> Your illustration used 2,4,6,12 >>> So, if in column R you have 62 of one item you want it copied 62 times >>> >>> and if you have 3 it results in >>> 4 12459 6 12461 >>> So you want >>> 4 12459 6 12461 4 12459 6 12461 4 12459 6 12461 >>> >>> Don Guillett >>> Microsoft MVP Excel >>> SalesAid Software >>> dguille...@gmail.com >>> >>> *From:* Prajakt Pande <prajakt.pa...@gmail.com> >>> *Sent:* Monday, May 07, 2012 12:06 PM >>> *To:* dguille...@gmail.com >>> *Subject:* Re: $$Excel-Macros$$ repeat ACTION AS PER FILTER >>> >>> Dear Sir, >>> >>> yes you are right, i want to do this for each item in col R. >>> >>> Do you have skype, Mine is prajakt.pande i think i can describe you in >>> better way. >>> >>> Thanks & Regards, >>> Prajakt Pande >>> +971551388482 >>> ** >>> >>> >>> >>> On Mon, May 7, 2012 at 6:42 PM, dguillett1 <dguille...@gmail.com> wrote: >>> >>>> Are you saying you want to do this for each item in col R or enter x >>>> for in col S for each to do >>>> CALCULATION 45 6 x 4 3 12 3 x 4 2 x 62 33 65 >>>> >>>> >>>> Don Guillett >>>> Microsoft MVP Excel >>>> SalesAid Software >>>> dguille...@gmail.com >>>> >>>> *From:* Prajakt Pande <prajakt.pa...@gmail.com> >>>> *Sent:* Monday, May 07, 2012 8:57 AM >>>> *To:* excel-macros@googlegroups.com >>>> *Subject:* Re: $$Excel-Macros$$ repeat ACTION AS PER FILTER >>>> >>>> Dear, >>>> >>>> Attached sheet with recorded macro. i think by this way i can explain >>>> you better. >>>> >>>> I am sorry for this. >>>> >>>> Thanks & Regards, >>>> Prajakt Pande >>>> +971551388482 >>>> ** >>>> >>>> >>>> >>>> On Mon, May 7, 2012 at 5:47 PM, dguillett1 <dguille...@gmail.com>wrote: >>>> >>>>> I do NOT understand your explanation..... >>>>> >>>>> Don Guillett >>>>> Microsoft MVP Excel >>>>> SalesAid Software >>>>> dguille...@gmail.com >>>>> >>>>> *From:* Prajakt Pande <prajakt.pa...@gmail.com> >>>>> *Sent:* Monday, May 07, 2012 8:20 AM >>>>> *To:* excel-macros@googlegroups.com >>>>> *Subject:* Re: $$Excel-Macros$$ repeat ACTION AS PER FILTER >>>>> >>>>> Dear, >>>>> >>>>> Please find enclosed herewith what you requested. >>>>> >>>>> i apologies for inconvenience, attached sheet for your reference. >>>>> >>>>> Thanks & Regards, >>>>> Prajakt Pande >>>>> +971551388482 >>>>> ** >>>>> >>>>> >>>>> >>>>> On Mon, May 7, 2012 at 5:01 PM, dguillett1 <dguille...@gmail.com>wrote: >>>>> >>>>>> Your sample only shows one row per number. You say copy to next >>>>>> file???. Pls provide larger representative sample and a better >>>>>> explanation. >>>>>> >>>>>> Don Guillett >>>>>> Microsoft MVP Excel >>>>>> SalesAid Software >>>>>> dguille...@gmail.com >>>>>> >>>>>> *From:* Prajakt Pande <prajakt.pa...@gmail.com> >>>>>> *Sent:* Monday, May 07, 2012 7:32 AM >>>>>> *To:* excel-macros@googlegroups.com >>>>>> *Subject:* $$Excel-Macros$$ repeat ACTION AS PER FILTER >>>>>> >>>>>> Dear All, >>>>>> >>>>>> Please help me in this. >>>>>> >>>>>> attached file for your reference. >>>>>> >>>>>> What I am looking for, >>>>>> 01) macro filter data by number 1,2,3,4,5,..... and so on >>>>>> 02) copy date paste it in to next file what ever the number filter by >>>>>> macro that many time repeat the action. >>>>>> >>>>>> Note:- it can't say filter will be in sequence it might be it will be >>>>>> in 1, 5, 45, 46, 48, 50, 95, 290 and so. >>>>>> >>>>>> >>>>>> -- >>>>>> 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 >> -- >> 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
