Learn

Civil Engineering Projects

Projects that involve both the construction or renovation of a structure or an alteration of part of the environment are considered part of civil engineering.

5  major civil engineering projects:
Water engineering.
Construction and management engineering.
Structural engineering.
Geotechnical engineering.
Transport engineering.

Macro 76: Create New Workbook for Each Report Filter Item

Macro 76: Create New Workbook for Each Report Filter Item Pivot tables provide an excellent mechanism to parse large data sets into separate files. You can build a PivotTable report, complete with aggregations and analysis, and then place a field (like Region) into the report filter. With the report filter, you can select each data

Macro 76: Create New Workbook for Each Report Filter Item Read More »

Macro 75: Print Pivot Table for Each Report Filter Item

Macro 75: Print Pivot Table for Each Report Filter Item Pivot tables provide an excellent mechanism to parse large data sets into printable files. You can build a PivotTable report, complete with aggregations and analysis, and then place a field (like Region) into the report filter. With the report filter, you can select each data

Macro 75: Print Pivot Table for Each Report Filter Item Read More »

Macro 73: Apply Pivot Field Restrictions

Macro 73: Apply Pivot Field Restrictions Like PivotTable restrictions, pivot field restrictions enable us to restrict the types of actions our users can take on the pivot fields in a PivotTable. The macro outlined in this section demonstrates some of the protection settings available via VBA. How it works The PivotField object exposes several properties

Macro 73: Apply Pivot Field Restrictions Read More »

Share knowledge