thanks Mate
________________________________
From: dguillett1 <dguille...@gmail.com>
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
<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
--
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
