Re: $$Excel-Macros$$ explosion maco needed pls
thanks Mate From: dguillett1 To: excel-macros@googlegroups.com Sent: Friday, February 10, 2012 8:07 PM Subject: Re: $$Excel-Macros$$ explosion maco needed pls 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 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 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 t
Re: $$Excel-Macros$$ explosion maco needed pls
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 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 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. --
Re: $$Excel-Macros$$ explosion maco needed pls
you are the greatest from the greatest :) thanks Pawel From: dguillett1 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 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, ac
Re: $$Excel-Macros$$ explosion maco needed pls
yes - you are the one thanks again "the greatest Don" Pawel From: dguillett1 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
Re: $$Excel-Macros$$ explosion maco needed pls
Hi Don, Yes, my english is not up to speed so I'll clarify. In delisted tab I'd like to input manualy code b5:b16 - correct then I'd like to hits for each of them - correct C5:C16 and D5:D16 not inportant - correct Thank you "the greatest Don" :) Pawel From: dguillett1 To: excel-macros@googlegroups.com Sent: Friday, February 10, 2012 6:53 PM Subject: Re: $$Excel-Macros$$ explosion maco needed pls Let’s get a bit of clarification.. You want to list in delisted!b516 the codes. 3 shown now. Then you want all hits for each of the 3 codes. Do you want to further restrict by reference in c5:c16 or is that meaningless like the dates in d516 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 <><>
Re: $$Excel-Macros$$ explosion maco needed pls
Let’s get a bit of clarification.. You want to list in delisted!b516 the codes. 3 shown now. Then you want all hits for each of the 3 codes. Do you want to further restrict by reference in c5:c16 or is that meaningless like the dates in d516 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 <><>