So, I guess to do this I have to order both reports by affiliate ID, so
I can actually compare sales from each month.
But, is there way to do this automatically?
for instance, look at a certain affiliate, locate it on the first
report and copy the sales, then go to the next sheet locate the same
affiliate ID and copy the sales from that month?

Or do I have to manually put them in ID order and then copy them side
by side?

Thanks


--
skuba
------------------------------------------------------------------------
skuba's Profile: http://www.excelforum.com/member.php...fo&userid=6696
View this thread: http://www.excelforum.com/showthread...hreadid=503110