have calculations from sheet one calculate in table on sheet two
 

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

have calculations from sheet one calculate in table on sheet two
 

On Aug 29, 6:06 pm, earl wrote:
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.