have calculations from sheet one calculate in table on sheet two

[Guest]

I have a grocery list that I have calculations on show total, but need to
break down calculations by dept and would like this to show on sheet two
because sheet one I convert from an order to an invoice and down want break
down to show.

thanks
Earl

 

[stjori]

I have a grocery list that I have calculations on show total, but need to
break down calculations by dept and would like this to show on sheet two
because sheet one I convert from an order to an invoice and down want break
down to show.

thanks
Earl

Try using a pivot table on your second sheet.