| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare 2 Worksheets and return differences in a third. | Excel Worksheet Functions | |||
| Differences between values in two work sheets | New Users to Excel | |||
| How to return value from functions in other sheets? | Excel Worksheet Functions | |||
| need to compair two excell docs and find the changes | Excel Discussion (Misc queries) | |||
| Return all sheets to cell A1 | Excel Discussion (Misc queries) | |||
Hybrid Mode
