I have designed a simply spread sheet for accounting purposes. One of the worksheets, "Expense Detail" contains line information on each expense item organized by columns including "Transaction Date", "Vendor", "Description (of expense)", and classification columns which permit the recording of the type of expense such as "Advertising & Expense", "Amortization", "Delivery", etc. Naturally as the year progresses, more data expense information is added. Months and Quarters are subtotaled.

What I would like to do is to create a "Vendor Detail Report" in another worksheet taking the information recorded in the "Expense Detail" Worksheet and populating the new worksheet by vendor with each line item relative to each vendor. In addition, the report will also take the expense line value from the "Expense Detail" worksheet and record it in a column in the new "Vendor Detail" worksheet, next to the Vendor name called "Amount".

I am familiar with many excel formulas, but can't get around how to do this in excel.

I hope I have explained this sufficiently. Any assistance would be much appreciated.