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 <dguille...@gmail.com> 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
<<wlEmoticon-nyahnyah>>
<<wlEmoticon-openmouthedsmile>>