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
