G
Gameware
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.
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.