Balancing totals from two workbooks

Closed
barrandray Posts 1 Registration date Wednesday February 20, 2013 Status Member Last seen February 20, 2013 - Feb 20, 2013 at 12:25 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 20, 2013 at 04:02 PM
Hello,

I have tried some pivots, some access but still no solution. I have data coming from two different sources. One has a breakdown for some companies and the other just has the totals for companies. They have unique company id numbers that I can use for comparisons. H E L P !

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Feb 20, 2013 at 04:02 PM
I think you need to provide more detail. In any case, you would be looking at either VLOOKUP or/and MATCH function of excel
0