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
