Menu:

• Home
• Beginners Guide
• Entering Data
• Editing Data
• Copy and Paste
• Drag and Drop
• + - / x Cells
• Formatting Cells
• Open Close Save
• Intermediate Guide
• Formulas
• Functions
• Copying
• Insert & Delete
• Sheets
• Printing
• Sorting
• Paste Special
• Replace
• Advanced Guide
• Split Columns
• vlookup
• sumif
• Pivot Tables
• Row Referencing
• Shortcuts
• Excel Templates
• Insurance
• Data Working
• Macro Examples
• Claims
• Monthly Variance
• I need Excel Help with
• Insurance
• Reinsurance
• Accounting
• Website Data Management
• Other
• Requests

Claims

This example of an excel  macro illustrates the use of pivot tables to reduce the manual allocation of outstanding claims by reinsurer.

It users the data working template as a start, with vlookup and pivot table functions  embedded in the macro. 

Click Outstanding Claims Reporting to download

Copyright © 2008 Excel Help