I have two different reports that have been exported from Quickbooks to
Excel 2007. Neither report contains all the data I need but a combination of
these 2 reports does. I would like to have all the needed data on one
spreadsheet. I need the data to line up correctly.

The data that has been imported is inventory items. Both reports have item
# and Description columns. One report has a quantity sold column while the
other report has quantity on hand column. I would like to have one report
with qty sold and qty on hand. The qty sold report only shows inventory
items that have been sold in a specified time frame while the qty on hand
report shows my entire inventory. I need this report to only show the
inventory items with sales activity.

What would be the most efficient way of doing this? Thanks.