Macro to total values with certain criteria...

[neilcarden]

Hi All,

I'm looking for a macro to sort my data on the 'Analysis' sheet, to
throw the totalled results on the 'results' sheet.

I want it to find all the instances of each persons toil accrued and
each persons toil taken and total them and put them on the second
sheet.

The columns to look at on the analysis sheet are: E- Name, H- number of
hours, using column C- either toil accrued or taken to work out the
totals.

Please see attached.

Thanks in advance


+-------------------------------------------------------------------+
|Filename: toil.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=101|
+-------------------------------------------------------------------+

 

[Bernard Liengme]

I do not think a macro is needed to do this but you have not clearly told us
how the data is arranged or the meaning of 'toil accrued - we can assume
this is hours of work or some other number.
Have a look at SUMPRODUCT
- in Excel Help
- http://www.xldynamic.com/source/xld.SUMPRODUCT.html
- http://mcgimpsey.com/excel/formulae/doubleneg.html
and at Pivot Tables
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
http://www.techonthenet.com/excel/pivottbls/index.htm
http://www.dicks-blog.com/archives/2005/06/23/download-pivottable-parameters/

then come back for more detailed answer
best wishes

 

[neilcarden]

Hey bernard...

Yeah i decided to use a pivot table. Thanks for your links though.

Cheers
Neil

I do not think a macro is needed to do this but you have not clearly
told us
how the data is arranged or the meaning of 'toil accrued - we can
assume
this is hours of work or some other number.
Have a look at SUMPRODUCT
- in Excel Help
- http://www.xldynamic.com/source/xld.SUMPRODUCT.html
- http://mcgimpsey.com/excel/formulae/doubleneg.html
and at Pivot Tables
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
http://www.techonthenet.com/excel/pivottbls/index.htm
http://tinyurl.com/27xcbl

then come back for more detailed answer
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

+-------------------------------------------------------------------+
+-------------------------------------------------------------------+