Hi, vichisov,
if the data is set up in a way that all information is located on each single row a Pivot Table could be used to update the results. Maybe you can post some sample data in a workbook to have a look at in order to provide some code towards a solution.
Ciqo,
Holger
Bookmarks