MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?


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