Aw shucks. Don Guillett SalesAid Software dguille...@gmail.com
From: pawel lupinski Sent: Friday, February 10, 2012 1:55 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ explosion maco needed pls you are the greatest from the greatest :) thanks Pawel From: dguillett1 <dguille...@gmail.com> To: excel-macros@googlegroups.com Sent: Friday, February 10, 2012 7:34 PM Subject: Re: $$Excel-Macros$$ explosion maco needed pls Even better to let you make a list from what’s available and use data validation to pick col B Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Friday, February 10, 2012 1:19 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ explosion maco needed pls yes - you are the one thanks again "the greatest Don" Pawel From: dguillett1 <dguille...@gmail.com> To: excel-macros@googlegroups.com Sent: Friday, February 10, 2012 7:16 PM Subject: Re: $$Excel-Macros$$ explosion maco needed pls If you want what I said in the 1st reply, this will do it. See attached Option Explicit Sub getlistings() Dim i As Long Dim lr As Long Sheet3.Rows(2).Resize(1000).Clear For i = 2 To Cells(Rows.Count, "b").End(xlUp).Row With Sheet1 lr = .Cells(Rows.Count, 1).End(xlUp).Row With .Range("a1:e" & lr) .AutoFilter Field:=1, Criteria1:=Cells(i, "b") .Offset(1).Copy Sheet3.Cells(Rows.Count, 1).End(xlUp)(2) .AutoFilter End With End With Next i End Sub Don Guillett SalesAid Software dguille...@gmail.com From: pawel lupinski Sent: Friday, February 10, 2012 12:25 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ explosion maco needed pls Hi All, could you help me on this one, I don't have a clue how to do it. This is a delisted product sheet, it will help me to know which ingredient not to order for future. How it should be working: I'll input in "delisted" tab a codes which product will be delisted (I don't know how many - 3,4,5 … or maybe 10 I don't know) In the "outcome" tab I'l like to have explosion mentioned above product (as you can see in "outcome" tab) one by one. It won't be a problem to do it on excel function but "bom explosion report" has 40,000 rows (I've deleted them due to the file size), so I'll need to have a macro for it. I'm not very good in it so I'm asking you for a help. Regards, Pawel -- 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