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 4478 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 !

Balancing totals from two workbooks
Transfer data from one excel workbook to another automatically - Guide
Copy data from one workbook to another vba - Guide
Vba copy from one workbook to another - Guide
Macro to copy data from one workbook to another based on criteria ✓ - Excel Forum
Transfer data from one excel workbook to another automatically based on criteria ✓ - Excel Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

Macro-Copy data from one workbook to another

Generate excel workbooks based on excel list

Macro to copy data to new workbooks based on condition

Excel - A macro to create new workbook and copy data

Copy Worksheet to another Workbook (unopened)

Similar discussions

Subscribe To Our Newsletter!