From: Siraj Momin (BTG)
Sent: Monday, September 17, 2012 7:23 AM
To: 'excel-macros@googlegroups.com'
Subject: RE: FW: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C
WITH COLUMN E AND G AND UPDATE THE VALUES.
Hi prince
May be I did not explain you properly see the attachment
Sorry,
I actually wrote this last week, but evidently never posted it!
I noticed that your code example and your sample file and description is
different.
you SAID that if you find a match, you want to replace B with F and D with H
but in your code:
Cells(r1, f) = Cells(r, b)
Cells(r1, h) =
ANY SOLUTION POSSIBLE
SIRAJ
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Siraj Momin (BTG)
Sent: Monday, September 10, 2012 5:41 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ MATCHING THE VALUE OF COLUMN A AND C WITH
COLUMN E
Hi Siraj,
As i saw u r using loop on the rang which runs fine on small amount of data
but in case of large amount of data it will take huge time to process so
do one thing instead of looping on the range get all data in an Array then
apply same logic as u r doing one the range.
Or
Please
Hi prince
May be I did not explain you properly see the attachment for requirement
Siraj
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of Prince Dubey
Sent: Sunday, September 16, 2012 8:47 PM
To: excel-macros@googlegroups.com
Cc: Prince Dubey;