I've got 2 separate Excel files with a monthly listing of client Stock Portfolio choices. I want to be able to compare the two separate lists and have excel identify the changes between different months (outputs).
I can't use a pivot table because its stock symbols (so no numbers).....any ideas?
Also, if you know how to incorporate into Misc. Access that would be helpful as well.
I can't use a pivot table because its stock symbols (so no numbers).....any ideas?
Also, if you know how to incorporate into Misc. Access that would be helpful as well.