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
>
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