We need some more information about what you are trying to achieve.
To simplify my explanation of what we want I shall refer to the two sheets
as X and Y
Do you want to test each cell in col A of X against each cell of A in Y or
just against the cell in the same row in Y?
Do you want to delete the complete row in X or in Y or in Both?
There could be other questions depending on your reply but that will do for
now.
Best Regards
David Grugeon
Excel VBA Group Moderator
-----Original Message-----
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On Behalf
Of SKR
Sent: Friday, 23 September 2011 9:27 PM
To: ExcelVBA@yahoogroups.com
Subject: [ExcelVBA] Comparing Data across Workbooks !
Im trying to compare integers in Workbook1,sheet1, Column A data with
Workbook2,Sheet1,Column A Data.If not matching then delete row.Please help.
------------------------------------
----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go
here: http://www.mousetrax.com/techtrax to enter the ezine, then search the
ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------Yahoo! Groups Links
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar