Macro to total values with certain criteria...
 

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 a 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

Macro to total values with certain criteria...
 

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/2...le-parameters/

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

"neilcarden" wrote in message
...

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 a 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|
+-------------------------------------------------------------------+



--
neilcarden

Hey bernard...

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

Cheers
Neil