Don,
>From beginning, what I'm up to, I'm woking for production site, and from time
>to time we launching and delisting product from our current range. On this
>point I need to know what should I order or what I should stop ordering.
>Ordering is no issue but delisting is different kind of story. In order to
>delist product I need to check all ingedients that are going to the
>product check if they are used in different products and if are not just stop
>ordering them.
So if we are delisting 5 products and they are build from 50 ingredients each
it is a pain to go every BOM and check it one by one.
So what I realy want to have is list of the BOM to delist, with the list of BOM
list of ingredients (both done thanks to you), but as a simple guy, I've become
gridy and I'd like to ask you guys to help me to do check if the listed items
are used in different BOM and if they are to check if the product is live or
not. if it's live to check if is on the list of delisted product if is
there. if yes find next appirience for this ingredient in BOM EXPOLSION, when
it is found chech if its a live product if yes check if it's on the list for
delisting product if not put in outcome tab that this ingredient is LIVE.
So in simple words:
1. take first ingedient from tab "outcome" column "D" -> CBS232
2. go to "bom explosion report" check in col D if there is an item, if yes take
product code from col A -> DMRITD06
3. go to "delist" tab and check if product -> DMRITD06 is on the delisted
product list, if yes REPEAT step 2, if not
4. go to "outcome" tab and insert LIVE in column F
5. repeat step 1 to 4 until list of ingerdient in "outcome" tab col D is
finish.
Thanks in advice
Pawel
________________________________
From: dguillett1 <dguille...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Wednesday, February 15, 2012 4:12 PM
Subject: Re: $$Excel-Macros$$ bom explosion help needed
You are going to have to tell me which item and give examples.
Look for _________ in col_________ in ________ column_________, why__________
Don Guillett
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Wednesday, February 15, 2012 8:43 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ bom explosion help needed
Hi Don,
thanks again, I knew that my English could cause a problem. Wat I realy looking
for is: (see file "outcome" tab)
regards,
Pawel
________________________________
From: dguillett1 <dguille...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Wednesday, February 15, 2012 2:09 PM
Subject: Re: $$Excel-Macros$$ bom explosion help needed
It only requires a minor change from col e to col f
With .Range("a1:f" & lr)
See attached.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Wednesday, February 15, 2012 7:08 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ bom explosion help needed
Hi All,
Thanks to Don G. (I have this spreadsheet working on macro just fantastic,
thanks a lot Mate), but if you can help me add new extra fixture to it, it
could be awesome. What I’d like to do is:
In column F called “LIVE” (“outcome” tab) I’d like to have information, if the
item (“outcome” tab , column D – “Component Item”) is live or not. So it should
be picking item (in “component Item” tab) and looking for it in “Bom Explosion
Report”, when will be find it should pick from column “A” (“top level item”)
product code and check if it is on the list in “delisted” if it’s not, check if
in column “F” in “Bom Explosion Report” this product is live, if it is, go to
“outcome” tab and put across reference as “LIVE” in column “F”.
I had hope it understandable (English is not my native language pls excuse me)
and you will able to help me.
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
