D
Don
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?
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?