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 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 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 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