Databases

Hi Reeja

You need to construct a pivot table from your source data. When the source data changes you can update the pivottable with the REFRESH DATA command. The pivottable will then change and reanalyse the new data.

If your database comes from several spreadsheets, you could use the Data Consolidate command to take the data from the source sheets and total it. When your source sheets change, the same command will refresh the database.

Good luck!

Alan Burbridge