SKR, start by pre-processing data in Excel before doing macros for this one. In your first workbook, use a VLookup function in column B to test whether column A value exists in second workbook. An If statement around the lookup can give you a zero/one result.
You can then filter for only non-matching values, and delete rows.
Let us know how you get on.
Paul V
Sent from my iPhone
On 25/09/2011, at 6:45, "SKR" <svkroy@yahoo.com> wrote:
> I understand that I have been too short in describing the requirement. Sorry for that. I have two workbooks, X & Y, both have comparable data in Sheet 1 column A, for each cell in Workbook X,Sheet 1, Col A, if cell value (integer) is not matching with Workbook Y,Sheet 1, Col A (for any of the cells in Column A), then delete the row containing that data in Workbook X only.
>
> --- In ExcelVBA@yahoogroups.com, "David Grugeon" <yahoo@...> wrote:
> >
> > 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
> >
>
>
[Non-text portions of this message have been removed]
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