View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vijay Joshi Vijay Joshi is offline
external usenet poster
 
Posts: 1
Default Sum of selected cells from different sheets in a new workbook

I have the productwise data of sales in different sheets. The sheets are the
basically the months. The products are categorised according to their end
use. e.g. TV, Music system will be classified as Electronic goods, where as
cricket bat, football will be categorised as Sports material. These details
are available Sales staff wise.
I want to have the output file with details of sale employee wise, monthwise
& categorywise.