Let me see your file(s) after you redo it.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Darwin Chan
Sent: Friday, October 28, 2011 9:55 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Compare the data across different sheets and put
into one sheet
Thanks Don,
Your template gives me more insight on VBA code!
As I found the whole code is different to reexamine, I revise the documents
into one with more concrete requirement, hope that everyone can easily
understand.
Thanks again!
Darwin Chan
2011/10/28 dguillett1 <dguille...@gmail.com>
If you are talking about the ci file deleting rows based on filtering then
make a list and NAME it with an automatic defined name such as mylist and fill
in the list to delete and fire this. See attached file. I have done this in the
ci file but you can modify to run from the other file.
Sub DeleteRowsCol_I_SAS()
With Sheets("ci")
lr = .Cells(Rows.Count, 1).End(xlUp).Row
.Range("I1") = "VAL"
.Range("I1:I" & lr).AdvancedFilter Action:=xlFilterInPlace, _
CriteriaRange:=Range("MYLIST"), Unique:=False
.Rows(2).Resize(lr).Delete
.Range("i1") = " "
.ShowAllData
End With
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Darwin Chan
Sent: Thursday, October 27, 2011 11:07 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Compare the data across different sheets and put
into one sheet
Dear all,
I get 1 task of changing the code written by predecessor to comparing the
data from several sheets.
1. In the sheets it use several times, I found the original very complicated,
can anyone suggest to simplify the code?
2. When execute the procedures, I found some errors, i think it may be due to
predecessor partly use macro recording.
Detail of how is the logic can be seen from the file.
Thanks in advance!
Darwin
--
FORUM RULES (925+ 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 (925+ 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 (925+ 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 (925+ 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
