Archive of Mr Excel Message Board

Back to Pivot Tables in Excel archive index
Back to archive home

i need help making a report from range of data

Posted by rainy on July 16, 2001 8:43 AM

i have a range of data that looks like this:
product id, expense code, expense value

and i need to make a profits report that has this rows:
income
production expenses
marketing expenses
and so on.. when each expense has its on code on the data.

do i need to loop on every cell to get the data for
the report or there is an easier way?

Re: i need help making a report from range of data

Posted by lenze on July 16, 2001 9:15 AM

You should be able to get the results you want with a pivot table report

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.