have calculations from sheet one calculate in table on sheet two

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

Try using a pivot table on your second sheet.
 
Back
Top