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