Miss Ellie,

A pivot table should be able to do what you describe - there are a lot of pages that will help you
get started. If you need specific help, post a very small sample of your data....

HTH,
Bernie
MS Excel MVP


"Miss Ellie" <Miss wrote in message
...
I need to create a spreadsheet that compares two different data base reports
from our software program. One is an open PO report, the other is an open
order report. Then end result is to be a report that shows the project number
that is open, quantity on PO, and then breaks out how much each distributor
has on order, how many royalty (free) items we are sending out, and what the
balance is for all other orders. Any ideas?