Formulas in excel

M

Miss Ellie

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?
 
B

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top