ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   VBA Set of Calculations (https://www.excelbanter.com/excel-worksheet-functions/209229-vba-set-calculations.html)

Pam[_3_]

VBA Set of Calculations
 
Hi,

I have a spreadsheet for a count of days that a job is in each stage of
progress that is sorted by unit type for 2006-2008 and for each unit type I
need a series of calculations. For example, I need 2006 Total Jobs and 2006
Average Time and the same for each year.

Is there a way to automatically calculate this spreadsheet using code so I
don't have to go to each section to include the calculations needed?

If more info is needed, please let me know. I appreciate any help provided.
Thanks in advance,
Pam




All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com