I am a bit of a novice on Excel, so if you had covered this before, please indulge me.
I have access to two Excel files (both from different sources), assuming I saved them in the same spreadsheet (workbook) under their own sheet, how would I write a macro to do the following: Look-up by security identifer (either a symbol, CUSIP or other identifer) on one sheet then find it on the other sheet, once done, I would be comparing the number of shares (or par) amount, market price per share from one sheet to the other. Ideally the macro would create a third sheet displaying exceptions, showing the security identifer, share (or par) difference and/or market price per share difference for further investigation.
Any thoughts on what Excel functions would be best suited for Data Lookup and then comparison? Assume all data for each security is identified in a row and each sheet would have the columns arranged the same way (the securities in each row, may have been sorted differently, so the first security on one sheet, may or may not be the first security on the next sheet). There are about 300 individual securities to be compared (off the two criteria indicated).
Thanks
I have access to two Excel files (both from different sources), assuming I saved them in the same spreadsheet (workbook) under their own sheet, how would I write a macro to do the following: Look-up by security identifer (either a symbol, CUSIP or other identifer) on one sheet then find it on the other sheet, once done, I would be comparing the number of shares (or par) amount, market price per share from one sheet to the other. Ideally the macro would create a third sheet displaying exceptions, showing the security identifer, share (or par) difference and/or market price per share difference for further investigation.
Any thoughts on what Excel functions would be best suited for Data Lookup and then comparison? Assume all data for each security is identified in a row and each sheet would have the columns arranged the same way (the securities in each row, may have been sorted differently, so the first security on one sheet, may or may not be the first security on the next sheet). There are about 300 individual securities to be compared (off the two criteria indicated).
Thanks