Create Workbook from 2 Separate Queries

[Joy Holbrook]

I am trying to combine 2 separate queries into one workbook. I need all the information from one of the queries which includes PO #'s and then one column from the other workbook. The column I need to add to the first query is pertaining to amount left on PO's. I do not know how to set it up where it will add the column to the first query, and get the amounts to hit the correct PO#.

Note: I did not create the queries and I do not have access to make any change to them.

I am not very good at explaining so I hope that you understand my question.

 

[Sam Mathai Chacko]

A simple searching would have given you enough ideas. Did you try http://chandoo.org/wp/2010/02/19/excel-consolidate-data/

http://www.excelfox.com/forum/search.php?searchid=164615 also will give you a few methods, more specifically, http://www.excelfox.com/forum/f2/merge-workbooks-to-master-workbook-1478/