calculate selected cells in workbook show results on seperate wor.

[vat7]

My workbook contains worksheets for each month with entries of at least 50
names in a column. Next to each name threre are amounts entered into cells in
the row. I would like to print an individual report of the total sum for each
name for each month. Can this be done and how? Thank you

 

[Frank Kabel]

Hi
if possible I'd suggest you change the spreadsheet layout to something
different:
- for each amount use a separate row
- that is you have a 'database table' layout with a column for:
-> Month/Date
-> Name
-> amount

After this you could use a pivot table to create your report. see:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm