ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Compair two sheets and return differences (https://www.excelbanter.com/excel-discussion-misc-queries/173751-compair-two-sheets-return-differences.html)

Don

Compair two sheets and return differences
 
I have two sheets with data. The first sheet is from one application with
dollars and a key number (like CUSIP). The second file is the same but from
another system. I want to recon these but do it through a macro. I can
create a macro to sort each by cusip and amount , but I want to read one
record and compair cusip + amount and if the same then to to the next record.
If different , then write it to a separate sheet.

Do I have to use VB for this and if yes, can it be without buying VB.
Someone said newer releases of Excel does not have VB to work with?


All times are GMT +1. The time now is 12:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com