This is how each sheet is setup
CID ORGANIZATION SALE_AMOUNT PUBLISHER_COMMISSION
746688 XYX 38990.33 5848.64
7837 BBBBB 10848.36 1301.81
1160017 ABCD 6252.26 750.27
So, I have 2 sheets, one with information from Dec 04 and another Dec
05... So on the third sheet I would compare both.
But the 2 sheets are not exact the same, some affiliates are in one but
not the other, I need something that will look at each affiliate ID and
then get the sales value from each sheet and put it side by side on the
third sheet.
Does it make sense?
Thanks
--
skuba
------------------------------------------------------------------------
skuba's Profile:
http://www.excelforum.com/member.php...fo&userid=6696
View this thread:
http://www.excelforum.com/showthread...hreadid=503110